I am trying to cycle through multiple fields at once to check if they match a certain value. For example, a document contains field_1, field_2, field_3 ect. They either have a value of “Yes” or “No”.
The statement would be read like this:
IF field_1 OR field_2 OR field_3 = “Yes”
I am not trying to test if ALL fields are = to YES. They should be checked independently.
If it’s not too difficult, I would also like to create an IF statement to match 2 group of fields.
Example:
IF field_1 OR field_2 OR field_3 = “YES” AND other_1 OR other_2 OR other_3 = “NO”
Subject:
Our C2 CRM works on-top of Lotus. So all code follows the same syntax. We just have to enclose it in brackets, which is the only difference.
Subject: I don’t know your C2 CRM system
But the formula I gave works in places where you can use @functions.
You do have two {{ and }} so maybe that is your problem.
Subject: thank you but syntax doesn’t work
Thank you. I am trying to add this to a workflow by enclosing it in brackets {{ }}:
{{@if(product_1:product_2:product_3:product_4:product_5:product_6:product_7:product_8:product_9=“AGITAN 155”;“Y”;“N”)}}
But for some reason, it does not return the value “Y” even though one of the above products have the name i specified. What could I be doing wrong.
Subject:
Sorry are you trying to us this in Lotusscript? Or something else. As the syntax does work, I tested it before posting.
Subject: Not too difficult
@If(Field1:Field2:Field3:Field4=“ValueCheck”;@true;@false)
@If((Field1:Field2:Field3:Field4=“Yes”) | (Other1:Other2:Other3Other4=“No”) ;@true;@false)
Look in designer help for "Operations on lists "