Feb 23, 2021 01:29 AM
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
Feb 23, 2021 02:05 AM
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.
Feb 23, 2021 02:31 AM
That is correct. Any idea how i would go about doing this with an automation?
Feb 23, 2021 02:49 AM
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.