Help

Automate email digests with 3 new features ๐Ÿš€

cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Jason
Airtable Employee
Airtable Employee

2b862daedc04fd36ef132dac5f543f6c4c717332

Hey community!

Today we are officially launching several brand new automation features to help you build more robust workflows.

  • Automation trigger: at a scheduled time
  • Automation action: find records
  • Rendering records as a list

One of the best applications for these new features is making an email digest, where you can schedule a time to send a list of records that match the conditions you set. To see how all of these features come together to build an email digest, see this support article.

Below youโ€™ll find a shorter summary of each new feature.

At a scheduled time trigger

trigger_options

The โ€œAt a scheduled timeโ€ trigger allows you to trigger (or run) an automation at a pre-designated date and time. You can choose to run at regular intervals (in hours or minutes) or at set time on specific days of the week.

Find records action

action_options

This action will look for records matching conditions that you can specify within the action settings. If a record that matches the conditions is found, you can add a following action that uses the record data to perform some other action.

Render records as a list

render_list
This new feature lets you use the records found in the โ€œfind recordsโ€ trigger and render them as a list within an email. You can select which fields to include, and render them as a list of records in the email.

Share your feedback

Our developers would love to hear your feedback around this feature, so feel free to comment in this topic with any questions or ideas on how we can improve.

64 Comments
Jason
Airtable Employee
Airtable Employee

Hi @Mariusz_S,

Iโ€™ll check with our engineers about this and let you know when I learn more.

Sara_Ma
4 - Data Explorer
4 - Data Explorer

This is an amazing addition!

I have a question though, is there a way to add multiple grids and filter the content of the grids by one of the columns?

Jason
Airtable Employee
Airtable Employee

There is a way to do this! Start by adding a second โ€œFind recordsโ€ action to your automation flow. For each individual โ€œFind recordsโ€ action you can set different filter criteria (just like for a view) to only find records that match your filter conditions.

find_records

Then, you can insert records as a grid using each of these separately. Hereโ€™s how that might look when using the โ€œSend emailโ€ action. Notice that each HTML grid is using a different โ€œFind recordsโ€ action step from above.

separate_grids

Then, run a test to make sure the right records are being displayed. Hereโ€™s an example of two grids in a received email.

final_email

Hope that helps Sara!

Sara_Ma
4 - Data Explorer
4 - Data Explorer

That is perfect, thank you so much!

One follow up, is it possible to sort the grid by a specific column variable?

Jason
Airtable Employee
Airtable Employee

Youโ€™re welcome! Right now there isnโ€™t a way to set a custom sorting criteria, but that is something our team is considering for future enhancement.

Team_Upbuild
5 - Automation Enthusiast
5 - Automation Enthusiast

I agree it would be great to have a custom sorting feature for the grid. Also, is there a fix in the works for the number fields coming in without decimals? Thank you!

Jason
Airtable Employee
Airtable Employee

@Team_Upbuild There is a fix coming soon for number fields formatting properly with decimals

MattWeber
5 - Automation Enthusiast
5 - Automation Enthusiast

Can this be used to send specific digests to different people? I.e. the operation finds six pending items, but three for one person and three for another person. Can the digest send specific digests to each person for only their pending items?

Jason
Airtable Employee
Airtable Employee

It can be setup that way, but you would need to create a separate set of โ€œFind recordsโ€ and โ€œSend emailโ€ actions for each person. Thatโ€™d be easy to setup for a few people, but might become unmanageable for more than that.

Hereโ€™s an example of how the steps would be setup:

automation

Heracles
6 - Interface Innovator
6 - Interface Innovator

@Jason Thatโ€™s great improvements! Is it possible to sort the records somehow?
When choosing the Grid view it also becomes impossible to create a URL to the record directly, unless I am missing a workaround.

PS: I canโ€™t seem to find a way to edit the insert record module, I am assuming that is not available yet.