2 ms·
Agree 100%. In the span of a decade or so, the goalposts for what a "small business app" have moved dramatically: multiuser by default, offline editing/sync,
by kiwidrew 12y ago
Agree 100%. In the span of a decade or so, the goalposts for what a "small business app" have moved dramatically: multiuser by default, offline editing/sync, usable on mobile devices, modern-looking UI/UX... but the Access-like tools never made the leap. They're still stuck in the ancient past, and effectively unusable now. Why hasn't anyone been able to build a modern equivalent to Access yet?
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?