Trigger select fields based on multiple variables

[Anonymous]

Hi there!

I have various variables e.g. $(vA), $(vB), $(vC) which can be set by the user.

I want to trigger a field selection on the field e.g. City so when the Tab is opened the values of the variables above will be selected.

I created a trigger in the tab. Interestingly it works for

='('&vA&')'

but i can't get a selection based on MORE than one var like

='('&vA&')'&' '&'('&vB&')'&' '&'('&vC&')'&' 

Any idea?

BR

Andreas

[MayilVahanan · Accepted solution]

HI,

     Try this,

     ='(*'&vA&'*|*'&vB&'*|*'&vC&'*)'

Hope it helps

[Anonymous]

Works like a charm