# How can I make a calculated field on a form, which depends on the value of another field on the same form?

**URL:** <https://community.glideapps.com/t/how-can-i-make-a-calculated-field-on-a-form-which-depends-on-the-value-of-another-field-on-the-same-form/67455>\
**Category:** Ask for Help\
**Created:** [November 1, 2023, 10:28pm UTC](https://community.glideapps.com/t/how-can-i-make-a-calculated-field-on-a-form-which-depends-on-the-value-of-another-field-on-the-same-form/67455 "2023-11-01T22:28:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Inspector1\_ColmenasM](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/inspector1_colmenasm/32/64102_2.png) [@Inspector1\_ColmenasM](https://community.glideapps.com/u/Inspector1_ColmenasM)\
**Post date:** [November 1, 2023, 10:28pm UTC](https://community.glideapps.com/t/how-can-i-make-a-calculated-field-on-a-form-which-depends-on-the-value-of-another-field-on-the-same-form/67455/1 "2023-11-01T22:28:40Z")

</div>

Within a form, I ask the user how much of the product wants (red square). The next field (green square) must calculate the amount obtained from the value that user writes, multiplied by another value that I can obtain from the table or simply multiply it by a predefined value.

 ![duda 01](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/f/ff8965d4d8fe0c872f1ad34a2872a654bbbd39cc.jpeg)

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [November 1, 2023, 10:34pm UTC](https://community.glideapps.com/t/how-can-i-make-a-calculated-field-on-a-form-which-depends-on-the-value-of-another-field-on-the-same-form/67455/2 "2023-11-01T22:34:12Z")

</div>

You will need a custom form for that. The reason is, in a native form, the data you input in an entry field isn’t in the table until the users submits the form, it’s as if the data didn’t exist yet in your table, so you cannot work with it or run it through any computed columns.

Try custom forms:

> [@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 particula…