Build a Complete Dynamic Admin & User CRUD Web App with Google Apps Script | C46V2

The second release of the dynamic CRUD app, and the one that gives the owner a way in. Version one assigned every user a single form and a single database; this version adds an admin who can reach all of them.

The admin view

Sign in as admin and two dropdowns appear: every form sheet in the spreadsheet, and every data sheet. Pick a pair, press Load, and that application opens — its fields, its table, its filters. Form sheets are identified by the word form in the sheet name, so anything else is offered as a database. For someone running six small applications out of one spreadsheet, that is the difference between six deployments and one.

Users stay where they were

A normal user still gets exactly the form and database their login row names, with no dropdowns and nothing else visible. Their edit and delete rights are still set individually, and the app tells them which they hold rather than leaving a button to fail.

Everything that made version one work

Fields are still rows in a form sheet — id, label, input type, required, filterable — covering text, number, date, dropdown and file, with dropdown values on the field's own row. Marking a field filterable still produces a dropdown filter or a start and end date filter with a clear button. Adding a field is still a row and a refresh, never a code change.

New for users

Members change their own password from inside the app, and a new application is created by duplicating a form sheet rather than building one from scratch.