Hide choices based on criteria

Ask for Help
1

I have several choice fields with the same source. I want to hide that choice item if it already exists in 2 fields already.

My usage is for a team form where a player can only be selected a maximum of 2 times for any given match.

PS I also want to limit the number of times a player can be selected in a match using multiple criteria i.e. Maximum time a player can be selected for Singles, maximum times a player can be selected for Doubles and total maximum times a player can be selected.

2

The only way I can think of to do that would be with a Custom Form. With a Custom form you would be writing the choice values to User Specific columns, so you could use those in Data Editor logic to apply the filtering, like so:

  • Use a Make Array column to create a single array from all of the target User Specific columns
  • In your Choices table, create a multiple relation that matches each choice with the Make Array column
  • Do a rollup through that relation to obtain a count
  • You can now use the rollup as a filter on each choice component (eg. “count is less than 3”)
1 Like