Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

I keep turning my Google Sheets into phone-friendly webapps

arstechnica.com

Post reply on HN
Print view View original

51–60 of 238 posts

Re: I keep turning my Google Sheets into phone-friendly webapps

#51

Post by bewal416 »

We built an entire app for our golf league- all using Glide and Google Sheets.

It was honestly a great experience- all the players had a great mobile experience with obvious forms and leaderboards, while the storage and compute was hidden inside the Google Sheet. The pricing was pretty reasonable- considering we could split the bill among us all, and we only needed it for about 4 months.

There’s still hope for good, quality SaaS! However, I hope Glide (or another) can figure out the pricing for the hobbyist tier.

Re: I keep turning my Google Sheets into phone-friendly webapps

#52

Post by sandspar »

dcreater wrote: post #13
FredPret wrote: post #2

I've recently been toying with the idea of turning my overly complicated weightlifting Excel into an overly complicated me-only webapp / testflight app. It can't be worse than Excel for iOS!

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.

Re: I keep turning my Google Sheets into phone-friendly webapps

#53

Post by hammock »

abound wrote: post #6
FredPret wrote: post #2

I've recently been toying with the idea of turning my overly complicated weightlifting Excel into an overly complicated me-only webapp / testflight app. It can't be worse than Excel for iOS!

Self-plug: I wrote a not-too-overly complicated app for tracking my strength training (a 5/3/1 derivative) https://github.com/bcspragu/stronk

Nice. If you havent seen it, I use 531 calculator religiously and it has a ton of programs on it, and very customizable https://blackironbeast.com/5/3/1/calculator?

Might inspire you as you continue to develop your app

Re: I keep turning my Google Sheets into phone-friendly webapps

#54

Post by ijidak »

I'm looking for a no code platform that I can use for my customers and charge a subscription for access.

Most of these no-code solutions target internal company Intranets.

But, I want to use them for apps I can sell to customers.

Does anyone have recommendations?

Re: I keep turning my Google Sheets into phone-friendly webapps

#55

Post by anyfactor »

zie wrote: post #50

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…

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 spreadsheet themselves and have the UI be accessible for their users.

Re: I keep turning my Google Sheets into phone-friendly webapps

#56

Post by [deleted] »

alostpuppy wrote: post #48
do_not_redeem wrote: post #44

Earlier quoted context omitted.

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.

What would you use this feature for?

[deleted]

Re: I keep turning my Google Sheets into phone-friendly webapps

#57

Post by worthless-trash »

zie wrote: post #50

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…

Thank you for discussing this openly, it can be a real bummer to write something, test it, have something work up to a point then fail due to situations outside your control.

You probably just saved me about 20 hours of coding.

Re: I keep turning my Google Sheets into phone-friendly webapps

#58

Post by neeleshs »

zie wrote: post #50

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…

I have had a similar experience with their API. Very verbose json structure, lack of stable row IDs, inconsistent data types. And being a spreadsheet, it also has to have styling/formatting details, complicating it even more.

Re: I keep turning my Google Sheets into phone-friendly webapps

#59

Post by worthless-trash »

abound wrote: post #6
FredPret wrote: post #2

I've recently been toying with the idea of turning my overly complicated weightlifting Excel into an overly complicated me-only webapp / testflight app. It can't be worse than Excel for iOS!

Self-plug: I wrote a not-too-overly complicated app for tracking my strength training (a 5/3/1 derivative) https://github.com/bcspragu/stronk

I use stronk (531 BBB) ! Its a damn small world!

I exported most of my data from "Strong" into Stronk, was easy. Thanks !

The interface showed lbs, but my values were all kg, still works.

Re: I keep turning my Google Sheets into phone-friendly webapps

#60

Post by fudged71 »

tmpz22 wrote: post #38
dcreater wrote: post #13

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’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 verrrry interested in your regex!! Can you share?

I’m interested in building a fitness ontology/terminology linked to a tokenizer and parser.

Post reply on HN