Getting Started
Dynamic Form Choices runs your choice questions from a spreadsheet it creates for you. This guide takes you from install to your first connected question.
Install the Add-on
- Open the Dynamic Form Choices listing on the Google Workspace Marketplace (coming soon)
- Click Install and grant the requested permissions
- Open the Google Form you want to work on
The add-on asks for access to the form you use it on and to the files it creates. It never reads the rest of your Drive, and it never reads any spreadsheet other than the options sheet it makes for your form.
Connect Your First Question
- In your form, click the Add-ons (puzzle piece) icon → Dynamic Form Choices → Start
- Open the Questions tab. It lists every multiple choice, dropdown, and checkbox question on the form
- Click a question to open it, then press Connect question
That is the whole setup. On the first connect the add-on creates a spreadsheet in your Drive called - Dynamic Form Choices and gives the question a tab of its own, seeded with the options the question already has. Every question you connect after that gets another tab in the same sheet.
Your Three Columns
Each tab has a fixed layout, and each column has exactly one owner:
| Column | Owner | What it holds |
|---|---|---|
| A Options | you | One option per row. This is what the form will offer |
| B Capacity | you | Optional per-option limit for the option on the same row |
| C Taken | the add-on | How many people have picked that option so far |
The add-on never overwrites column A or column B. You never need to touch column C.
Leave the header row alone. Row 1 must keep reading Options, Capacity, Taken in English, in every language: the add-on uses Options in cell A1 to check that the tab is still intact.
Edit the Sheet, Not the Form
- Press Open {tab name} in the question, or use the cog's Open the options sheet, to jump straight to the tab
- Type or paste your options into column A
- Put a number in column B beside any option you want to cap. Leave the cell blank for unlimited
- The next sync writes column A into the form and fills column C with live counts
From here on, the sheet is the source of truth. If you edit the question's options in the form editor instead, the next sync overwrites them.
When It Syncs
Connected questions sync when you open the sidebar, once an hour, on every form submission, and whenever you press Sync all questions in the cog menu. Nothing needs to stay open.
Next: Connecting a Question for the details, or Features for the full overview.