Notification on newly created item based on the recipient being in a FVA
I need to send a notification when an item is created against a specific project. the recipient of the email should be the Project Manager of that project and I am using a FVA field to copy the project manager into the newly created item.
I then created a trigger to fire on newly created items and added the advancedemail.js assigning the FVA field to the recipient.
I have tried both a Pre and Post trigger but what seems to happen is the FVA field is not populated until after the trigger has fired therefore sending no email.
Surely the Post event trigger should send the email to the user in the FVA field as suggested.
What am I doing wrong or does anyone have an alternative.

