Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
two listboxen should be switched in dependence. If “Year” is selected, “FiscalYear” must be deselected. If “FiscalYear” is selected, “Year” must be not selected. Thanks for help.
Regards Stefan
Hi Stefan,
As DataNibbler said, you want to set Field Event triggers on both fields, so "OnSelect" you'll add an action to clear the opposing field. This can be found in the Settings > Document Properties then Triggers tab.
Example attached.
Hi Stefan,
try with some sheet-level triggers - add an action on both the fields [Year] and [FiscalYear], to clear any selections on the other field respectively.
HTH
Best regards,
DataNibbler
Hi Stefan,
As DataNibbler said, you want to set Field Event triggers on both fields, so "OnSelect" you'll add an action to clear the opposing field. This can be found in the Settings > Document Properties then Triggers tab.
Example attached.
Many thanks to DataNibbler and Aaron. Boxes works fine.
Stefan