Hello peeps, I'm having an issue with look up table. I'm no pro i'm on revit 2018.3 and my question is if its possible to create a look up table to also contain text and numbers. My goal is to create a look up table with for instance a ball valve family, so this family will have different sizes and i want the part number to change with the size. This what i have so far. My look up table works perfect but i'm scratching my head trying to add text with number for product numbers. I know it should be in length or inches. Any help will be greatly appreciated.
Gelöst! Gehe zur Lösung
Gelöst von Jes_Gonzalez. Gehe zur Lösung
Might be too convoluted, but you could do an integer which would be evaluated through an if statement in the family to return a text value.
if(integer=1, "N1", if(integer=2, "S3, if(integer=3, "U7", ....
I was looking for something anyone can edit with knowing much of revit families. Goal is to have a look up table along with part ids and as they change have someone edit and reload the look up table.
Figured it out.
Make sure to add your text on the 1 column like the highlighted.
size_lookup(Look Up Table, " ", " ", D)
Huh? Not sure I understand your solution. What does size_lookup(Look Up Table, " ", " ", D) do? It's not an evaluation. What value is returned?
Sorry, I wanted to use a look up table to keep track of product number that consisted of number and text. So for instance if i have 1/4" valve it will retrieve HPH25 and autosize to whatever the pipe diameter is. So in the future if we need to change/update product numbers all we have to do is update the .csv file and reload the family.
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.