Hi I have some parameters within a door family which are yes/no parameters.
I want to schedule what parameters are ticked on, I have done this by creating a separate parameter with an if formula which works. BUT if several of the parameters are ticked i want then to come up with a comma between them.
Example (same formula different parameters):
(if(Oranges, "Orange Bananas", if(Red Peppers, "Red", if(Yellow Peppers, "Yellow", if(HNW_Door_PushPull, "Push Pull", "-")))))
The output I get if i select one is correct, but if i select two I want to get all the ticked elements with a comma in between; "Orange, Red, Yellow"
Any ideas how the formula would be to achieve this?
Gelöst! Gehe zur Lösung
Gelöst von Ilic.Andrej. Gehe zur Lösung
Gelöst von FAIR59. Gehe zur Lösung
if(and(Orange, Red, Yellow)...
The condition would be true if Orange, Red and Yellow are all checked. Is this what you are after?
You would need a long formula to cover all conditions. Why not use a combined parameter in the schedule?
No need to have complex formula, you can let Revit do the work for you in the schedule.
All done
In case you choose to do it with one formula:
if (and(Oranges,Red Peppers,Yellow Peppers,HNW_Door_PushPull),
"Orange Bananas,Red,Yellow,Push Pull",
if (and(Oranges,Red Peppers,Yellow Peppers),
"Orange Bananas,Red,Yellow",
if (and(Oranges,Red Peppers),
"Orange Bananas,Red",
if (Oranges,
"Orange Bananas",
if (Red Peppers,
"Red",
if (Yellow Peppers,
"Yellow",
if (HNW_Door_PushPull,
"Push Pull",
"-"
)
)
)
)
)
)
)
The condensed:
if (and(Oranges,Red Peppers,Yellow Peppers,HNW_Door_PushPull),"Orange Bananas,Red,Yellow,Push Pull",if (and(Oranges,Red Peppers,Yellow Peppers),"Orange Bananas,Red,Yellow",if (and(Oranges,Red Peppers),"Orange Bananas,Red",if (Oranges,"Orange Bananas",if (Red Peppers,"Red",if (Yellow Peppers,"Yellow",if (HNW_Door_PushPull,"Push Pull","-")))))))
Andrej Ilić
phonetical: ændreɪ ilich
MSc Arch
Autodesk Expert Elite Alumni
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.