# Formula Calculation

**URL:** <https://forum.adalo.com/t/formula-calculation/16475>\
**Category:** Database\
**Created:** [August 26, 2021, 11:34am UTC](https://forum.adalo.com/t/formula-calculation/16475 "2021-08-26T11:34:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dominiconorton](https://avatars.discourse-cdn.com/v4/letter/d/8e7dd6/32.png) [@dominiconorton](https://forum.adalo.com/u/dominiconorton)\
**Post date:** [August 26, 2021, 11:34am UTC](https://forum.adalo.com/t/formula-calculation/16475/1 "2021-08-26T11:34:57Z")

</div>

Hello,

I have a database that is attempting to calculate RICE score.

I have a form and want to use the inputs to calculate the score which saves both inputs and results in the database.

I am unable to use the inputs to calculate a result and then push it to the database.

RICE score isn’t a visible field. I want this to be generated in the database automatically.

How would i resolve this?

 ![Screenshot 2021-08-26 at 12.30.38](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/9/97c19df2564e26eff0f1b6365df183f688b7bfa2.png)  
 ![Screenshot 2021-08-26 at 12.30.49](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/9/975d8f2ec97239c88d0f98edf301933e64be8485.jpeg)

Dominic

---

<div class="post-metadata">

**Author:** ![Victor](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/victor/32/2054_2.png) [@Victor](https://forum.adalo.com/u/Victor)\
**Post date:** [August 26, 2021, 11:49am UTC](https://forum.adalo.com/t/formula-calculation/16475/2 "2021-08-26T11:49:05Z")

</div>

Hi @dominiconorton,

Did you try to have a second action on the form? For instance, if you have a form which creates the record in Projects, you can add a 2nd action after Create: it will be Update New Project. And in this Update action you can set the value of the score using the formula.

Best regards, Victor.

---

<div class="post-metadata">

**Author:** ![dominiconorton](https://avatars.discourse-cdn.com/v4/letter/d/8e7dd6/32.png) [@dominiconorton](https://forum.adalo.com/u/dominiconorton)\
**Post date:** [August 26, 2021, 12:16pm UTC](https://forum.adalo.com/t/formula-calculation/16475/3 "2021-08-26T12:16:01Z")

</div>

Beautiful Victor, thank you!
