Automatic Calculation

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