I'm totally new to Airtable automations, and these questions will probably show that.
I want to set up an automation where the trigger is "When a record is created" and the action is "Send an email." The To field will draw from a lookup field in the table that contains email addresses.
My first question is, if I create a record but don't enter an email address quite yet, will Airtable send an email when I go back and enter an email address later?
Also, if I set up this automation for a table that already contains records, will Airtable send emails for all existing records, or just ones I enter after turning the automation on?