I have a Google form. There are six dropdowns. Each dropdown offers the same list of items (cities). I need to ensure the user selects a unique city from each dropdown. (It is mandatory to select at least one city. The rest are optional.)
The form is set up to allow users to resubmit (edit) their response. So whether they are submitting a response for the first time, or editing a response, I need to apply this validation.
I tried everything with the help of chatGPT but the form would always allow the user to submit their response even if it contained duplicate answers to the dropdowns.