Best answer

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

  • 12 February 2021
  • 2 replies
  • 52 views

  • Anonymous
  • 0 replies

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?

icon

Best answer by Troy Tessalone 12 February 2021, 01:51

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.

2 replies

Userlevel 7
Badge +14

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 is exactly what I needed, thank you so much!