Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Formula for opening and closing values

Topic Labels: Formulas
230 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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

3 Replies 3

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:

image
image

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