Hey everyone! I’m working on a cool project and need some advice. I want to make a simple web app that’s like a mix between a spreadsheet and a database. I know some Python and JavaScript, but I’m not sure what’s the best way to go about this.
I’m looking for something that can do stuff like:
Moving rows and things around easily
Showing data in different ways (like cards or lists)
Attaching files and viewing them
Switching between row view and form view
Working together with others in real-time
Making pivot tables and reports
I’ve seen some widget companies selling parts of what I need, but I’m not sure if that’s the way to go. Should I buy these widgets? Are there free options out there? Or should I just try to build everything myself?
If anyone has made something similar before, I’d love to hear about your experience. Any tips or resources would be super helpful!
As someone who’s been in your shoes, I’d suggest taking a look at AppSheet. It’s a no-code platform that lets you create custom web and mobile apps using data from spreadsheets or databases. I’ve used it for similar projects, and it’s surprisingly powerful.
AppSheet handles most of the features you’re after - dynamic views, file attachments, and collaborative editing. The learning curve isn’t too steep, especially if you’re already comfortable with spreadsheets. You can start with Google Sheets as your data source and gradually move to a more robust database as your needs grow.
One caveat: while AppSheet is great for rapid prototyping and small to medium-scale apps, you might hit some limitations if your project grows significantly. But for getting something up and running quickly without heavy coding, it’s hard to beat. Plus, the community forums are quite helpful if you get stuck.
yo charlie, have u checked out airtable? it’s pretty dope for what ur lookin for. it’s like a spreadsheet on steroids with database vibes. does all that stuff u mentioned + more. free tier’s decent but paid gets u more goodies. might save u some coding headaches. good luck with ur project man!
For your web-based spreadsheet with database features, I’d recommend looking into Retool. It’s a powerful platform that allows you to build custom internal tools quickly. Retool offers a spreadsheet-like interface with database connectivity, real-time collaboration, and customizable views. You can leverage your existing Python and JavaScript knowledge to extend its functionality. While it has a learning curve, it’s more cost-effective than building from scratch and offers greater flexibility than pre-built solutions. They have a free tier for small teams, which could be suitable for your project’s initial stages. Consider exploring their documentation and tutorials to see if it aligns with your specific requirements.