Features

One Options Sheet per Form

The first time you connect a question, Dynamic Form Choices creates a single spreadsheet in your Drive named after your form, - Dynamic Form Choices. Every question you connect gets its own tab in that one file, so the whole form is administered from one place.

The sheet mirrors your connections: connect a question and its tab appears, disconnect it and the tab goes away. Disconnecting the last question leaves the spreadsheet in your Drive with (disconnected) added to its name.

Options in Column A

Column A is the question's option list, one option per row. Type them, paste them, or feed them with a formula. On the next sync the add-on writes them into the form.

Values are cleaned up on the way in:

• Leading and trailing whitespace is trimmed and blank rows are skipped
• Duplicates are removed, case-insensitively (Google Forms cannot offer "Red" and "red" as separate options)
• An "Other" option on the question is preserved
• Google Forms allows at most 500 options per question, so longer lists are cut to the first 500 unique values

Capacity in Column B

Column B caps the option sitting on the same row:

• Blank (or any non-number) means unlimited, so you only cap the rows you care about
• A number is that option's maximum number of sign-ups. Once it is reached, the option is removed from the form automatically
• 0 keeps the option closed. It is never offered, but its row stays in your sheet
• Raise the number and the option comes back on the next sync

Capacities are matched to options by row, not by name, so B5 caps whatever option sits in A5.

If every option on a question is full or closed, the question falls back to a single "No spots available" placeholder until something reopens.

Options are removed automatically when they fill up, usually within seconds of the response that fills them. Google runs form triggers on its own timer and does not guarantee an exact moment, so an occasional slower run is normal. This applies to every add-on working on a native Google Form. Inside that window two people can still take the same last spot.

Live Counts in Column C

Column C is the add-on's. After every submission it writes the current number of sign-ups for each option, row by row, so the sheet doubles as a live dashboard. There is nothing to configure and no formula to maintain.

Everything Syncs Itself

Connected questions sync:

• when you open the sidebar
• once an hour in the background, whether or not the form is open
• on every form submission
• whenever you press Sync all questions in the cog menu

Hourly is the fastest background schedule Google allows for forms add-ons. Press Sync all questions when you want an edit to land right away.

Per-File Access

The add-on works under Google's per-file Drive permission. It can see the options sheet it created for your form and nothing else, not your other spreadsheets and not the rest of your Drive. Classic Form Ranger style add-ons ask to read every spreadsheet you own; this one does not.

Options From Another Spreadsheet

If your list already lives somewhere else, leave it there and pull it into column A with =IMPORTRANGE(). The sync reads whatever the formula resolves to, so your form follows the source without the add-on ever getting access to it. See Advanced: Options From Another Spreadsheet.

Form-Level Limits Too

Dynamic Form Choices also carries Form Limiter's form-level controls on the Form tab: a total response limit, a scheduled open and close date, a custom closed message, email notifications (including an alert when a question fills up), and a QR code for sharing the form.

Safe Failure Behavior

A sync that cannot complete leaves the question exactly as it was and reports what happened in the sidebar. A broken formula, an emptied column, or a wrecked tab layout never results in a broken or empty question. See Keeping Choices in Sync for each case.