A data-entry dashboard where the login actually means something. Users sign in, submit records through a form, and the View Data table shows them their own submissions and nobody else's β the username on each row is what decides it.
The form carries two linked pairs. Pick a job and only that job's requirements appear; pick a state and only its cities appear β Karnataka gives you Bangalore, and nothing irrelevant. Both sets of values live in a single Dropdown sheet, so extending the list is a matter of adding rows, not editing code. It is the pattern most people want the first time they build a form in Apps Script and the one that is fiddliest to get right.
Records can be edited in place and deleted with a confirmation, and the table updates as soon as the change is saved. Alongside the dropdowns, each entry captures name, education, salary and office timing.
A login holds for a day and then asks again, so a shared machine does not stay signed in indefinitely, and there is a logout button for when you want to end it sooner. Everything β logins, dropdown values and submitted records β sits in your own Google Sheet.
| Version | v1.0 |
| Published | Aug 22, 2025 |
| Platform | Google Apps Script |
| Database | Google Sheets |
| Category | Forms & Data Entry, CRUD & Dashboards |
| 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.
What We Customize
20-30% advance to start β’ Clear quote before work begins β’ Support included after delivery
Paid picks from the same category
How to Build Unlimited CRUD Forms with AI β PHP MySQL Admin Panel - PHP2
95 views this month
How to Create Multi-Step Form with Google Sheets & Apps Script 2026 | React Web App Tutorial | E26
54 views this month
CRUD Management Web App with Google Apps Script | CRUD, File Upload & Google Sheets | B43
48 views this month
What buyers and viewers say about How to Build a CRUD Dashboard with Dependent Dropdowns | Google Apps Script.