I built a Google Form that connects to a spreadsheet but I’m only seeing a submit button. I need to add more functionality to make it work like a proper data management system.
Right now users can only submit new entries, but I want them to be able to:
View existing records from the spreadsheet
Edit entries they already submitted
Delete records when needed
Is there a way to display the spreadsheet data directly on the form page? I’m looking for suggestions on how to create these additional buttons and connect them to the Google Sheets data. Maybe through Google Apps Script or some other method?
Any help would be great since I’m stuck with just the basic submit functionality.
Try Google AppSheet - it connects directly to Google Sheets and does exactly what you need without coding. I set this up for a client last year and it worked great. AppSheet automatically builds a mobile-friendly interface from your existing spreadsheet. Users can view, edit, and delete records with proper login authentication. Setup’s easy - just connect your Google Sheet and AppSheet creates the app automatically. Users only see their own records based on email, so they can’t mess with other people’s data. Changes sync instantly with your spreadsheet, keeping everything intact. It’s free for basic use and way faster than building from scratch with Apps Script.
totally get it, setting up a web app can be a hassle. if you want something simpler, you might wanna check out airtable or notion as they have those features ready to go. saves a lot of time and headaches, trust me!
Google Forms isn’t designed for editing entries directly; it primarily collects data. To achieve the functionality you want, consider developing a custom web application using Google Apps Script. I’ve created a similar project before using the HTML Service available in Apps Script. Essentially, you’ll want to start a new script project where you can build a user interface with HTML, CSS, and JavaScript. Use server-side functions to interact with your spreadsheet. Implement the doGet() function to serve your web app and define different functions for viewing, editing, and deleting records. Also, to ensure data privacy, consider implementing an authentication mechanism to allow users to edit only their submissions.