Dependent Picklist in a Web Form

Chris Goodman

Is there way to have a dependent picklist in a webform? 

Travis

Hi Chris, I dont quite understand the question - could you please clarify? 

Maaik Meijerink

I asked the same question some time ago. I think/hope Chris means: a data driven picklist, just like the contactlist, but now based upon values from a sheet.

 

To get even more sophisticated: a cascading picklist/dropdownlist would be great:

Simple example:

- PL1. Picklist with Buildings

- PL2. Picklist with Floors within the selected building in PL1

- PL3. Picklist with Rooms within the selected Floor in PL2

 

Chris Goodman

Maaik - yes this was what I was looking for.

PL 1 - Grade

PL 2 - Classes offered (potential overlap between Grades)

PL 3 - Teachers of classes (potential overlap between Classes)

 

You're a mind reader.

Travis

Thanks for clarifying! This is possible using Google Forms and Smartsheet Sync. Google Forms allow you to set conditions for forms (If this is selected, show these options). Smartsheet Sync can add data entered from Google Forms, into a Smartsheet.

 

Here's information on how to set this up: http://help.smartsheet.com/customer/portal/articles/1850129