Formula for opening and closing values

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.

image

Apologies if the explanation is not clear

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

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.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.