Multi-Form CRUD Web App – Google Sheets Apps Script

B10 is the original of this series: several independent CRUD screens living in one spreadsheet, chosen from two dropdowns. Pick a form, pick its database, and you are working on that pair. Create another pair by adding two more tabs.

Naming decides everything

A tab whose name begins with Form appears in the Form dropdown. A tab whose name begins with Database appears in the Database dropdown. Anything after the keyword is yours. That single rule is the whole configuration — no registry to maintain and no code to edit when a new screen is needed.

Adding a field takes two edits, not one

Worth knowing before you start, because the walkthrough runs into it deliberately. Adding a row to the Form sheet puts the field on the add-record form straight away, but the field will not appear in the table or save until you also add the matching column header to the Database sheet. Both halves, every time.

The form and its database must match

The other gotcha demonstrated on camera: if Database 2 is selected but Form 1 is still chosen, editing a record will not work properly. The pair has to correspond. Once Form 2 and Database 2 are both selected, the record opens with all its fields.

Day-to-day use

Add a record through the generated form, edit one through a popup that loads its values, or find one by searching its ID. Everything writes to the sheet in real time, so the spreadsheet and the app never show different things.

Which one in this series to buy

This one keeps everything in a single spreadsheet. The next file adds support for several separate spreadsheets, and the one after that adds automatic per-column filters on top.