Dynamic Form Choices — populate Google Forms™ choices from a sheet, cap each one, and close the form when it is full.

📋 One options sheet per form
Connect a question and the add-on creates a single spreadsheet for your form, with one tab per connected question. You type the choices in column A, set a per-option limit in column B (Capacity), and watch sign-ups land in column C (Taken). That sheet is the whole dashboard — there is nothing else to learn.

📊 Or start from Google Sheets™
Already have the list in a spreadsheet? Open the add-on there, pick the form and the column that holds your options, and it adds a Capacity and a Taken column beside your data. That spreadsheet then drives the form, synced every hour and on demand.

🔄 Built from your sheet, rebuilt whenever you edit it
The sheet is the choice builder: edit it and the question follows. Sync runs on every submission, once an hour, whenever you open the sidebar, and on demand from the cog menu. Add a row, rename an entry, reorder the list — your multiple choice, checkbox and dropdown fields rebuild themselves.

🚦 Per-option capacity and quotas
Put a number in the Capacity column and that choice is removed automatically once it fills up. Leave the cell empty and it stays available. Ideal for time slots, workshop sessions, room bookings, class quotas and limited stock.

🔢 Response limit and scheduler
Set a maximum number of responses and the form closes on its own when the count is reached. The built-in scheduler takes open and close dates with timezone support, and the form closes on whichever comes first.

🔐 Access to one file, not your whole Drive
Started from a form, the add-on creates its own options sheet and opens nothing else. Started from a spreadsheet, it only touches the one you opened it in. Either way your options column belongs to you and is never overwritten — the add-on writes its own Taken column only.

📥 Already keep your list somewhere else?
Put =IMPORTRANGE() in column A and pull that roster straight in. Formula results are read as plain values, so a list you maintain elsewhere can keep driving the form.

📧 Email notifications and alerts
We notify you by email the moment your form closes or reopens, plus a 24-hour heads-up before a scheduled close.

📱 QR code generator and sharing
Generate a QR code, download it as a PNG, or share the form by WhatsApp, SMS, email, X, LinkedIn or Telegram.

⚡ Simple setup
Install once and it works across your forms. No coding, no script editor, no template to copy.

━━━━━━━━━━━━━━━━━━━━

🎯 How people use Dynamic Form Choices

📅 Time slots and appointments
List every slot in column A, put 1 in Capacity beside each one, and a slot disappears as it is taken. Respondents only ever pick from what is still free.

🎓 Course and workshop sign-ups
Give each session its own capacity. When a session fills, it drops off the list by itself, and column C shows exactly how full every other session is — the live picture you would otherwise rebuild by hand each term.

🏢 Rooms, equipment and stock
Keep the master list in the sheet where your team already works. Rename a room, retire a piece of equipment, add next term's inventory, and the form reflects it without anyone reopening the form editor.

🗳️ Assignments with a cap
Topics, shifts, presentation slots, potluck dishes — anything that can only be taken so many times. Set the cap once and the form holds it for you.

✅ Perfect for:
📅 Appointment and time-slot booking
🎓 Class and workshop registration
🏢 Room, desk and equipment reservations
🎟️ Events with limited places
📦 Order forms with limited stock
🗂️ Any form whose choices change week to week

🎁 Try Dynamic Form Choices free for 7 days. All features included.

- Works with all Google Forms™ (personal and Workspace)
- Start from Google Forms™ or from Google Sheets™
- Only the options sheet it creates, or the spreadsheet you open it from, is ever accessed — never the rest of your Drive
- Your lists, limits and responses never leave Google; Skyfield receives account details only, never your sheet or your form's content
- Each form keeps its own sheet and its own settings
- Mobile-friendly sidebar

Google Forms™ and Google Sheets™ are trademarks of Google LLC