Build a Dynamic CRUD Web App Dashboard: Admin & User Roles with Google Sheets & Apps Script | C46V3

Admin Features

#	Feature	Description
1.	✅ User Management	Create, update, and delete user accounts. Assign edit and delete permissions. Define roles (Admin/User) and read-only fields.
2.	✅ Global Data Access	View and manage all records in the data sheet (no row-level restrictions). Bypass ownership checks on records.
3.	✅ Sheet Configuration	Change the active Form Sheet and Data Sheet through an admin panel. Dynamically load form fields and data columns.
4.	✅ Permissions Control	Restrict or allow edit and delete actions for different user accounts. Set readOnlyFields to lock specific fields for non-admin users.
5.	✅ Full CRUD + Notification	Create, Read, Update, and Delete any record. Receive email notifications whenever a record is changed or deleted.
6.	✅ Charts & Reporting	Access and generate all chart types (Pie, Bar, Doughnut, Line). View data from all users for comprehensive reports.

User Features

#	Feature	Description
1.	✅ Secure Login	Sign in with username and password. Change own password via “Change Password” modal.
2.	✅ Personalized Data Access	View only their own records if Email is used in the form configuration (row-level security). Admin-imposed readOnlyFields remain locked from editing.
3.	✅ Conditional CRUD	Create or Update records if Edit Permission is set to “allow.” Delete records if Delete Permission is set to “allow.”
4.	✅ File Upload & Management	Upload single or multiple files with each record. Old files automatically trashed upon re-upload.
5.	✅ DataTable Features	Search, filter, paginate, and export data (CSV, Excel, PDF). Print entire data table if permitted.
6.	✅ Charts & Visualization	View charts (Pie, Bar, Doughnut, Line) for accessible data. Filter date-based or dropdown fields for deeper insights.
7.	✅ Responsive Interface	Mobile-friendly UI using Bootstrap. No complex setup—just log in and manage data.

These Admin and User capabilities work together to provide a fully dynamic CRUD application in Google Sheets, all powered by Google Apps Script—with row-level data visibility, file uploads, and automated email notifications.

Steps to Install!Here the Detailed Steps to Install the Google Web App to Your End

Step	Instructions
Step 1	Open the web app link provided.
Step 2	If you see a Google Sheet in view-only mode: Click on the File button in the top left corner. Select Make a copy from the dropdown menu.
Step 3	If you see a page with two options (Make a Copy and AppScript File): Click on the Make a Copy button.
Step 4	Follow the on-screen instructions to complete the setup.
Step 5	Click on the Extensions menu at the top of the Google Sheet.
Step 6	Select Apps Script from the dropdown menu.
Step 7	In the Apps Script editor, click on the Deploy button.
Step 8	Select New deployment from the dropdown menu.
Step 9	In the deployment configuration, click on Select type and choose Web app.
Step 10	Fill in the required fields and click on Deploy.
Step 11	Grant the necessary permissions when prompted.
Step 12	Once deployed, copy the web app URL provided.

Here a Detailed Video tutorials which Guides you to Install a Google Web App on Your End. If You want a Fully Customizded Projects for Your Business Please Contact us +923224083545

Watch This Video Setup for Setup a Web App

If You Want a Fully Customized Web App Contact us We Provide Custom Services