in this case you need a field trigger for each of these listboxes, thought you wanted this in your load script. in all 3 Triggers use set Variable as action, which all set vCondition. The above formula will return also possible values and not only selected values. If you don't want unselected fieldvalues in this variable, modify it for example to:
=if(getselectedcount(FiscalYear) > 0, concat(distinct FiscalYear,'/') & if(getselectedcount(FiscalYear) >0, '/') ) & if( getselectedcount(FiscalYear) >0, concat(distinct FiscalYear,'/'))
But if this works depends on what you need the variable value for.
I do want this in the load script but you mentioned adding an action to a button and I don't want that. is there a way to add it to my load script without using a button? or did I misunderstand you?
As I have been working on this I tried another angle and I have created and loaded a table with all the target values I need. There are two columns > Condition and TargetHow would I match the fields chosen by the user to the condition column?
User chooses SubRegion > EMCIE, Quarter > Q2, GBU > ABS from the associated listboxes.
My condition is EMCIEQ2ABS.
How do I tell the filters chosen to go look up and match the value in the Condition column?
I was able to get the selected fields using
This returns the same value as above: EMCIEQ2ABS.
However if I try to use the statement
it always returns 0 instead of the Target value unless I manually select the matching field in the Condition listbox.
I need the filters selected to go select the corresponding value in the Condition box. This is where I'm stumped.