Best answer

Line Aggregation/Group By in Formatter by Zapier?

Userlevel 1

I use the Find Record in AirTable (within a loop) to pull out all records that match a name .

This is the output (there are currently 2 records the matched the criteria)

I would like to convert the above to send all records in one email

So that on one line it goes

Company 1, Role 1, Shift Start 1, Shift End 1

Company 2, Role 2, Shift Start 2, Shift End 2

I have tried a combination of Formatter tools but cant seem to get it right, does anyone have any solutions?

I think i ultimately need a line aggregator with some concatenate function

icon

Best answer by Troy Tessalone 27 September 2022, 17:55

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

Userlevel 7

+14

Hi @sp2222

Good question.

Try this Zap action: Formatter > Utilities > Line Items to Text

Example

Userlevel 7

+12

Hi @sp2222!

Were you able to give Troy’s solution a go? If so did it work for you?

If you’re still having trouble, let us know and we’ll see if we can find another solution :)

Userlevel 1

thank you i ended up starting with the other dataset

Sign up