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.
I keep turning my Google Sheets into phone-friendly webapps
101–110 of 238 posts
Re: I keep turning my Google Sheets into phone-friendly webapps
#102Earlier 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’ve been jotting them down in a standardized format in apple notes and using a regex to parse them into structured json for later analysis. For all the apps that are supposed to make this easier none of them do it right.
I'm doing something similar, incidentally in a wildly complicated google sheets + appscripts
lot in google keep and copy paste, then sheet does rest
https://imgur.com/a/xoHaxFY (3 images)
notation is ColB, it'll generate relevant metrics, running total for some metrics like sets / INOL
I also have onedit in sheet where if I put $$ anywhere it will calculate for the row
if I have:
++5,10 it will generate warmups 5 reps jumps at 10%, back to 50%
+++5,10 will do ramping warmups i.e. x5, x4, x3, x2, x1
whatever last onedit row will also split up Rep PRs at top
Most useful for me is auto cycle naming and visualization, i.e. the house keeping stuff that makes all the other apps finicky vs just logging on paper or note
#### date = program name
### macrocycle (i.e. month)
## mesocycle (i.e. week)
# microcycle (i.e. day)
so it will auto generate something like
#24/12/27
#24/12/27「188/58」「3/2/4/4」「2D AGO」 (0,4,4,3)
188th session / 58th session of this program (program 3, macro 3 / meso 4/ micro 4), done XYZ days ago. (0,4,4,3) is push, pull, legs, fatigue/recovery out of 5
Visualization shows on/off days so you can get good timeline sense
box border for mesocycles (week) with how many days at corner (useful for intuitive training)
bars are volume (500lb increments) for varios tags (i.e. bp for all bench press variations)
underline shows inol status for session (none, single under line, double underline, thick underline for >0.4, 1, 2, 2+
it'll highlight extra good or bad sessions i.e. (5,4,0,3) was a very good push day
Now mostly i goto gym, log in google keep:
#YY/MM/DD (performance) comments
ex1 (reps x sets) comments
ex2 (reps x sets) comments
ex3 (reps x sets) comments
Copy and paste into sheet when I feel like it and review metrics graph when needed
Re: I keep turning my Google Sheets into phone-friendly webapps
#103This is giving me flashbacks to the days when MS Access (and later on Visual Basic) ruled this segment of the market. It's interesting to think there's still a market for this type of small scale enthusiast application. One scenarios I've been thinking about recently is the death of the generic app. If LLMs end up being able to create software easily, why wouldn't we choose to have software that's totally aligned our…
[deleted]
Re: I keep turning my Google Sheets into phone-friendly webapps
#104I'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…
The article mentions appsheets, which I absolutely loved in my last role.
Brilliant for knocking up very simple internal tooling off the back of a Google Sheet. Most importantly, there was zero fucking around with IT on it, as it was already included in our workspace package.
Re: I keep turning my Google Sheets into phone-friendly webapps
#105During COVID, I built a quick no-code solution to help ‘all-inclusive resorts’ in Cancun and Punta Cana. It started with guests scanning a QR code, filling out a short form, and scheduling their Antigen/PCR tests. Over time, it evolved to help nurses manage operations, streamline test results, and send certificates via email. What began as a DIY project during lockdown scaled quickly to Mexico City, the Dominican Rep…
woah!
didn't even know you can embed videos on HN!
Re: I keep turning my Google Sheets into phone-friendly webapps
#106I use Notion databases for this. They're essentially spreadsheets with customizable table, list, kanban views, and each row gets its own wiki-style page in addition to the structured data. So it's nice for lists of books or movies or games, where you have some metadata but you also might want to take notes on it when you read/watch/play. It works pretty well for this purpose, but I also could probably make Obsidian o…
I badly, badly wish Obsidian had some kind of database/spreadsheet feature. I'm limping along with LibreOffice spreadsheets for privacy, but it's a pain having my notes in two different formats. And I miss grep.
Try SiYuan Note. It was posted here a couple of days ago.
Re: I keep turning my Google Sheets into phone-friendly webapps
#107Earlier quoted context omitted.
The projects I worked on always had a mechanism to dump data into a proper database. For example, I built a daily scraper to collect some of the inventory. I didn’t keep all the data in a single sheet. Instead, all the data was stored in a cloud-based managed SQLite or PostgreSQL database, or sometimes a local SQLite database. Only the day's data was stored in Google Sheets because the client wanted to see the spread…
It feels a little misleading to say you're using Google Sheets as the backend database, when you need an actual database in conjunction with it.
Extremely misleading, in this case Google Sheets it's working more like a frontend
Re: I keep turning my Google Sheets into phone-friendly webapps
#108Why lock down to a nocode tool instead of just hacking together a simple html5 page? Ai assistants have speed up the prototype workflow for doing less code/design.
An AI generated page will be full of security holes that a non programmer will be unable to assess.
I'm not normally a fan of nocode but dude, get real, the target user for this will have zero chance of understanding and maintaining the output if it's in code. Compared to pick your column and choose the type of widget you want it represented as. Below the tip of that iceberg there are also lots of non trivial features like search and sync.
Re: I keep turning my Google Sheets into phone-friendly webapps
#109Is that an ad? It definitely sounds like one.
Either that, or the author has a really odd fixation that warrants spending $69/month, just to share a list of nearby restaurants with his wife?
Re: I keep turning my Google Sheets into phone-friendly webapps
#110I'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…
Monzo (online bank in UK) let you see all your transactions in a Google sheet (with some caveats e.g. interest earned is skipped). I wanted to make a total wealth chart over all years. It's so damn complicated in Google sheets. In MS Excel I could simply make a pivot chart, apply any aggregation on days/weeks and be done with it. But with Sheets I had to make a new aggregate column, filter data in another new column,…
Google Sheets can do that - https://officewheel.com/group-dates-in-pivot-table-google-sh...