Forum Discussion

Monica__DBH_Ham's avatar
Monica__DBH_Ham
Qrew Member
7 days ago

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

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

Forms
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    7 days ago

    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.