Hey! I have a scenario that looks through records in airtable and returns them. Around 400. Now I am testing it and things still go wrong sometimes. So my question, when I let it run and it goes through say 50 bundles correctly but stops, how can I (after fixing the error) continue with the 51th bundle and skip all those already done? Then another question, how can I END it at a predefined amount if bundles? Say I want to test it on 25 of the 400, how to make it automatically stop at 25? Thanks guys!
Hello!
Let me answer first your second question.
If your want to stop after some bundles to test, you can add a filter after your Airtable module. It has to be: « bundle order position » numeric operators:less than 25 (sorry not in front of computer so I can’t make any screenshots.
For your first question it’s a little more tricky because it will depend on what you can do with the data in Airtable.
The scenario will not remember where you were, so it will always make the same query and get 400 records.
So, you have to find a way to remember where you were.
Option 1: you update the airtble record every time it’s processed, setting a specific field. For example a Boolean « Done » that you set to true. Then in the first Airtable module, you filter in order to get the records where Done not equal to true.
Option 2: if the IDs of your records are increasing, you store in the Make data store the ID of the Airtable record that you just updated. If it fails, the Data Store will have the latest processed Airtable record. So you can add a Data Store search record at the beginning of your scenario and then, after the Airtable query module, add a filter to skip IDs that are lower than the ID you picked from the Data Store (but in that case you may have to add some more complex logic to test only 25 records)
I hope it helps you, let me know
Benjamin
1 Like
Hey Benjamin,
I see, that makes sense. It is hard indeed, cause the records are not sequention in numbers. The update on the airtable record could be interesting. I will definitely have a look, thanks a lot for the help, much appreciated!
1 Like
@Timo345 if you are completely stuck or need some help, let me know
Benjamin