Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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")'
in the action for activating the products you have to add the searchstring like this =('product Z'|'product Y')
regards,
MT
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
Hi MT,
I tried and it says “Error in expression” –see below–… Do you know why ?
Thks,dani
try it with the = at the beginning!!
Hi Magdalena,
I already tried, see picture attached.
Thks,dani
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")'
take away the = from the field name then it should work
Excellent !!!!!!!! It works now. many thanks !!!