Is FormRanger a booking or inventory system?

No. FormRanger updates form choices from selected spreadsheet data. It does not reserve seats, process payments, or lock inventory.

FormRanger Support | dynamic Google Forms choices

Q: Can FormRanger create dependent dropdowns?

FormRanger is for owner-controlled refreshes from Sheets before respondents use the form. It does not filter one dropdown in real time while a respondent is filling out the form.

FormRanger support

Sync Google Forms choices from selected Google Sheets data without writing Apps Script. For the first run, prove one copied form before changing a live form. Contact support if Preflight, Update now, or the public preview does not match the selected sheet column.

Quick start

Setup in 3 steps

Open a copied Google Form and launch FormRanger.
Select the spreadsheet, sheet tab, and column to use as choices.
Run Preflight, click Update now, then preview the public form before sending it.

Useful guides

First-run test Permissions explained Dropdown guide Import choices from Sheets Fix choices not updating Dependent dropdown limits

Open the check that matches the failure

Start with the smallest failed step so the support note stays specific and useful.

Selected fileThe wrong spreadsheet opens or no source is available.

Sheet tab or columnThe expected tab, header, or Alpha/Beta values are missing.

Question mappingThe form question cannot be selected or was renamed.

Preflight warningPreflight reports an invalid or incomplete mapping.

Update or public previewUpdate now runs, but respondent-facing choices stay unchanged.

Do not launch until these pass

Preflight
It says the mapping is valid and shows the expected mapping count.

Update report
It says at least one question was updated. Skipped or error is not a successful run.

Public respondent preview
The public form shows the choices from the selected Sheets column.

Review timing
Only leave a Marketplace review after the setup succeeds in the public preview. The first-run checklist reveals that next step after all four checks and the preview confirmation pass.

Common questions

Which questions work?

Dropdown, multiple choice, checkbox, multiple-choice grid, and checkbox grid questions.

Why did update fail?

Usually the form question, sheet tab, or source column was renamed or removed.

Can it remove duplicates?

Yes. Use the remove-duplicates option before saving the mapping.

Can FormRanger create dependent dropdowns?

Use FormRanger for owner-controlled Sheets-to-Forms choice refresh before respondents use the form. It is not respondent-time filtering where one answer instantly changes the next dropdown.

Is it a booking or inventory system?

No. FormRanger updates choices from a selected spreadsheet source. It does not reserve seats, process payments, or lock inventory while respondents are submitting.