Automatic Calculation

[Massimo_Ridella]

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)

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?

[Eric_Penn]

@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.

How do I create a custom form?

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.

[ThinhDinh]

Trash your Excel Formulas

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. Formulas are timestamped in the description. For good measure, I also threw in how to use the Excel Formula plugin column Enjoy! [Glide: Replace 14 Excel Formulas with Glide Computed Columns]

[Massimo_Ridella]

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

[Darren_Murphy]

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

[Massimo_Ridella]

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

[Eric_Penn]

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.