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?
+31Try 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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.