Jump to content
  • 0

Notification Email to lookup value




I'm hoping to send an email to a person selected in the form (by name).  


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.


  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 by HughOD
Found original solution, but I have a follow-up question.
Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0
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:



Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...