Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Tracking Weekly Changes

173 1
cancel
Showing results for 
Search instead for 
Did you mean: 
workingStiff
4 - Data Explorer
4 - Data Explorer

My company exports a .csv file every week containing the current inventory of the same objects.  Each object has a count that may change week over week.  We copy this .csv into an airtable weekly.  I would like to capture the old counts from the prior week so that I can track the differences week over week.  How can I set up a scheduler to move the values from the "This Week's Apples" field to "Last Week's Apples" field automatically?

1 Reply 1

Try setting up an automation that'll run a day before you do the imports, and give it a 'Find Record' action to grab all the records you have now.  In the screenshot below I did it with 'Where name is not empty', but you could do this with any condition that makes sense for your business or with a view instead

Then, use a repeating group on that list and for each of the found records paste 'This Week's Apples' value into 'Last Week's Apples'

Screenshot 2025-02-03 at 11.04.15 AM.png

And I've set it up for you here!