Clear Column Value when new Choice is selected

Hey Everyone!

Looking for some help with this.

  • We are using two choice components writing to user specific values to filter data displayed on a tab.
  • The data is not displayed until both choices are selected.
  • The second choice’s options are filtered depending on the selection of the first choice component.

The Problem
When the first choice is changed the second choice value remains the same until a new second option is selected.
Is it possible to clear the second choice component value when the first choice component is cleared or changed?

There are no actions on choice components, so there is no way to clear unless a button would be involved to execute an action.

Are you just filtering the second choice component? If so, I would probably use a relation instead and source the second choice component based on the relation. Then if you are involving visibility conditions to show the collection, you will have the advantage of checking if both choices are selected AND the relation is not empty.

1 Like

Thanks Jeff,

Yes we’ve ended up implementing something similar.

We have a relation column based on the first choice. And an IF column to determine if the second value is a relation to the first choice or not. If it is not a relation then the data is hidden.

Probably a cleaner way to do this but works for us.

1 Like