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

Join Sheets, Jobs

This article is an answer to the comment by Luis Paliotes: Hello I was wondering, If it’s possible to build a Google Script that performs the same action as the following query: =query({IMPORTRANGE("SpreadsheetKey1","SheetName!A2:M"); IMPORTRANGE("SpreadsheetKey2","SheetName!A2:M")}, "SELECT Col1,Col6,Col4,Col5,Col8 WHERE Col5='Not Treated'") The problem I’m facing is that I am using this Query to connect 16 different Spreadsheets, … Continue reading Join Sheets, Jobs

Manager, Accountant, and Google Sheets

The case. Manager and Accountant Here's the Manager: Photo by Daria Nepriakhina on Unsplash She uses the phone to share photos on Facebook edit her Google Sheet with a purchases report. Here's the Accountant: Photo by Crew on Unsplash He's chatting with his girlfriend editing the main purchases report in his Google Spreadsheet. The Manager and the Accountant use different Google Spreadsheet files. … Continue reading Manager, Accountant, and Google Sheets