I would like to make a button with an action that selects all possible in a certain customize listbox.
The expresion of my listbox is:
=if(operator= 'AAA' OR operator = 'BBB',Left(taskcardno,9))
Now for certain range of data selections, this listbox shows all possible options that I can select. With a button and an action I want to select these possible fields within this listbox. However the action 'Select Possible' seems limited. I cannot get the desired results. Any suggestions?
I think I would at first try to generate this field as a native field within the script. If operator and taskcardno are within the same table you could use:
...
if(Match(operator, 'AAA', 'BBB'),Left(taskcardno,9)) as taskcardno_Short