mdagostino
Novice

multi choice field

I have 6 choice fields (which individuals can select multiple choices). I want to restrict a department to choose only one option at a time instead of all.

I tried the validation for department=='sales' && inArray(choice field, 'Field 1' && 'Field 2' || 'Field 1' && 'Field 3') and so on.

How can I allow to select only one without changing the multi option choice?

Tags (2)
0 Kudos
Reply
2 Replies
soni_tumu
Apprentice

Re: multi choice field

Hello,

Can you try adding multi choice field and single choice field both to your form. Make single choice field to hide by default. And next if department == sales, then hide the multi choice thing and show the single choice section.

I didn't try this one, but just letting you know the thought. Try this if you can.

Reply
emha
Collaborator

Re: multi choice field

try following formula in validation rule:

department=='sales' && length(choice field) > 1   (choice field is optional)

department=='sales' && length(choice field) != 1  (choice field is mandatory)

Reply