Skip to content
Kuovonne's Guide to Airtable
  • Pages
    • Kuovonne's Guide to Airtable
      • Fields
        • Overview of fields types
          • Editable Field Types
          • Computed Field Types
          • Field Types by Formula Data Type
          • Field Types in Scripting
        • Specific field types
          • Formula fields
            • Demystifying Formulas (DareTable 2022)
          • Rollup fields
          • Select fields
          • Attachment fields
            • Uploading Attachments
            • Attachment Size
            • Attachment URLS
            • Thumbnails
        • Converting Field Types
        • Naming fields
        • Metadata fields
          • Simple Metadata Fields
          • Data Validation
          • Additional Dependencies
          • Original Record URL (Thumbprint) Field
          • Column Divider Fields
          • DareTable 2023 Presentation
        • Field dependencies
      • Formulas
        • Formula Field Reference
        • Writing Formulas
          • Using AI to Write Formulas
          • General tips for writing formulas
          • Testing for Blank Values
          • Drafting Formulas in Parts
          • Function versus Operator
          • Typing Special Characters
          • Commenting Formulas
          • Formulas to avoid
        • Formatting Formulas
          • Basic Rules
          • Nested IF formulas
          • SWITCH Formulas
          • Operators
        • Specific Formulas
          • Ranges of Numbers Values
          • Comma Separated List of Fields Values with Optional Fields
          • Earliest / latest date across columns
          • List Fields Values (one per line) with Optional Fields
          • Rounding a date to the half year
          • Url of Interface Page for a record
          • Removing varying items from a list
        • Data Type Conversion in Formulas
          • Text to Numbers
          • Numbers to Text
          • Data type conversions with Dates
        • Troubleshooting Formulas
          • Formulas that won't save
          • Hiding or showing #ERROR!
          • Troubleshooting date/time/duration formulas
          • Troubleshooting numeric formulas
          • Troubleshooting formulas with lookups
          • Troubleshooting text formulas
      • Automations
        • Triggering automations
          • Triggering automations for typed values
          • Triggering automations on existing records
        • Sending Emails
          • Ways to send emails
          • Using links in emails
          • Emailing Attachments
        • Accessing updated record values
        • Third party automations
        • Managing automation runs
      • Templates
        • Templates for record values
        • Templates using field values
      • Controlling Access
        • Sharing a base
        • Access control considerations
        • Techniques for limited access
          • Airtable interface
          • Share link access
          • Synced table
          • Prefilled forms + Automations
          • 3rd party portal
          • 3rd party webhook
        • Preventing base duplication
      • Specific Solutions
        • Most recent form submission for ermail
        • Email digest of a person’s records
        • Sum of Multiple Select choices
        • Link to multiple records based on select choices
        • Dropping Lowest Score (top 4 of 5)
        • Identify the position of a record in a linked record field (top 4 of 6)
        • Sequential Numbering of Records
        • Ending a list of rollup items with ", and"
        • Table ID in a formula
        • Latest/earliest date across several fields
        • Associating People with Records
        • First Tuesday of the Previous Month
      • Miscellaneous
        • Web API Calls for External Integrations
        • Getting paid to work with Airtable
        • Hiring a consultant
        • Airtable Communities
        • Making major changes to a base
      • Suggestion for this guide
Kuovonne's Guide to Airtable
/
/
Email digest of a person’s records
Share
Explore

Email digest of a person’s records

⁠
⁠
Tip Jar
⁠
Thank Kuovonne for creating this content!
⁠
⁠
⁠
⁠
⁠

Inspiration

In this
Airtable community post
⁠
, a user wants to run an automation that will email [Project Managers] a reminder to approve their [Invoices]. An invoice is approved by selecting a {PM Approved} checkbox.
Each project manager should get only one email listing all unapproved invoices (not one email per invoice).
Project managers should see only their own invoices, not anyone else’s.
Project managers without any unapproved invoices should not get an email at all.
⁠
image.png
⁠
⁠
In this example
Ardelle Guidi has one approved invoice and two unapproved. Ardelle should get one email listing the two unapproved invoices, omitting the approved one.
Garnet Guidi has two approved invoices and no unapproved invoices. Garnet should not get an email at all.
Mitsuko Romig has two unapproved invoices. Mitsuko should g

Setup the schema

In the [Project Managers] table, add a conditional count field {Num Unapproved Invoices} that counts all the linked {Invoices} where the {PM Approved} checkbox is not selected.
This field lets you send emails only to project managers that actually have unapproved invoices. No need to bug project managers that are already on top of their game!

Set up the automation

In the Automation, start with a Find records action that finds all the [Project Managers] based on the condition where the {Num Unapproved Invoices} field is greater than zero.
Have a repeating action group based on the results of the Find records action.
Inside the repeating group, have another Find records action. This second Find records action finds the unapproved invoices in the [Invoices] table based on two conditions:
The {PM Approved} checkbox is not selected, and
The {Project Manager} linked record field matches the current item value for the [Project Manager] in the list for the repeating group.
After the second Find records action, have a Send email action.
get the email from the current [Project Manager] in the repeating group
get the grid of unapproved invoices from the second Find records action.

⁠
image.png
⁠
⁠
Note: When setting the {Project Manager} in the conditions for the second Find records action, I use the is exactly condition with the Airtable record ID of the Current item from the list. This currently displays as an Invalid value, but it works correctly. I believe that the Invalid value display is a bug. If an [Invoice] can have more than one {Project Manager} you may need to use a “contains” condition.
⁠
image.png
⁠
⁠

Tips

If your [Project Managers] table has a User field for the project managers, you can get the email address from that User field.
Do you have an Interface where project managers can see and approve only their own invoices? If so, include a link to that interface right in the interface.
⁠
⁠
⁠
Thank Kuovonne for creating this content!
⁠
⁠
⁠
⁠
⁠
⁠
⁠
⁠
⁠
⁠
⁠
⁠
Want to print your doc?
This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (
CtrlP
) instead.