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
May 24, 2020 09:21 PM
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!
May 25, 2020 01:35 AM
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)
Hope this helps!
(If this has answered your question, please mark as the “solution” - if not, post again! Thanks!)