Creating Interations From Multiple Arrays

[Soracle_Media]

Hello,

I have an Airtable table that is sending through a selection of data to my scenario. That data has a few arrays in it. However only 2 are what I am interested in at this moment. Sizes and Colours. I want to be able to create bundles that have this output effectively Black / S, Black / M etc depending on whatever colours and sizes are in the array so all colours are created with all the sizes.

Can anyone please assist in how I do this?

Thanks.

[dilipborad]

Hello,
Use filterByFormula API Function with Airtable’s original functions.

Check some reference posts of articles about how to use filterByFormula.
Posts in Make Community:

AirTable module formula error

What are you trying to achieve? I have a webhook that receives an email address. I have two Airtable tables: Customers and Accounts. They have a one-to-one relationship and link fields have been setup correctly between the two. In Accounts, I have the following fields: Email (from Customers) - a lookup field Expiry - a date field storing dates in DD/MM/YYYY format Credits - a number field I’m trying to Search for a Record using an Airtable module in Make where the email equals the email con…

Airtable: Column ID & Search Formula

I am trying to automate the capture of my inventory in Airtable. I am using the Airtable Upsert module to either create a new record or update the existing. I am using my SKU as the identifier and its the primary field in my table. With Upsert I need to identify a Record ID or else it will create a new record. OK, search for the record in my table using the SKU to get the Record ID. I’ve encountered two things that I can find no explanation for in the Make.com documentation (which is something …

Other Posts:

Airtable Web API - Using filterByFormula or sort parameters

How to search for specific value through API filterByFormula?

Is there a way to use filterByFormula in Airtable to filter by a specific field value by date without it defaulting to the first entry in the table?

[Soracle_Media]

Hey,

Thanks for the response, however I am either misunderstanding your response or I wasn’t clear enough in my description. I need don’t just need to filter for what records they are, I need to output bundles (seemingly from an iterator at some point) so that can be mapped to another module. In this case Printify variants.

Thanks.

[dilipborad]

Ok @Soracle_Media,
Apologise for the misunderstanding.
If I understand properly the first part of filtering data is the correct part which is already done, Right?

Then after filtering, you need to use those results(bundles) in Iterator.
If this is right, use Array Aggregator between your Airtable and Iterator modules.

If this does not help, please come up with screenshots. That makes more sense to understand it properly.

[Soracle_Media]

In our usage, the retrieval from Airtable is the trigger when something changes in Airtable. This then must meet a filter condition to proceed. Then we use that information to download the relevant file from Dropbox. We then upload the image to Printify. Then we have the Iterator which retrieves the arrays from the first step. Does this make more sense?