Use the line items created by a regex formatter with Airtable's find or create record

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?

Page 1 / 1

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.

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded