Automatic Calculation

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.

Example:
entry salary (input)
tax based on contract (formula calculated cloumn)

  1. Is there a way to have the columns formula work with glide forms?
  2. 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’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
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 :+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 screenshots of what you’re currently doing we could suggest an alternative fully built on Glide.

2 Likes