Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following action assigned to my text object...
Action - Select in Field
Field - [Property Type]
Search String - =if(vshow = 'HO', 'General Needs')
This works absolutely fine but I want to add two more property types to the search string and just can't seem to get the logic right. Is that possible? When the user is directed to the 'HO' sheet I want the property type within my Select Filters box to have already populated with 'General Needs', 'Older Persons' and 'Sheltered'.
Many thanks.
The syntax for multiple selections is:
("General Needs" | "Older Persons" | "Sheltered")
-Rob
Thanks for responding so quickly Rob. That works if I use that syntax on its own. How do I incorporate that with the...
=if(vshow = 'HO')? I've tried numerous combinations
Many thanks.
I believe it's:
=if(vshow = 'HO'), '("General Needs" | "Older Persons" | "Sheltered")'
Note that if() is returning a string in single quotes.
-Rob
I've had to make a slight amend to the syntax and it's now working...
=if(vshow = 'HO', '("General Needs" | "Older Persons" | "Sheltered")')
Many thanks.