Look Up table yes/no option

[vroofvbsc]

I need help on how to create a Look Up table. I want to use it in a different way then usual. I want a yes/ no look up table to manage all my different types with all the different visibility options.  The look up table would just be an excel that I can update and reload into my family without having to click through the 20+ different steel module types and modify the yes/ no visibility parameters. So I created an integer type parameter and each different type will have a different integer. I trialed it with one type and my formula errored out. Can anybody tell me what I did wrong. I have attached photos of the relevant parameters in my family and as well as my look up table excel.

[SteveKStafford]

Originally posted in April 2024 with no responses, did you resolve this? As recently as October 2023 Autodesk acknowledged that yes/no parameters were not working in lookup tables. THIS VIDEO might help otherwise?

It also appears to me that your the third image is creating a loop where the parameter is trying to evaluate itself. It's in your formula and it is the parameter name the formula is associated with. Formulas can reference other parameters but not itself.

Usually a lookup table is based on a type's "size" and then adjusting other parameters in response to the "size". In the case of a pipe fitting it reacts to the size of the connector and adjusts the values for all the other parameters the lookup table provides answers for.

[Mike.FORM]

For all your yes/no parameters you want to check, create a helper parameter that outputs a specific text value based on the yes/no.

Then use the check parameter in your lookup table formula.

[manishkr.vj]

Hi Steve,
This Video doesn't help