Dynamic Fields Add-on for Google Forms™ populates values of selection fields. Questions of type Multiple-choice, Drop-down, Checkbox or Grid can be updated by data from Sheets, Contacts or Groups.
Listing updated:July 24, 2023
Works with:
Create in Google Forms™ dynamic choice boxes with pre-filled answers. Populate and update values of Google Forms Questions of type Multiple-choice, Drop-down, Checkbox and Grid from different sources like Google Sheets™ , Google Contacts™ , Google Groups™  and more.

Supported Languages: 
- German
- English

Use Cases:
 - Update your Google Form™ dynamic questions with customer/supplier data from Google Sheets™.
 - Get all sales members as contact persons of a Google Group™ .
 - Make calendar events of the next month in Google Forms™ selectable.
 - Show your organizational units maintained in Google Workspace™ as responsible department.

Key Features:
 - populate and update values of choice boxes in Google Forms™ with dynamic drop-down, multiple-choice and checkboxes. 
- set choices of various Google Forms questions. Auto-filled automatically based on selected data source.
 - populate form lists and update the lists on a daily, weekly or monthly basis 
 - Connect to different data source for each question, e.g Google Sheets™,   Google Calendar™ events, Google Workspace™ User directory, Groups and Orgunits, Cloud SQL databases or via Web service io third party systems like CRM, Workflow etc.
 - Don't maintain changing values twice if they are already updated in your sheet, contact, group or third party application.
 - reduce maintaining efforts through Google Forms™ automation.
 - Through Google Forms™ auto-fill from spreadsheet gain more productivity by reusing your already in Google Docs™ maintained data.
- Import Sheet Data and read any data sets of your sheets into forms to pre-fill question answers
 - Load your centrally managed sheet data into various Google Forms™. No maintaining of redundant data in Google Forms ™.

Quick Start:
1. Choose Question - first go to menu item  "Add-ons" --> Dynamic Fields --> Create Mapping" and select a question where you like to create a mapping to insert values dynamically. Please be aware that only questions of type Drop-down, Multiple Choice, Grid, List and Checkbox are displayed for selection. 

2. Create Mapping - after choosing a question you can create a mapping to get values dynamically. First Choose a data source, e.g. a Google Sheet™. If you have selected a spreadsheet from your drive storage, you can select the relevant sheet and define a range or a  column of this sheet. To save mapping for the selected question just click the save button.

3. Update Mapping - Start processing to update values of "Update Mapping". If you are using Plus- or Business-Version you can activate a time based job over menu item "Settings" to update values several times a day automatically. An automatic update after a Google Forms™ submit is also possible.

Further information is available here: 

Help and Support:  
We are providing a short quick start guide and a detailed user manual. You can also contact our support team directly if you have any questions or problems. For more information please check out our support center:

Dynamic Fields is a popular Google Forms™ add-on available in the Google Workspace Marketplace™ for automating and prefill your forms. It is also an alternative to Form Ranger by New Visions Cloudlab or enhances great other popular add-ons like Form Publisher by Awesome Gapps or Form Builder by Jivrus. 
Additional information
PricingFree of charge with paid features
Privacy policy
Terms of service
Dynamic Fields - Update Forms questions will ask for the permissions shown below. Learn more
Dynamic Fields - Update Forms questions will need access to your Google account
This will allow Dynamic Fields - Update Forms questions to :
See, edit, create, and delete only the specific Google Drive files you use with this app
View and manage forms that this application has been installed in
See, edit, create, and delete all your Google Sheets spreadsheets
See and download any calendar you can access using your Google Calendar
See and download your contacts
View groups on your domain
View organization units on your domain
See info about users on your domain
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
Send email as you
View and manage your Google Groups
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Mohammad Abubaqar
June 22, 2023
The add-on reduces the amount of time spent manually updating form questions! You're doing an excellent job.
Is this review helpful?
Profile Picture
Shormila Ahmed
July 6, 2023
It's simple to import variables from Google apps like sheets or contacts into Google forms. Make my task more easy
Is this review helpful?
Profile Picture
Knowledge Pack
June 29, 2023
You can update your form on a regular basis using the plus version's cron job. Very useful and makes the process much more convenient
Is this review helpful?
Profile Picture
Harunur Rashid
May 18, 2023
The business feature is used to retrieve data from a web service. It works perfectly. Time saving.
Is this review helpful?
Profile Picture
R C. K
May 25, 2023
The form is simple to set up and has a plethora of customization possibilities (data sources). Very beneficial
Is this review helpful?
Profile Picture
ridwan adejumo
June 8, 2023
The team support are amazing. Thank you for the great work
Is this review helpful?
Profile Picture
Duc Nguyen
February 13, 2023
Please help, how to uninstall it? hidden uninstall button
Is this review helpful?
Profile Picture
Dave Humbarger
September 24, 2022
The name is misleading. It's only dynamic if you pay. I understand the need for compensation, but don't call the add-on "Dynamic " if it isn't dynamic across all versions, paid and free. When changes are made to the mapped array in Google Sheets, the mapping needs to be manually updated, negating the whole reason I got the add-on. Still more convenient than updating the form manually each time there's a change, but a bit let down.
Is this review helpful?
Profile Picture
Giulio Di Filippo
June 6, 2021
Why can't I choose a column in "Create mapping" ?? I see in the dropdown menu only: - Choose entry - Invalid header in column: 1 Why can't I select the first column?? I configurated the other references correctly.
Is this review helpful?
Profile Picture
David Knapp
December 21, 2021
Very well documented, but the free version is crippled by a limit of one update per form per day — I guess you could say that's dynamic, but not *very* dynamic.
Is this review helpful?
1-10 of 58
Clear search
Close search
Google apps
Main menu