# Automatic Calculation

**URL:** https://community.glideapps.com/t/automatic-calculation/73687
**Category:** Ask for Help
**Created:** [May 27, 2024, 1:46pm UTC](https://community.glideapps.com/t/automatic-calculation/73687 "2024-05-27T13:46:22Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [May 27, 2024, 2:54pm UTC](https://community.glideapps.com/t/automatic-calculation/73687/2 "2024-05-27T14:54:11Z")

</div>

> [@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?](https://community.glideapps.com/t/how-do-i-create-a-custom-form/25014):
>
> 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](https://docs.glideapps.com/all/reference/data-editor/user-specific-columns) and [Relations](https://docs.glideapps.com/all/reference/data-editor/computed-columns/relation-column) 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.

---

_[View the full topic](https://community.glideapps.com/t/automatic-calculation/73687)._