We would love to hear from you on how we can improve your experience!
Frequently asked questions from our users
Google Forms does not have a native way to look up data from Google Sheets based on a respondent's selection, but you can use the Formfacade – Lookup Sheets add-on to implement lookup in Google Forms without any code. Unlike populating a dropdown, a lookup requires the form to query your sheet in real time when a respondent makes a selection. Apps Script does not support this within a native Google Form.
Read the full article →You can use Apps Script or the Formfacade - Lookup Sheets add-on to populate a dropdown in Google Forms from Google Sheets. If you are comfortable with code, Apps Script gives you a scriptable way to sync your sheet with your form. If you prefer a no-code approach, Formfacade – Lookup Sheets lets you connect your sheet and populate dropdown options using simple instructions in plain English or any language.
Read the full article →Google Forms does not support conditional dropdowns natively. All dropdown options are static and do not change based on a respondent's previous selection. You can use Google Forms' built-in Go to section feature as a workaround, or use the Formfacade - Lookup Sheets add-on to create true conditional dropdowns without any code. When a respondent selects an option in the first dropdown, the options in the second dropdown are automatically filtered based on that selection.
Read the full article →Google Forms does not have a native way to autofill fields from Google Sheets based on a respondent's selection, but you can use the Formfacade - Lookup Sheets add-on to implement autofill in Google Forms without any code. When a respondent selects or enters a value, multiple fields in the form are automatically populated with related data from your sheet in real time.
Read the full article →