Cognito-forms – Three dropdown lists for voting – a team can only be selected once

cognito-forms

I have a list (dropdown) of 50 teams. People can vote for their preferred top team. I now need to add the same dropdown, where they can select their second choice. And then I need to add the same dropdown again, where they can select their third choice.

Is there a way that people can't select the same team in the three dropdown lists?

Or is there an other way?

Best Answer

I'm a developer with Cognito Forms.

You can set up a custom error message on your second and third Choice field that will check to see if their value or selected Choice option is the same, and if so an error is displayed.

I set up an example of this using three Choice fields labeled 'First Choice Field', 'Second Choice Field' and 'Third Choice Field'. I then used the following calculation in the custom error message.

=(FirstChoiceField = SecondChoiceField or FirstChoiceField = ThirdChoiceField)

This calculation checks the First Choice Field against the Second Choice Field to see if they are the same. It also checks the First Choice Field and the Third Choice field to see if they are the same. If they are then the error message that has been set up is displayed.

Related Solutions

Cognito-forms – Dynamically displaying content entered into a repeating section on a subsequent page

You can use the following to Print the records from page 1 to page 2.

=Form.FORMNAME.REPEATINGSECTIONAME.Where(ItemNumber =1).Select(FIELDNAME)+ Form.FORMNAME.REPEATINGSECTIONAME.Where(ItemNumber =2).Select(FIELDNAME)....N

This formula will be in each of your fields you want to be populated on the second page. You will need to repeat this for as many possible items you may have in you repeating section (Page 1). All your dynamic areas will need to be set to a condition to dynamically appear (for each):

=Form.FORMNAME.REPEATINGSECTIONAME.Where(ItemNumber =1).Contains(FIELDNAME!= null)

I hope this helps!

Cognito Forms – How to Have Conditional Settings Available When Using Choice Fields in Check Boxes

If you select Advanced Editor you can use this calculation

=Background.Contains("I am self employed")

The field will be visible whenever "I am self employed" is checked. If you want a field to show only when multiple criteria are selected you can use:

=Background.Contains("I am self employed") AND Background.Contains("I work for the CIA")

This will only show the field when both "I am self employed" and "I work for the CIA" is selected.

Best Answer

Related Solutions

Cognito-forms – Dynamically displaying content entered into a repeating section on a subsequent page

Cognito Forms – How to Have Conditional Settings Available When Using Choice Fields in Check Boxes

Related Topic