Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Add info from linked table to automated e-mail

Solved
Jump to Solution
219 0
cancel
Showing results for 
Search instead for 
Did you mean: 
devosk_1980
4 - Data Explorer
4 - Data Explorer

Hi all,

I am trying to add info from a linked table (one to many relation) in the body of an e-mail in an automated action.

This is my setup:

TableA with Fields Name, Age, Status, Email, ...
TableB is a collection of dates on which the person in TableA is expected. Fields: Name (from Table A), date, type of meeting)

One record in tableA can have multiple lines in TableB.

Now I want to be able to send an automated mail that contains the info from TableB (date and linked type of meeting).

Is this somehow possible? If yes, can someone please help me how to solve this?

Thanks in advance.

Kind regards,
Kenneth De Vos

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

Yeap, use a "Find record" action to find all the records in Table B that are linked to the record in Table A, then insert them as a table into your email

Here's Airtable's guide! https://support.airtable.com/docs/how-to-create-email-digests-with-automations

See Solution in Thread

1 Reply 1
TheTimeSavingCo
18 - Pluto
18 - Pluto

Yeap, use a "Find record" action to find all the records in Table B that are linked to the record in Table A, then insert them as a table into your email

Here's Airtable's guide! https://support.airtable.com/docs/how-to-create-email-digests-with-automations