Select Multiple Options
Hello,
I built a scheduling tool that contains several countries that are organized into regions. You can choose one or multiple countries in a form to schedule an event. I'm trying to make it so that if I choose to schedule an event for an entire region or in all regions, the user doesn't have to select each country individually. So by choosing a region or all regions, all respective countries would be chosen. Is there a way to do this?
Thanks in advance for your help!
Best Answer
-
What I would do in this instance is have one multi-select dropdown per-region. Then you can set up Conditional Logic in your form to only show the Region Countries if it's selected:
The default for these country columns could be that all values are selected, meaning the form user would need to de-select any countries they don't want from that Region:
An alternative would be to have a Change Cell workflow on your underlying sheet, so the Form User could identify if they want to select ALL or manually choose a few.
If they opted to select an entire region, you could auto-fill the correct column with the workflow:
I hope that helps!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
What I would do in this instance is have one multi-select dropdown per-region. Then you can set up Conditional Logic in your form to only show the Region Countries if it's selected:
The default for these country columns could be that all values are selected, meaning the form user would need to de-select any countries they don't want from that Region:
An alternative would be to have a Change Cell workflow on your underlying sheet, so the Form User could identify if they want to select ALL or manually choose a few.
If they opted to select an entire region, you could auto-fill the correct column with the workflow:
I hope that helps!
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you! Those are some great ideas! I'll give them a try.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!