Select in Field -> Search String -> If condition

[#1]

Is it possible to use if condition in search string of Select in field action? For example, I have Fields named NAME and ADDRESS. NAME has two values in them, [My Name] and [Firend Name]. When I do select in Field action for ADDRESS I want to check in serach string the value of NAME field first and then search.

Select in Field = ADDRESS

Search String = if(NAME = 'My Name', Address1, Address2)

The search string syntax with if statement is not working. Any thoughts?

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

Try something like the following expression

=If(Name='My Name', '(Address1|Address2)', 'Address3')

Hope this helps

[#3]

I tried this already as my search string is exactly like yours and it doesn't work. It selects nothing. I trigger the action on OnSelect of NAME field.

Field Event Trigger -> NAME -> OnSelect

Select in Field -> ADDRESS

Search String =if(NAME = 'My Name', 'Address1', 'Address2')

[#4]

OKAY, Never mind its working. I figured there was a Syntax error. Thanks For your help Miguel