Candidate follow-up emails and SMS — driven by the outcome in your table
Set the outcome in your table — the scenario sends the right email and SMS to the candidate, notifies the referrer and writes the send confirmations back.
Attended or not — the email is always the right one
The referrer learns the result automatically
Every send is marked in the table — no duplicates
The table drives the process, not the other way round