141–150 of 238 posts
Glide is cool ... I wish there were FOSS versions of Glide to spin up nice, neat and simple mobile apps. There are now quite a few reliable FOSS version of no-code tools (but the mobile space seems to be missing alternatives). Few nice no-code FOSS that I love using are listed at https://blog.n0c0de.com/articles/1635ef6f-f616-8023-b336-ff3...
Tried to use Glide a few years ago and couldn't understand why it is needed anyway in real life? It seems like toy for startup-guys, not for real MVP's or something valuable. I like Google Sheets and Google Docs but this app is so strange. Maybe it's ok for small "homemade" projects for neighbourhoods or local businesses like flower salon or fitness club. But why it is needed for these type of business if we have soc…
Is Glide better than AppSheets?
I wanted to use Google Sheets for an internal corporate app, but authentication/authorization is a pain, I got it to work but it would have probably been faster to just have some CRUD SQLITE somewhere.
See also: retool
In Glide, we avoid code and syntax as much as possible. Our table-driven programming model also creates a nice MVC-like separation of concerns where you don’t end up with your program chaotically interspersed with controls on a canvas, so your program is easier to manage as it scales (in exchange for being less direct to create).
https://restofworld.org/2024/elections-ai-tracker/
GS is not the best editorial interface but its not bad either, especially when it allows you to get things done quickly.
Likewise, this was another fun project (since retired) that sits on Google Sheets:
https://restofworld.org/stat-of-the-day/
We skip Google's API which I really dislike. The sheets are set to publish to the web and you can use that to pull down the data and parse it into JSON files.
It take less than a minute to set the basics up now.
Earlier quoted context omitted.
This is exactly what I've wanted to do for a long time. All the apps in the app store are money sucking or ad ridden and unnecessarily cluttered. I want a simple front end that lets me log lifts to a sheet/database
I use Google Forms to send data to a Google Sheet. You just put whatever lifts you have in the Form with spaces to add weights. I use this Google Form --> Google Sheets thing for a dozen different things.
Its been real easy to build small and large web apps for news organization on Google Sheets. Most recently we built an "AI Election Tracker" for 2024 elections across the globe https://restofworld.org/2024/elections-ai-tracker/ GS is not the best editorial interface but its not bad either, especially when it allows you to get things done quickly. Likewise, this was another fun project (since retired) that sits on Goo…
I've built quite a few dashboards while working on proof-of-concept feature/product engineering. Even though people often think I'm joking, almost always the backend database was a Google Sheet. Google Sheets has great API support, easy to write functionality, convenient read and file dumps, works well with Pandas/SQL, and has a universally appreciated UX. Data validation can be annoying if the "admin" directly enter…
Currently I manage my startup’s accounting in Google sheet, and your comment gave me an idea to enhance it with Google Forms!
I tried going all on on Google Sheets earlier this year. I used the Python API and like almost nothing worked consistently. I got 1 sheet to work well with like 1k rows and thought woohoo this is great! So I went all-in, put 25k rows in and Google pooped the bed. It gave errors all the time, rows and columns were funky. API issues galore. SQLite however handled 25k rows without any errors, always rock solid. I gave u…
There are extensions that let you query Excel worksheet files directly from SQLite (no importing, no transformation, just direct query). It's quite fun to do; you can use Excel (or Libre office, etc.) to maintain the spreadsheet, and build reports with SQLite.