- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 02, 2025 02:52 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 02, 2025 07:07 PM
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'
And I've set it up for you here!
