Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
can anyone tell me how i can pass a selection from 1 list box on a sheet (inherited state) to another list box on another sheet (in state2).
I have attached an example.
in the example i have 2 alternate states, ignore State1 as this is used on another part of the qvw.
Thanks
Hi all,
for anyone else who needs to do this i have managed to get it working using an on activate sheet trigger.
see attached sample
Then you are back to
Then use a Trigger with action
Select in Field
myField
=concat({myFromState}distinct '"'&myField&'"' , '|') & ')'
Remember to change the STATE of the action to the state you want it to effect.
set the trigger on the TAB open Trigger.