Overview
I'm hoping to send an email to a person selected in the form (by name).
Details
I have setup 2 tables (People & Form):
People table has: ID, Name, Email
Form table has many fields, plus PersonID.
The DataPage is a Submission form that has:
Dropdown that is a Lookup from Person:ID and the display field is Name. It stores the selected value in PersonID.
Virtual field that is Cascading Text Field that is from Person:ID and field value is Email (non-editable). I've hidden this field with a Section and rule (Value '1' is not blank).
I've setup the notification email like below. But, I never get the email.
If I hard code the To: to my email address, I do get the email.
QUESTION
Is this the best / approved way of doing this?
How can I get this email to work?
Thank you for any help you can provide!