formula text

formula text

kboschJGDNZ
Enthusiast Enthusiast
2,489 Views
8 Replies
Message 1 of 9

formula text

kboschJGDNZ
Enthusiast
Enthusiast

Hey

 

Is it possible to use a text parameter in a formula. I want a yes/no parameter to check whether a condition is met in another text parameter.

 

If(text=banana, yes,no)

 

Is this possible??. I'm only getting errors.

0 Likes
2,490 Views
8 Replies
Replies (8)
Message 2 of 9

kboschJGDNZ
Enthusiast
Enthusiast

I'm always struggling with text parameters. Is there also a way to combine the content of two text parameters? something like : text1 & text 2 

Message 3 of 9

ToanDN
Consultant
Consultant
You cannot use text to drive a formula. Use a yes/no, number, or integer instead. Go to the Revit Formula link in my signature below to entertain yourself.
0 Likes
Message 4 of 9

ToanDN
Consultant
Consultant
You don't need a formula to combine 2 text fields. If in family, use a label and add two fields in it, if in project schedule, use a combined parameter.
0 Likes
Message 5 of 9

kboschJGDNZ
Enthusiast
Enthusiast

I want to make a label that will check the strengthclasses of columns. A strengthclass is a combination of text and numbers like S275. If a column has the standard strenghclass it should hide that strengthclass. I can't figure out a way to get this working. 

0 Likes
Message 6 of 9

ToanDN
Consultant
Consultant

- Presume you already have the Strengthclass parameter (text)
- Create a Strengthclass_standard yes/No parameter.  (yes = standard met)
- Create a Strengthclass_report parameter (text). Use formula: if (Strengthclass_standard, " ", Strengthclass)

0 Likes
Message 7 of 9

kboschJGDNZ
Enthusiast
Enthusiast

Thanks for your reply... I've created a label with your setup, but still don't understand how it would work.

The following screenshot is from the label family:

 

Knipsel.JPG

When these are the occuring strengthclasses (S235 / S275 / S355)...how can you  hide the S235

I've tried to fill in a formula in the Strenghtclass standard row: not(StrengthClass="S235")

That however doesn't work

 

The "StrengthClass" parameter is a shared text parameter btw.

0 Likes
Message 8 of 9

kboschJGDNZ
Enthusiast
Enthusiast

if(StrengthClass="235",1=0,1=1) gives me a warning about the improper use of booleans

0 Likes
Message 9 of 9

ToanDN
Consultant
Consultant
I will get back to you on this tomorrow.