I have one table that has all my tasks. With a field called “Task Status”.
I have another table containing People With the fields of “First Name” and “Email”. Which is linked to My Task table, under the name field name of “Business Contact.”
I’m trying to create automation when I make a task status change in my table. Airtable automatically sends an email to only the person who is assigned to, under “Business Contact”.