Safe workflowtest first
Google Sheetssource list
Sessionslive rows
A, B, C options
Google Formspublic form
Capacityper option
full option message
1. Sync2. Limit3. Preview
FormRanger + FormGuard
Dynamic choices plus capacity limits.
Keep the option list in Google Sheets with FormRanger, then use FormGuard when each synced option also needs a seat count, quota, or full-message.
Recommended setup
Use Google Workspace add-ons for the boring operational layer, then test the live-facing form before sharing.
1
Sync the list from Sheets
Use FormRanger to update dropdown, checkbox, multiple-choice, or grid choices from a selected range.
2
Apply capacity rules
Use FormGuard for the options that need a quota, waitlist path, or closed message.
3
Test sync and limits together
Run one small copied-form test so the list update and quota behavior both work.
Related guides
Use these if the workflow changes from synced choices to real capacity control.
FAQ
Can FormRanger enforce capacity?
FormRanger is for syncing choices from Sheets. Capacity limits are a FormGuard-style workflow.
Can the sheet be the source of truth?
Yes. Keep labels and availability data in Sheets, then test the Form update before sharing.
Is this safe for inventory or payments?
For high-demand inventory, payments, or true reservations, keep a buffer or use a purpose-built booking system.