The Google Forms Dynamic Fields add-on from apps experts enables you to fill the values of selection fields with your data dynamically. Based on various data sources, such as Google Sheets, Google Calendar or from third-party systems via webservice, you can automatically insert and update the values e.g. of a drop-down menu in Google Forms without any manual efforts!
Update selection fields in Google Forms automatically
Within Google Forms Dynamic Fields Add-on you can create mappings between a Google Forms question and a data source. For example you can map the name of all members of a contact group or all values of a column in google sheets to a question of type checkbox or drop-down. When the update process is started, the add-on fetches the defined data and inserts the values to the mapped question. You can also activate a time based triggered job to update the mappings several times a day automatically. With Google Forms Dynamic Fields Add-on you can reduce the effort of maintaining contents twice and it’s possible to update you Google Forms contents automatically.
Google Forms Dynamic Fields Add-on connects to miscellaneous data sources in one Google Form. The Add-on supports the following data sources:
- Google Contacts wrapped by contact groups and google groups.
- Google Drive files of a defined folder, incl. sub-folders.
- Google Sheet contents, Calendar event information and Sites list content.
- Third party systems can be connected via Webservice and JDBC-Connection.
- Google Workspace orgunits and groups incl. user attributes.
Key features of Dynamic Fields Add-on:
- Update selection fields in Google Forms automatically.
- Support of drop-down, checkbox, multiple-choice and grid question types.
- Miscellaneous Google Apps like Calendar, Sheets and Groups can be used as data source.
- Data of third party systems can be connected via Webservice.
- Google Workspace customers can insert user attributes like cost center and department.
- The organizational structure of orgunits in Google Workspace can also be used.
- You can use the Add-on in unlimited Google Forms.
Product versions overview of Dynamic Fields Add-on:
Start-up, SMB, Enterprise
Type of Google account
Number of users
Number of update runs / month
Number of updatable questions
Free data sources:
G Suite groups ✓
& orgunits ✓
|Time based Job scheduler for regular updates of form fields|
|Connection to third party sytems|
|G Suite User attributes|
50 € User/Year
starting at 10 € User/Year