Noob here asking for help
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.
Example:
entry salary (input)
tax based on contract (formula calculated cloumn)
Is there a way to have the columns formula work with glide forms?
If not, 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.
I’m just dropping this here so I have something to refer people to when they ask.
This is a simple concept app (copyable), that demonstrates the following techniques:
Building custom forms for adding and editing list items (as an alternative to the native forms provided by Glide)
Preventing duplicate new entries using User Specific Columns and Relations
Enforcing mandatory input items
The use of visibility conditions and user specific booleans to control user flow
There is nothing particular…
Massimo_Ridella:
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.
I’d recommend getting rid of the spreadsheet formulas. You might be able to replace it with a math column in glide or simply with the custom form.
1 Like
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
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 screenshots of what you’re currently doing we could suggest an alternative fully built on Glide.
2 Likes