Jump to content
  • 0
HughOD

Notification Email to lookup value

Question

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.
      image.png.accaf1b25b35cccf3484c0637ccb3f16.png
    • 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 by HughOD
Found original solution, but I have a follow-up question.

Share this post


Link to post
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:

 

 

Share this post


Link to post
Share on other sites
  • 0

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
 

Share this post


Link to post
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.

Guest
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.

Loading...

×
×
  • Create New...