I'm using Revit 2014, and would like to know if it's possible to make a lookup table that contains text that can be returned to my family? At the moment, I've got a functional lookup table that allows my family to be completely resized based on data from the .csv.
The idea I had was to be able to make one single rfa file to accomodate all the different model sizes so that we didn't need multiple files for each model in the series. Now, my family can be loaded into a project and be edited on the fly (e.g. change the outlet size and the appropriate model is made).
I want to take this further by allowing the different sizes to correspond to their appropriate model names and other details (voltage, phase etc). This part of my plan is to allow this data to be produced automatically along with the model upon resizing, so that whoever's working on the project doesn't have to manually pull out a product catalogue to check all the information (hence making my efforts so far pretty much worthless). So right now, what I'm trying to do is to see if the Lookup table can be used to return the model name, i.e. a text string?
For example, if A=1, then Model Name = "Mod", where "Mod" is taken directly from a table (so that I don't need to make a million nested IF statements to check the model name based on the value of A). Is this at all possible in Revit 2014? Another thing is if this can work, can that information be put into a schedule?
Solved! Go to Solution.
Solved by jigar.wsp. Go to Solution.
Hi Mate,
I am trying to do same thing with Air terminal and it read Type S1/S2..... basend on flow value and at same size it change size based on flow value but unfortunately Revit can't read text value.
The link below is frequently provided by Autodesk Support personnel here. Also, perhaps consider participating in the AUGI Wish List system.
Autodesk Product Support
The following link is setup for you to submit feature requests, or feedback, directly to our Development group:
http://usa.autodesk.com/adsk/servlet/index?siteID=123112&id=1109794
So it's not possible to use a text string for the LOOKUP - but what about the return?
I'm trying to do a lookup table looking at Electrical Current Value - and dependent on that numerical value, I want to return a text string.
Is that possible?
I aplogize, but that is what I was trying to do. My problem is formatting the header (Parameter Name##Type##Format) properly for text. I think I found the solution though:
Parameter_Name##Other
Am I correct? I haven't gotten around to testing that out just yet, but it's on my list today.
Sorry for the delay of response - I overlooked your post...
Anyway, unless it has changed in Revit 2015, Lookup Tables are not capable of returning a Text value. It has trouble with other types of values too, such as Voltage. I used a trick to get around that limitation (Voltage, not the Text) in the thread referenced below.
Sorry to disagree Corey but Lookup tables are capable of returning a text value. They will return the text value in the first column. Here's an example; size_lookup(Look, "", "NA", DN).
The 'trick' is to look for "" in the formula. This way Revit will return the text value of the first column. The parameter in the family needs to be text too.
Firstly, never be sorry to disagree!
I like this trick. So it only works for the first column of the Lookup Table, correct? To put it another way, I could not have two separate Text parameters referencing the same Lookup Table? If this is true, I suppose it is possible to overcome this by creating a separate Lookup Table for additional Text references.
Hi all,
Im having a similar problem.
I need to include the information attached but im not sure what im doing wrong because i keep getting pop ups saying that there are inconsistant units.
As you can see I need not onlt numbers but text too.
A couple of formulas ive used have been (but failed)
size_lookup(Lookup Table Name, "SK", 0, (Secondary Kit Description))
size_lookup(Lookup Table Name, "SK", 0, "SKD")
size_lookup(Lookup Table Name, "SK", "0", SKD)
Theory:
size_lookup(Lookup Table Name, "Value 1", Value 2, (Value 3,4,etc.))
I didn't mean to be misleading, you can only return text from the first column of a csv file. Only numbers will be returned from the other columns.
Using multiple lookup tables is one workaround for having more strings returned as Catastrophe mentioned. Personally I'm waiting to see what Revit 2016 will offer....
Hi, Just wondered if somebody could help me. I am trying to add a part code to a fitting depending on the pipe connection sizes? I would like for my part codes to be inserted into my tables and then for a formular to bring in the correct information. My proble is that the codes are a mixture of numbers and letter.
Could someone please give me a formular and also advise on how to set up my table accordingly.
Thanks.
Fábio Sato
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
There is not an Autodesk solution at this time, but I found a work around. I found this guide known as the "snook solution" and it works wonders.
https://andekan.com/returning-text-from-lookup-tables-in-revit/