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.
- Google Groups and its members.
- Google Sheet contents and Calendar event information.
- 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:
Version/Features |
Free |
Plus |
Business |
Target group: |
Private |
Private, Freelancer |
Start-up, SMB, Enterprise |
Type of Google account |
Private |
Private/Google Workspace |
Google Workspace |
Number of users |
✓ 1 |
✓ 1 |
✓ Packages |
Number of update runs / month |
✓ 30 |
✓ unlimited |
✓ unlimited |
Number of updatable forms and questions |
✓ 3 / 3 |
✓ unlimited |
✓ unlimited |
Data sources* |
Free data sources: Contacts ✓ Sheets ✓ Groups ✓ |
Free-Version plus: Calendar ✓ Webservice ✓
|
Plus-Version plus: JDBC-Conncetion ✓ Workspace groups & orgunits ✓ |
Time based Job scheduler for regular updates of form fields |
– |
✓ |
✓ |
Connection to third party sytems |
– |
✓ |
✓ |
Google Workspace User attributes |
– |
– |
✓ |
Manual |
✓ |
✓ |
✓ |
License price** |
free |
50 € User/Year |
starting at 10 € User/Year |