Using Logic to Autofill Other Fields in a Form
I have a form where a user would select options from a drop down. Ideally, like to setup logic so that when they select option D, there is another form field (let's just call it Field 2) that is then hidden and has its value set. There are other times when if they were to chose Option C, they would need to decide what choice to make in Field 2. Is this currently possible?
Answers
-
No, there currently isn't a way to set both of these types of Conditional Logic on the same form. You could either have it hidden, and only submit the default value if option D is chosen, OR you could have it hidden to then appear when option C is chosen to allow selections.
That said, although you can't build the logic directly into the form, there's a way to achieve your end goal by using the underling sheet capabilities!
What I'd do in this situation is set up the form to have Conditional Logic only showing Field 2 if Option C is chosen.
Then, set up a Change Cell Workflow when rows are added to the sheet which checks to see if Option D is chosen, and if it is, sets a specific value in the cell:
See: Change the Value of a Cell in an Automated Workflow
Will this work for you?
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 58 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!