For the past few years an easy-to-use database interface for small businesses has been my primary idea of what I'd like to build if I founded a startup.
For the past few years an easy-to-use database interface for small businesses has been my primary idea of what I'd like to build if I founded a startup.
Google Sheets is laughably primitive when you try to use it as a multiuser database. It's impossible to validate input and preserve structure (giving a user edit permission, so they can insert new data, also allows them to remove cell validation and destroy the structure of the spreadsheet). Something as simple as copy-and-paste (Ctrl+C and Ctrl+V) will destroy all of your carefully placed conditional formatting and validation constraints. And sometimes a formula will just "break" for no reason at all, only to start working again a few days later...
I'm honestly surprised that this is what we consider to be the start of the art. Where's my easy-to-use cloud database?
DabbleDB was a good one for individual users, until Twitter bought it and shut it down. Google says grovesite.com is a competitor... and I also think Dabble's founders were debating rewriting it.
There's always the old FileMaker Pro, or databases of that age / time. (4D??)
you should definitely try to give it a go.