Adding a value cumulatively to another field's value

[houwtama]

I want the value in one field to be added cumulatively to the value of another field, when a form is submitted.

[StephenChapman]

Hi @houwtama,
Not sure if this specifically solves your problem, but it could be tailored to suit.

In your table, add th following:

• An Existing value number field
• A Value to add number field
• A Total equation field with formula {Existing value} + {Value to add}
  
  

On your record edit form:

1. Add the read-only Total field, and the Value to add field
   
   
2. Add a record action to this same form that sets the Existing value field to the Total field value.
   
   

When the form is submitted, the Existing value will be updated, and the Total will reflect the new cumulative total.

[houwtama]

Many thanks Stephen!