Best answer

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

  • 19 September 2023
  • 6 replies

Userlevel 1

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:

0 Y123456789
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?


Best answer by Troy Tessalone 19 September 2023, 22:01

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

Userlevel 7
Badge +14

Hi @craibuc 

Good question.

Try using the Looping app to iterate thru each item:

Userlevel 1

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?

Userlevel 7
Badge +14


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

That’s because these are separate data points.


Userlevel 1

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

Userlevel 7
Badge +14


Try using this Zap action: Formatter > Text > Split




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





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

output = [{Set}];




Userlevel 1

That worked.  Thanks.