[image] Noob here asking for help :slight_smile: When a new person is hired, the company HR team fills these forms that then go to a google sheet. In the sheet there are certain columns that use formulas, but when the form from glide is sent, and the row is filled, the formulas don’t work. Exam…

[image] Massimo_Ridella: is there a way to have the glide form calculate the values based on user input? For calculations while you’re in a form we often turn to using custom forms. Basically a bunch of user specific columns on a one row table and a button to submit them. [image…

[image] litter_in_bin_sign Trash your Excel Formulas Community Resources wave Hey Gliders! By request, I created a video that explains how to replace 14 commonly used Google Sheet/Excel Formulas using Glide computed columns and other native Glide functionality.…

Hey everyone, thank you for your help! I wanted to let you guys know that a way to solve the problem was simply to add a macro on the google sheet to perform the calculations! I did it via Apps Script

Which is totally the wrong way to do it. But hey, if it works for you that’s great :+1:

It works fine for my case, out of curiosità why would it be wrong?

When you introduce a Google sheet there is a long delay to sync… sometimes up to 5 min. Doing the calculations in Glide is near instant and less complicated to set up than app script. Maybe the script is working now but as your app gets larger scripts can be hard to maintain. If you show us some …

Automatic Calculation

Ask for Help

ThinhDinh May 28, 2024, 12:26am 3

Topic		Replies	Views
Google Sheet Entries keep going to bottom of sheet in my glide app Report a Bug	10	741	October 16, 2022
User input into Google Sheets? Ask for Help	5	513	February 6, 2023
Add spreadsheet computed column Ask for Help	4	641	July 23, 2022
Data entry using basic table layout Feature Requests	7	935	February 9, 2021
Sum formula Ask for Help	9	1950	July 8, 2020

Automatic Calculation

Related topics