Skip to main content

I have a Zap with a new-email-message trigger.  Each email will have one or two IDs in the subject and a PDF attachment.  My goal is to create an airtable table record that contains the ID and the attachment.

I created a regex text formatter to split the subject into line items.  For example:

output
 1
   0 Y123456789
 2
   1 Z123456789

Next, I try to use these line items with Airtable’s “Find many records (with line item support)”.  I chose the desired field to search and output 0 and the search value.

Unfortunately, only one of the two records is actually created in Airtable.

What am I missing?

Hi @craibuc 

Good question.

Try using the Looping app to iterate thru each item: https://zapier.com/apps/looping/help

Here’s the results of the extract pattern, text formatter:

which is connected to the looping app:

 

Unfortunately, the loop only processes once, even when it’s published.

Am I mapping the values between the two steps correctly?

@craibuc 

Can you post screenshots with how your Formatter step is configured?

That’s because these are separate data points.

 

the regular expression matches IDs that start with Y or Z, with numerical endings.  In the example, two IDs are identified.

@craibuc

Try using this Zap action: Formatter > Text > Split

 

OR

 

Try using a JavaScript Code step instead of a Formatter step.

 

CONFIG

 

CODE

let Set = inputData.Set.split(" ~ ");

output = t{Set}];

 

OUTPUT

 

That worked.  Thanks.

Terms & Conditions