A problem with Airtable's Search record module - filtering based on array elements

Questions & Answers
1

Hi, I have the following scenario:

  • First, I create an array of Products using the Parse JSON module
  • Then, I iterate over the array
  • Finally, I want to filter Airtable’s results using the Search records module. For each iteration, I want to filter records to specific product name.

Unfortunately, the Airtable module filters the same product in each iteration, which means that I’m getting the same Bundle each time ‘x’ times.

Screenshots below. Please help!

image
image1920×827 180 KB

image
image1361×651 71 KB

2

Hi @Bartek_Jedrol

I noticed in the formula (Search) option, you’ve utilized an array element. Just be aware that this will consistently take the first element of the products array.

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel

2 Likes
3

Ok, got it, thanks for guiding me to a solution. I managed to fix the issue by providing the filter for the Iterator fields:

image
image1920×827 146 KB

1 Like
4

Hello @Bartek_Jedrol :wave:

Just wanted to pat you on the back for the great job you and @Msquare_Automation did while figuring out a solution to this problem.

Also thank you very much for coming back here with your final solution. We appreciate you keeping the community healthy and neat. :broom:

Keep up the great job!

1 Like