Hi @Edward_shamosh
Please use search module to find exiting record with required value.
eg:
out:
Include filter for exist and not exist.
If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel
2 Likes
thank you for your response.
I needed to search pocket not airtable, pocket is the source data I also need you to provide context for what is quarterly launch
so what happens if there are more than one record let’s say there’s five records? will this flow be able to update all five or create five new ones?
Hi @Edward_shamosh,
In your current settings, you have a limit on the search module of 10 items, but you don’t have a filter IN the search module to limit which items Airtable will output. Therefore the output only contains the (first) 10 items. If these are not the ones you get from Pocket, you will create a new item in Airtable.
You can solve this in 2 ways:
-
Set the limit to a high amount so the search module will check the complete base.
-
Define the search criteria in the “formula” field in the search module of Airtable (this would be my preference, and is also the suggestion of @Msquare_Automation). This filter ensures the module only outputs the records from Airtable that meet your filter criteria (i.e. your pocket item). Make sure to also set the limit in line with the amount of items you expect from Airtable.
Next you can use the filter to check if the search module has found a record in airtable. If no record exists, you create a new record. You can use the filter as suggested before, or use the following:
If records are found you continue on the second path. All records found will be updated. Filter:
Good luck.
2 Likes