Field that tracks previous value of another Field

[AirTraveler]

I have two currency fields: Current Balance and Previous Balance. When Current Balance is updated, Previous Balance changes to reflect what Current Balance displayed previously.

Is there a formula that can address this? (Have done this many times in SalesForce but that has engendered a workflow rule which I’m not sure is available in Airtable.)

Thank you!

[JonathanBowen]

Hi @AirTraveler - there isn’t a built in way to do this in Airtable, i.e. take a snapshot of a field value and save it somewhere else. Some options though (ignoring the manual option of copy and paste)

• Write an Airtable script that copies the current value and writes it to the previous balance with a button click (you’ll still need to remember to run the script though)
• Automate on a periodic basis using Zapier
• Automate using a Google Script and the Airtable API

Hope this helps!

(If this has answered your question, please mark as the “solution” - if not, post again! Thanks!)