Connect with us

Tech

I keep turning my Google Sheets into phone-friendly webapps, and I can’t stop

Published

on

I keep turning my Google Sheets into phone-friendly webapps, and I can’t stop

That’s about all I need from a “mix up your takeout and use the right apps” app, one made mostly for me, my spouse, and nearby friends and visitors. Pretty much anything you’d find useful while sitting down at a spreadsheet, you can also make useful through a little phone webapp.

Joyful overkill

I went a good deal further with my “DIYRoot” app. After using a couple meal delivery services, I sussed out the kinds of recipe formulas they were mixing up each week, plus the items or equivalents I had found at nearby stores. Knowing that I could figure out the basic cooking, I made an app that listed as many recipes as I could find, broke them into components, let me add them to an erasable menu plan and shopping list, and even had some pictures.



The best version of an entry has an image, ingredients, and recipe. There’s a button to add it to the menu and all the items to a list.

Credit:
Kevin Purdy

The best version of an entry has an image, ingredients, and recipe. There’s a button to add it to the menu and all the items to a list.


Credit:

Kevin Purdy

I didn’t quite master this app (the shopping list is plagued by blank items/rows), and it’s now technically an outdated “Classic” Glide app; maybe I’ll give it another shot. More successful is my most recent effort, “Pantry Items,” which is just a searchable list of spices and sauces, a note about how much I have left of each, and, through a webhook, add anything I see missing to a shopping list on Bring.

I can feel some people reading this article demanding that I just learn Swift or some mobile-friendly JavaScript package and make some real apps, but I steadfastly refuse. I enjoy the messy middle of programming, where I have just enough app, API, and logic knowledge to make something small for my friends and family that’s always accessible on this little computer I carry everywhere, but I have no ambitions to make it “real.” Anyone can add to it through the relatively simple spreadsheet. Heck, I’ll even take feature requests if I’m feeling gracious.

I use Glide, but you might have something else even simpler (and should recommend it as such in the comments). Just be warned that once you start thinking (or overthinking) along these lines, it can be hard to stop, even without the worldwide pandemic.

Continue Reading