Activate two fields in a text box

[danialier]

Hello,

I have a text box in Sheet A. By clicking this text box I want to move to Sheet B and by selecting two fields (product Z + product Y) on that Sheet B.

In order to activate Sheet B by clicking the text box in the Sheet A I just added an action -> activate sheet in this text box. That's ok.

In order to activate product Z in Sheet B by clicking the text box in the Sheet A I just added an action -> select in field (search string -> product Z) in this text box. That's ok.

However, the question is: how I can also activate product Y ???

Thanks,

dani

[#2]

in the action for activating the products you have to add the searchstring like this =('product Z'|'product Y')

regards,

MT

[jonathandienst]

Hi

I assume you mean two values from one field. In the select in field action use the syntax (A | B) in the search string.

HTH

Jonathan

[danialier]

Hi MT,

I tried and it says “Error in expression” –see below–… Do you know why ?

Thks,dani

[#5]

try it with the = at the beginning!!

[danialier]

Hi Magdalena,

I already tried, see picture attached.

Thks,dani

[sudeepkm · Accepted solution]

Please Try like below in Select in field action:

Field

Region (Remove equals sign from here just the field name)

(In my example Field name is Region)

Search String

='("ASIA PACIFIC" | "LATIN AMERICA")'

[#8]

take away the = from the field name then it should work

[danialier]

Excellent !!!!!!!! It works now. many thanks !!!