Skip to main content
Best answer

Sorting Airtable records by one field, then adding to different digests?

  • February 11, 2021
  • 2 replies
  • 88 views

In my Airtable view, each record that enters is associated with a different employee. I would like to create a separate digest for each employee to receive that will only contain the records associated with them.

I know I could set up a view for each employee and a separate zap to generate a unique digest for each one, but I would like to consolidate so I only have one zap creating all the digests. Is this possible?

I don’t mind adding a step for each employee (the number of employees should always stay beneath five), but I don’t want to continue adding zaps as I’m on the starter plan and would like to stay under the zap limit.

Right now for three employees, I’m using four zaps: three to generate the three digests, and then one to actually email it. I have three other digest-types that I’d like to create, however, which quickly balloons to adding 12 more zaps.

Filter only cuts out all employees but one, is there a parser or sorter that people use to accomplish this?

Best answer by Troy Tessalone

Hi @Alyssa Buchthal 

Try Paths: https://zapier.com/apps/paths/integrations

Or maybe a Formatter > Utilities > Lookup Table: https://zapier.com/help/doc/how-use-formatter-functions#using-the-lookup-table

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

2 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34052 replies
  • Answer
  • February 12, 2021

Hi @Alyssa Buchthal 

Try Paths: https://zapier.com/apps/paths/integrations

Or maybe a Formatter > Utilities > Lookup Table: https://zapier.com/help/doc/how-use-formatter-functions#using-the-lookup-table


  • 0 replies
  • February 16, 2021

This is exactly what I needed, thank you so much!