Printable View
I am trying to combine (2) text fields using a calculated value in my schedule. The two text fields are "Type Comments" and "Mark". We use these for tagging our equipment and would like to export the combined field to Excel.
Is this possible? Thanks in advance.
I would seriously doubt you can "calculate" between two text values. I would guess that the fields would at least have to be "number" or "integer" type.
You can not directly combine text strings. An interesting work around is that you can use a little math to display what you are looking for. By setting an integer value a text string can use a formula to check for a series of numbers with a nested IF statement.
Please see the attached image.
The formula I used is:
if(integer = 1, "Show text string 1", if(integer = 2, "Show text string 2", "ERROR"))
If you wanted additional notes you can keep adding to the nested IF statement.
Hope this helps.
Very Slick!!!Quote:
Originally Posted by archjake
Hello,
You can also add both parameters (because they are system params) to the label as shown here:
http://screencast.com/t/LGhOZ9cDFQ
Cheers,
Glynnis Patterson
www.ideatebimlink.com
Glynnis,Quote:
Originally Posted by glynnis.patterson
That example is for creating tags. The original question was for combining text strings in a schedule.
Folks, I actually do this all the time for special reporting needs and instances when I need more descriptive color code plan legends or descriptive report data. I create a "placeholder" parameter to receive the joined text, then I coincidentally use Glynnis's "BIMLink" tool to export my data out to excel format. Open in MS Access and manipulate the multiple text fields into whatever format/joining desirable. Re-import into Revit via BIMLink. The downside is the data is not dynamic and requires repeating these steps. But it only takes a couple of minutes which is negligible when I really need the customization to the legends or reports.
Coincidentally I also use the method described by Archjake (formula/variables) when there is a need for the data to behave dynamically in a true "BIM" fashion. I will admit this is the best way to go when time permits, the data is changing a lot, and there is a repetitive need.
Hope this helps.
Hey guys,
I'm trying to use an if/then statement in a door schedule using the Type Mark as the driver for the new parameter. No matter what it always returns the "Improper use of Boolean Expression" error. Is there anything special about using Type Mark in an if statement that might cause this? I know I've got my syntax right. I'd really appreciate some feedback if anyone knows what the issue is. Thanks!
Attachment 92726
Revit does not allow Text Parameters or strings to be used in conditional statements, so you cannot even use "Type Mark = Type Mark" as a conditional statement.Quote:
Originally Posted by haney8604551873
You Can combine 2 text fileds using dynamo (which add 2 parameter values in a 3rd parameter and this 3rd parameter is the one which is filtered by in the schedule then you can create a tag family by this 3rd parameter.
you can find attached image showing dynamo for this issue.Attachment 106085