# Forms - automatic fields

**URL:** <https://forum.adalo.com/t/forms-automatic-fields/29951>\
**Category:** Get Help\
**Created:** [July 25, 2022, 11:29pm UTC](https://forum.adalo.com/t/forms-automatic-fields/29951 "2022-07-25T23:29:24Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![vague\_cribs0z](https://avatars.discourse-cdn.com/v4/letter/v/8c91f0/32.png) [@vague\_cribs0z](https://forum.adalo.com/u/vague_cribs0z)\
**Post date:** [July 25, 2022, 11:29pm UTC](https://forum.adalo.com/t/forms-automatic-fields/29951/1 "2022-07-25T23:29:24Z")

</div>

I am new to Adalo and I am looking at getting some user inputs via forms, and use the inputs to make some calculations that I can use later on. questions:

I want to use an input field in a formula under invisible fields. However the only options are sum, average, etc. Is there a way to get just the value they entered (not a sum, average, etc).

e.g want the user to enter the monthly rent and I want to calculate the yearly rent. However, the only options I see is to use the monthly rent (average, sum, max/min).

Cheers  
Alex

---

<div class="post-metadata">

**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\
**Post date:** [July 26, 2022, 4:07am UTC](https://forum.adalo.com/t/forms-automatic-fields/29951/2 "2022-07-26T04:07:01Z")

</div>

Hi Alex,

Welcome to the community 🥳

Yeah, that will not available in the automatically section because the create action is not before it!

What you can do is on the Submit button add a Update action and select that New Item ( collection name ) option ( a example :  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/b/5/b5723b5fcf1b070e3bdc1da1647be286e3936d4a.png))  
and do the calucution!

Or you can create a custom form with input components and a button!

Thank you

---

<div class="post-metadata">

**Author:** ![vague\_cribs0z](https://avatars.discourse-cdn.com/v4/letter/v/8c91f0/32.png) [@vague\_cribs0z](https://forum.adalo.com/u/vague_cribs0z)\
**Post date:** [July 26, 2022, 9:51am UTC](https://forum.adalo.com/t/forms-automatic-fields/29951/3 "2022-07-26T09:51:58Z")

</div>

Hi thanks for helping and I got most of the way there. Just one minor issue.

I am able to do the math I want, however, I am not able to update the database after a calculation.

Nn my case, I used the weekly rent that was an input in a form, I then multiplied that by 52 to get the yearly rent. The math and UI works. However, I am not able to update the database record with the yearly rent.

I am using a click action update, should there be a button to trigger this action? or am I missing something else?

 ![Screen Shot 2022-07-26 at 9.50.30 PM](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/7/a/7aeab81abb658f755452a21872d59cc977bf3487.jpeg)

Thanks  
Alex

---

<div class="post-metadata">

**Author:** ![Dilon](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/dilon/32/39815_2.png) [@Dilon](https://forum.adalo.com/u/Dilon)\
**Post date:** [July 26, 2022, 9:53am UTC](https://forum.adalo.com/t/forms-automatic-fields/29951/4 "2022-07-26T09:53:31Z")

</div>

You need to add this Update action on the form. If you add this on the text component you need to click on the text component to update the database!

---

<div class="post-metadata">

**Author:** ![vague\_cribs0z](https://avatars.discourse-cdn.com/v4/letter/v/8c91f0/32.png) [@vague\_cribs0z](https://forum.adalo.com/u/vague_cribs0z)\
**Post date:** [July 26, 2022, 9:57am UTC](https://forum.adalo.com/t/forms-automatic-fields/29951/5 "2022-07-26T09:57:30Z")

</div>

Thank you!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\
**Post date:** [August 5, 2022, 9:58am UTC](https://forum.adalo.com/t/forms-automatic-fields/29951/6 "2022-08-05T09:58:21Z")

</div>

Closed on August 5, 2022, 9:58am UTC

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.
