Multi-Spreadsheet CRUD App for Departments – Google Sheets

B11 takes the no-code CRUD idea and stretches it across more than one spreadsheet. One web app, a dropdown of spreadsheets, and inside each one a set of forms and record stores that you create by naming tabs — no code, no field lists to maintain, no second deployment when a new department needs its own screen.

Naming is the configuration

The rule is simple and it is the whole system. A tab whose name begins with Form becomes an input screen and shows up in the Form dropdown. A tab whose name begins with Database becomes the store behind it and shows up in the Database dropdown. Anything after the keyword is yours: Form HR Department and Database HR Department pair up and read properly on screen. A tab named anything else is invisible to the web app, which is how you keep working notes and lookup tables out of it.

Fields come from the sheet

The Form tab lists the fields and their types, so the input screen is generated from the sheet rather than written in HTML. Decide you need a phone number, add the row, set the type to number, refresh, and the field is on the form. Nobody touches the code to change a form again.

Many spreadsheets, one script

To connect another spreadsheet you copy its ID into a single line and give it a friendly label — Sheet 3, Admissions, whatever it should be called in the dropdown. The Apps Script code stays in one spreadsheet; the rest are pure data, which keeps upgrades to a single place.

Adding and editing

Add Record opens the generated form and writes the row into the matching Database tab. Edit pulls that row back into the form, and Submit rewrites it in place rather than appending a second copy. Deployment is covered in the walkthrough.