FREE006 answers a question most small businesses pay someone to solve repeatedly: we need another form, and it needs one more field. Here, a form is a sheet. Pick it from the dropdown, press Fetch Data, and the form builds itself from that sheet's header row.
Decide you now need a CNIC, a phone number, a guardian's name. Type it as a column header, fetch the form again, and the field is there. Rename the header from Fee to Fee Year and the label changes with it. There is no HTML to edit, no developer to brief and no waiting β which is the entire reason the file exists.
Admission, fee, registration, results, product intake: each is its own sheet, and the dropdown switches between them. Submissions go into the sheet the form came from, and the form clears itself afterwards so the next entry starts clean. Adding a whole new form means creating the sheet and pasting its name into one line of the code β the only place you ever touch the script.
A new, empty sheet fetches nothing, because there are no headers to build from yet. Add your column headings and it appears. Worth knowing so an empty form does not look like a fault.
The deployed app embeds into any website, so the forms sit inside your own pages rather than as a separate link people have to be sent.
That one is a single rich form with field types, icons, validation rules and file uploads configured per field. This one is the opposite trade: simpler fields, but as many different forms as you like, all switchable from one dropdown.
| Version | v1.0 |
| Published | Aug 22, 2025 |
| Platform | Google Apps Script |
| Database | Google Sheets |
| Category | Forms & Data Entry |
| Tags | |
| Video | Watch walkthrough |
| License | Regular License |
Subscribe on YouTube, then verify with one click. No payment, no card. Google is used only to confirm your subscription.
What you get
Not subscribed yet? Subscribe to our channel
Extra modules, your branding, integrations or reports built on top of this file. You get a clear quote and timeline before any work starts, and support after delivery.
20–30% advance to start · Clear quote before work begins · Support after delivery
What we customize
Paid picks from the same category
Multi-Level Dependent Dropdown Form | Google Apps Script Tutorial | B22
51 views this month
Grocery Store POS System with Barcode Scanner | Google Sheet POS + Apps Script + AI
380 views this month
How to Build an App with Claude AI: Complete Church Management System in Google Sheets
187 views this month
What buyers and YouTube viewers say about this project.