
Founder of Rameez Scripts. I build these systems myself and help you set them up.
B13 takes the dynamic CRUD idea and adds the thing that makes it usable by more than one person: who you log in as decides what you can see. An admin opens the app and sees every record in the database. A user opens the same app and sees only the rows that belong to them. Same link, same screen, different data.
Each account carries a type — admin or user. The app reads it at login and filters the table accordingly, so the person who should only see their own work never sees anybody else's, and the person running things does not have to switch accounts to get the full picture. Changing somebody's access means changing one cell.
Both kinds of account can add, edit and delete. A user's additions are filed under their own name automatically, so their view stays theirs. Every change writes straight into the Google Sheet, which means the sheet and the app never drift apart while two people are working at once.
The add and edit form is not hand-written HTML. It is generated from the columns you keep in the database sheet, with a type set per field. The walkthrough demonstrates this by gutting the sample columns and rebuilding the whole thing as a school record — ID, student name, class, teacher name — purely by editing the sheet. Refresh, and the table and the form both match the new shape.
Copy the sheet, open Apps Script from Extensions — the code is already inside — and deploy as a web app. Authorise it once and the link is ready to hand out to admins and users alike.
| Version | v1.0 |
| Published | Aug 22, 2025 |
| Platform | Google Apps Script |
| Database | Google Sheets |
| Category | Login & Authentication, CRUD & Dashboards |
| Video | Watch walkthrough |
| License | Regular License |
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
What buyers and YouTube viewers say about this project.