Formula Calculation

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?


Dominic

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.

Beautiful Victor, thank you!

1 Like