Jump to content
  • 0

Send notification email to address based on form data


fishsticks
 Share

Question

I'm using a DataPage as a survey. I would like to be able to modify the recipient of the notification email based on how the respondent fills out the survey. If the customer submits feedback on a specific department/location, I'd like the notification email to go to an email address associated with that location. For example, if the survey is for the office in Chicago, the email will go to chicago.office@fakeemail.com, rather than it going to a single catch-all email address for all locations. Is this possible?

Also, but less importantly, can the notification email ONLY be sent if the respondent selects "yes" from a Yes/No field?

Link to comment
Share on other sites

3 answers to this question

Recommended Posts

  • 0

You can achieve this functionality using cascading dropdown and acknowledgement email. Here is an example which explains how to send emails based on the department the submission belongs to.

Make a look up table "tbl_lu_emails" with fields "department" and "email".

Fields and Records:

department email

-------------------------------------------

Sales sales@company.com

Support support@company.com

Management management@company.com

Then in your DataPage "department" will be a dropdown and email will be a cascading dropdown with parent field as "department".

Use the above look up table for the dropdown fields. See how to set up a cascading dropdown at http://howto.caspio.com/datapages/form- ... boxes.html.

Now you can set Acknowledgment Email to be sent to the "email" field. If you do not want the email field to be visible in the form you can hide it. See how, http://howto.caspio.com/customization/h ... pages.html.

In this way if user selects Sales then the Email field will have the email address of Sales department.

Note: You cannot use this method if you are already using the acknowledgement email.

Link to comment
Share on other sites

  • 0

Below are the updated articles from Caspio's Online Help Center to achieve the above solution:

 

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.

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

×
×
  • Create New...