Formula for opening and closing values

Topic Labels: Formulas
746 3
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi There.

I have a table for capturing fuel fill ups. In one column we have the opening ODO balance, the other is closing ODO balance.

Closing Balance is what will be inputted by the user, the opening balance should automatically then become the same value as the closing balance.

Perhaps this image might be a bit more clear of what i want to achieve.


Apologies if the explanation is not clear

3 Replies 3
7 - App Architect
7 - App Architect

Hi @Kendall_Rousseau,

Formulas may not be sufficient for you as they work only for one record at a time and it looks like you are trying to copy the value into a new record. Is that correct? If that is correct then an automation might be a better fit here.


Hi Raminder

That is correct. Any idea how i would go about doing this with an automation?

Something like this could work:


I have not done a whole lot of testing with this, so test on your tables before you put it to production use.