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 |