Formula for opening and closing values

[Kendall_Roussea]

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

[Raminder_Singh]

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.

Regards,
Raminder

[Kendall_Roussea]

Hi Raminder

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

[Raminder_Singh]

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.