My WordPress blog will migrate

Please see my new post on Medium: https://max-makhrov.medium.com/augh-again-service-using-too-much-computer-time-for-one-day-136d2779092b I will stop my WordPress blog for now because of ads it shows to users. I've decided to slowly migrate to Medium. There's so much I can share, but WP blog is on pause now. Thank you for reading!

Use Google Form as custom HTML-interface for Sheets

The code is here: https://github.com/Max-Makhrov/google-form-to-sheet.gs You can repeat my steps and embed Google Form to the sheet: Installation: Create a new Google Sheet, like mineCreate a new Google Form within the SheetCreate a new script projectCreate 2 files: code.gs and form.html and copy the code from this repo.Edit first lines of the code: enter your form id and your … Continue reading Use Google Form as custom HTML-interface for Sheets

Beginner: query formula for Bar Chart in Google Sheets

😇 Here's the old tick I wanted to share. Copy Sample File! You could create any Chart with a single QUERY formula or combination of QUERY+FILTER+SORT+UNIQUE Here's the chart: The formula is: =QUERY({A:C},"select Col1, sum(Col3) where Col2 <> '' group by Col1 pivot Col2" {} — used to convert the range into the array. Now … Continue reading Beginner: query formula for Bar Chart in Google Sheets

Family Expenses App. Glideapps + Google Script. Part 2 of 2

This is the sequel, the original post is here:  Family Expenses App. Glideapps + Google Script. Part 1 of 2. Modify Finanso. Modification points are: Create your own user tabs (or one tab if you're single) Modify categories for your expenses. Lets' shortly recall the scheme: GlideApps Google-Apps-Script _______________^_______________ _________^_________ | | | | 📱Finanso … Continue reading Family Expenses App. Glideapps + Google Script. Part 2 of 2

Family Expenses App. Glideapps + Google Script. Part 1 of 2

👋 Greetings! I'm glad to share the app for family finances. Meet Finanso! Our family is happy using Finanso for 3 months so far. Finanso is powered by Glideapps. Glideapps = App+Sheets Glideapps ensures the data is synchronized between spreadsheets and the App. When I enter the data to my phone, I see it in … Continue reading Family Expenses App. Glideapps + Google Script. Part 1 of 2