Limiting selection choices on a multi-choice field based on what has already been selected

Question

I am trying to create a rule on a form that will compare the entries for multi-choice fields and if a choice is already selected, then it is not available for the current field selection. This way, a choice is not selected twice.

These are 5 ranking fields ( 1 - 5) - all with the same picklist. For ranking field 2, I want the rule to compare fields 1,3,4 and 5 and only display the picklist for 2 with the remaining available options.

Greatly appreciate any and all help and suggestions for doing this.

Thanks, Monica

MarkShnierYou · Answer

You cannot actually limit which fields will appear in a multiple choice field.

But I think you can prevent duplicate rankings using four form rules.

I will explain this using syntax from legacy forms, but there's probably similar functionality on new style forms, but I guess I don't know that for sure.

If ranking field 2 equals ranking field 1 then action is to change ranking field 2 to blank.

The next form rule would be if multiple conditions are true

Any of the following are true

Ranking field 3 equals ranking field 1

Ranking field 3 equals ranking field 2

Then action is to change ranking field three to blank.

... and then you keep going with the rules for ranking field 4 not being equal to any of ranking fields 3 2 or 1. And then similarly ranking field five is not equal to any of ranking fields for 4 3 2 or 1.

Sign up

Login to the community