I have two tables that are linked to each other: Candidate Table and Position Table
Each candidate record has contact information (email) and is linked to a specific position record which also means that each position record may be linked to multiple candidate records. Each position record also has a status: Active, On Hold, Lost, etc.
I would like to be able to send automated emails to all candidates linked to a position that has changed its status from Active to On Hold to update them on what's going on. What would be the best way to go about this automation?