I’m currently working on a setup where I need to reference data from the previous record in my Airtable base. Specifically, I want to pull data from fields in the previous entry to use in calculations for the current record.
Here’s what I’m trying to achieve:
I have a field called Current Tank Level in each record.
I want to automatically populate a field called Previous Tank Level in the current record with the value from Current Tank Level of the previous record.
I’ve tried setting up linked records and using rollup fields, but I'm facing challenges with automating the process to ensure the Previous Tank Level field always reflects the correct value from the previous record.
How am I able to grab the previous record entry "Tank Level value" and automatically add it to my "Previous Tank Level" record?