App Icon
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:September 14, 2022
Works with:
2,551,847
Overview
Create in Google Forms™ dynamic choice boxes. 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.
 - 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 into forms for auto prefilled question answers

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: 
http://apps-experts.de/google-apps-addons/google-forms-dynamic-fields/

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:
https://apps-experts.de/google-workspace-add-ons/overview-add-on-help-and-support/

Dynamic Fields is a popular Google Forms™ add-on available in the Google Workspace Marketplace™ 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
Developer
Trader status unspecified
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
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
A User of Dynamic Fields - Update Forms questions
May 23, 2018
When this add-on works it's incredibly useful. However I've spent an hour trying to get going with one project, and every time I hit "Next" from the First Steps page after trying to create a new mapping, nothing happens and the add-on simply doesn't work. I went to file a bug report - the link to report a problem takes me to a page of read-only documentation Google Doc.
Is this review helpful?
Yes
No
Profile Picture
A User of Dynamic Fields - Update Forms questions
January 23, 2019
Could do alot better. Addon works the same as the FormRanger addon except that it accepts more sources for importing and linking dynamic information. It's better in that it has ondemand updates (refreshes information in forms) but the limitation of only 3 requests makes the free version quite useless. FormRanger lets you setup a cron job to refresh the data every hour or on every user submission. Also I've seen users having issues where it is not working if they have multiple google accounts - the solution is opening an incognito window - seriously this is USER UNFRIENDLY! Many users will miss this part and move along (not before bagging your product). I'm sure many people have multiple Google accounts these days. You seriously need to fix this issue to be competitive with FormRanger addon otherwise I would recommend users to just download and install the latter.
Is this review helpful?
Yes
No
Profile Picture
A User of Dynamic Fields - Update Forms questions
January 7, 2017
Wow, I haven't tried all the options yet but I am amazed! This is what I need for a few of my forms. It would be great if you were able to create a new question where users could submit documents/photos through a Google Form. Keep up the good work!
Is this review helpful?
Yes
No
Profile Picture
A User of Dynamic Fields - Update Forms questions
April 25, 2018
Note if you purchase type in all lowercase. I love this Product!
Is this review helpful?
Yes
No
Profile Picture
A User of Dynamic Fields - Update Forms questions
October 2, 2017
Extremely useful and easy to set up! (One improvement might be to not have to reopen the ADD-ON for each step.- That is counter-intuitive)
Is this review helpful?
Yes
No
Profile Picture
A User of Dynamic Fields - Update Forms questions
January 27, 2017
I have a list with 447 options. It was a huge PITA adding or deleting options before. Dynamic fields now updates them in just a few seconds and I have no fear of typos anymore
Is this review helpful?
Yes
No
Profile Picture
A User of Dynamic Fields - Update Forms questions
May 16, 2019
It doesn't work! I stuck at First step messages, clicked "Next" and nothing happenped.
Is this review helpful?
Yes
No
Profile Picture
A User of Dynamic Fields - Update Forms questions
April 6, 2019
I test the free version - inputs from gsheet, it is a complete waste of time, as the link between gsheet and the form is passive. There where no effect to changes i mad in the gsheet inputs.
Is this review helpful?
Yes
No
Profile Picture
A User of Dynamic Fields - Update Forms questions
April 22, 2019
Doesn't work.
Is this review helpful?
Yes
No
Profile Picture
A User of Dynamic Fields - Update Forms questions
September 1, 2018
The create mapping dialog isn't showing up. If the developers can get that, which is the core functionality of this add-on, working again, I will consider changing my rating.
Is this review helpful?
Yes
No
1-10 of 52
Search
Clear search
Close search
Google apps
Main menu