I’m working on a little side project to test out an idea. It’s not for school or a job interview, just my own curiosity.
I’m trying to set up a basic database using Google Sheets. What I really want to do is make a simple interface where I can add new entries, change existing ones, and remove stuff from the spreadsheet.
Has anyone tried using Google Forms for something like this? Or is there another tool that might work better? I’m open to suggestions!
I know there are probably fancier ways to do this, but I’m hoping to keep it simple for now. Any tips or ideas would be super helpful. Thanks!
hey there! i’ve used appsheet for something similar. it’s pretty cool cuz you can make a mobile app that connects to your sheets. it’s got a drag-n-drop interface, so no coding needed. you can add, edit, delete entries easily. might be worth checkin out if you want something more user-friendly than raw sheets!
I’ve actually done something similar for a small volunteer organization I work with. Google Forms can work, but it has limitations, especially for editing or deleting entries.
Instead, I’d recommend looking into Google Apps Script. It’s a JavaScript-based platform that integrates seamlessly with Google Sheets. You can create custom menus and sidebars right within your spreadsheet, giving you that user-friendly interface you’re after.
With Apps Script, I built a simple form that appears in a sidebar. It lets us add new entries directly to the sheet, edit existing ones by selecting a row, and even delete entries with a confirmation prompt. It took some learning, but the basics aren’t too hard to grasp.
The best part is it’s all contained within the Google ecosystem, so there’s no need for external hosting or complex setups. Plus, it’s free to use. If you’re comfortable with a bit of coding, it’s definitely worth exploring for your project.
Google Forms is a decent starting point, but it might not give you the flexibility you’re after, especially for editing and deleting entries. Have you considered using Google Apps Script? It’s built into Google Sheets and lets you create custom interfaces right in your spreadsheet.
I’ve used Apps Script to build similar systems for small projects. It’s surprisingly powerful once you get the hang of it. You can create buttons, input fields, and even dropdown menus in a custom sidebar. This would let you add, edit, and delete entries with ease.
The learning curve isn’t too steep if you have some basic programming knowledge. There are plenty of tutorials and examples online to help you get started. Plus, it’s free and requires no additional setup beyond your Google account.
If you want to keep things simple but still have more control than Forms offers, Apps Script could be your sweet spot.