Send notification email to address based on form data

[fishsticks]

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?

[bahar_vm]

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.

[fishsticks]

Thanks bahar_vm, that was super helpful!

[AtayBalunbalunan]

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

• Cascading Elements: https://howto.caspio.com/datapages/datapage-components/cascading-elements/
• Hide Fields in DataPages: https://howto.caspio.com/tech-tips-and-articles/common-customizations/how-to-hide-fields-in-datapages/