Frequently Asked Questions

Which question types can I connect?

Multiple choice, dropdown, and checkbox questions, so anything in Google Forms with a list of options. Grid questions are not supported.

Where does the spreadsheet come from?

The add-on creates it. The first time you connect a question on a form, it makes a spreadsheet in your Drive called - Dynamic Form Choices and gives that question a tab. Every question you connect afterwards gets another tab in the same file. There is no file to pick.

Why doesn't Dynamic Form Choices ask for access to all my spreadsheets?

By design. It works under Google's per-file Drive permission and only touches the options sheet it created for your form. It cannot read your other spreadsheets, and it never tries to. Classic Form Ranger style add-ons ask for read access to every spreadsheet in your Drive; this one does not.

Can I point it at a spreadsheet I already have?

Not directly, and that is deliberate: pointing the add-on at your files would mean granting it access to them. Instead, leave your roster where it is and pull it into column A with =IMPORTRANGE(). The sync reads whatever the formula resolves to. See Advanced: Options From Another Spreadsheet.

What do the three columns do?

A Options is your option list, B Capacity is the optional per-option limit, and C Taken is the live sign-up count that the add-on writes. You own A and B; the add-on owns C and never overwrites the other two.

Can I translate the column headers?

No. Row 1 must keep reading Options, Capacity, and Taken in English in every language. The add-on checks cell A1 before it writes anything, and that check is what stops a shifted column from pushing capacity numbers into your form as options.

How fast do sheet edits show up in my form?

Straight away when you press Sync all questions, and automatically when you open the sidebar, once an hour, and on every form submission. Hourly is the fastest background schedule Google allows for forms add-ons.

Can options close automatically when they're full?

Yes. Put a number in column B beside an option and that is its maximum number of sign-ups. Options are removed from the form automatically once they fill up, and raising the number brings them back on the next sync. A 0 keeps an option closed without deleting its row.

How fast does a full option disappear?

Usually within seconds of the response that filled it. Google runs form triggers on its own timer and does not guarantee an exact moment, so an occasional slower run is normal. The timing is the same for every add-on working on a native Google Form, Choice Eliminator included. Inside that window two people can still take the same last spot. If you need instant, race-proof limits, that needs a hosted form rather than a native Google Form.

What happens if I empty the Options column?

Nothing destructive. A sync that finds no usable values leaves the question exactly as it is and shows an "empty column" notice in the sidebar. The same goes for a broken formula or a damaged tab layout: the question keeps the options it already has.

What happens if I delete a tab, or the whole sheet?

Deleting a question's tab disconnects that question on the next sync. Its full option list is restored, syncing and capacity stop, and the sidebar shows a notice with Connect question ready to start a fresh tab. Deleting or trashing the whole spreadsheet disconnects every question on the form. Recovery is Google's own: Drive trash keeps the file for 30 days, and Sheets version history holds the tab contents.

What happens when I disconnect a question?

Its tab is deleted from the options sheet, and the question gets its full option list back, including anything capacity had removed. Syncing and capacity limits stop. Disconnecting the last connected question keeps the options sheet in your Drive, with (disconnected) added to its name; the add-on stops tracking it, so the next connect starts a fresh sheet.

Do I need Choice Eliminator alongside Dynamic Form Choices?

No, per-option limits are built in. In fact do not run both on the same question: they would fight over the option list, with each sync re-adding options the other add-on removed.

Learn more about Choice Eliminator.

Is there a limit on the number of options?

Google Forms allows up to 500 options per question. Longer lists are cut to the first 500 unique values after cleanup (trimming, blank removal, de-duplication).

Does syncing affect responses I've already collected?

No. Existing responses keep whatever respondents submitted. Syncing only changes which options are offered from now on, exactly as editing the options by hand would.

Will my "Other" option survive syncing?

Yes. If the question has the built-in "Other" option enabled, syncing keeps it.

Does it work with shuffled options?

Yes. If a question has Google Forms' shuffle options setting turned on, syncing keeps that setting. Every respondent still sees the same live set of options, each in their own random order.

Does it do anything besides choice questions?

Yes. The Form tab carries Form Limiter's form-level controls: a total response limit, scheduled open and close dates, a custom closed message, email notifications, and a QR code for sharing the form.

Does everyone editing the form need the add-on?

Connections are set up by whoever connects the questions, and the hourly sync runs under that person's account. Co-editors see the synced options like any other question content.

What does Dynamic Form Choices cost?

Dynamic Form Choices offers a 7-day free trial with full access to all features. No credit card required. After the trial, a paid subscription is required to continue using the Add-on. View pricing.