Hi - we are running DynamicForms v 4.10 on DNN Professional, V 6.1.5.
Our use case is as follows.  We have a form where we want to dynamically determine the recipient of an email using business rules from two field responses. 

For example, assume we have two fields submitted by the user: Hair Color and Eye Color.  If the user enters Hair Color = Blue; and Eye Color = Blue, then an email would be sent to bob@aol.com.  On the other hand, if the user entered Hair Color = Blue; and Eye Color = Green, then the email would go to carol@aol.com.

I can't find a way to make this work.  My approach was to use an SQL query to identify the email address to use, however, I don't seem to have a way for the Completion Event to use this result.

Can you advise how to support this?

Thank you.
Mark

Hi Mark,

Approx how many combinations are there and does the data have to come from the database? I would normally suggest a client side event / JavaScript.

Thanks,

Chad

Chad - thanks for the followup.  There are not too many combinations - probabaly 10 to 12.  My preference would be to manage this through the DB, but it this is not supported, javascript would be OK. 
Can you provide a quick comment on the JS approach to get us started?
Thanks
Mark

Hi Mark - Basically you would create a function within the the Initial JavaScript or Custom JAvaScript file that would pass in the variables and then have some if statements. I would just check out demo 20 which covers client side events and so forth and go from there. Let me know if you have questions or if you would like us to do it I believe it would be around 3-5 hours to handle and time can be picked up at http://www.datasprings.com/hours.

Let me know if you have any other questions.

Thanks!

-Chad