Skip to main content

Looking to send an email to users with all records that match specific conditions once a month

  • December 26, 2023
  • 1 reply
  • 0 views

Forum|alt.badge.img+1

I've got a table that has a single select field. I'd like to parse all records in that status by airtable user, and send that user all records in 1 email once a month.

I've got this worked out kind of, but it emails each per matching record - I'd like to make it send 1 email and include all records. Screenshot is what I'm doing that emails each record to that airtable user.

 

 

1 reply

kuovonne
Forum|alt.badge.img+27
  • Brainy
  • 6002 replies
  • December 26, 2023

Are your users in a linked table? If not, can you change to a setup where with users are in a linked table?

With that two table setup …

Start with a find records action to find all the users. 

Then have a repeating action group. Within the repeating action group, do a second find records action that finds the records for the current user. Then have email action that sends the results of the find to the current user.


Reply