Auto Emails

[flashcz]

Hi can anyone tell me if its possible to send out an auto email to 1 or more people based on the selection of a drop down box on a submission form.

Thanks

Derek

[nkamalan]

Let's say based on the department user selects you would like to send out emails. You can achieve this functionality using cascading dropdown and acknowledgement email. There two ways depending on which field, department, email address or both are desired to be saved in the new record.

In this example we have a look up table called "tbl_lu_emails" including two fields "department" and "email".

department email

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

Sales sales@company.com;sales2@company.com;sales3@company.com

Support support@company.com,support2@company.com;support3@company.com

Management management@company.com;management2@company.com;management3@company.com

Please note you are separating emails by (.

Approach 1: Using this approach only email address will be saved in the new record.

Use a dropdown element and select the look up table as datasource. Select the department field for "Display" and the email address for "Value".

Then set up the Acknowledgment Email based in the dropdown field.

Approach 2: Using this approach, both department and email address will be saved in the new record submission:

In this method we will use a dropdown for department and a cascading dropdown to pull up the associated email. See how to set up a cascading dropdown at http://howto.caspio.com/datapages/form- ... boxes.html.

Now you can set the 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.

Cheers!

[nkamalan]

The solution above is for Caspio Bridge though not Express DB. Which one are you using?

[flashcz]

Im using Caspio Bridge, thanks for the help I will see if I can get it to work