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.)
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!)