Notification Email to lookup value

[HughOD]

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

1. Is this the best / approved way of doing this?
2. How can I get this email to work?

Thank you for any help you can provide!

Edited May 14, 2020 by HughOD
Found original solution, but I have a follow-up question.

[HughOD]

On 5/14/2020 at 11:28 AM, HughOD said:

I've discovered the problem is that if the field is hidden (which I'm doing with a Rule), then it can't be read by the email notification page.

But, I've tried to hide the field with HTMLBlocks as suggest here (https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-hide-fields-in-datapages) with no success.  Does this method still work?

 

On 5/14/2020 at 11:28 AM, HughOD said:

 

 

[Vitalikssssss]

Hi @HughOD,

This method works only with Responsive option disabled.

If you would like to preserve responsive design of Datapages you may try using the following code in HTML blocks:

HTML block #1

</header><div style="display:none;"><header>

HTML block #2

</footer></div><footer>

Cheers,

vitalikssssss