I’m trying to make an automation that sends an email to alert people when a task is almost due. The people have been selected in the record using a User field called ‘Responsible Person’. I kind of assumed that AirTable would know the email address (when you select a user, the email address can be seen from below their name), so I used the Responsible Person field in my automation for the ‘To’ parameter. This doesn’t seem to work though. It’s just bringing through their name, not their email address.
Is there a way to extract their email address from their username. Either directly in the automation, or by adding another field?
With a User field, you can set up notifications for when people are added to the field. So I just want to do something similar, but triggered when the due date is near.
