I have a submission form that requests users to select a value in a drop-down.
I would like to use the selected value to look up an email address, based on this value, in a different table, and populate a virtual field with that email address.
I would then like to use the value in that virtual field to send a submission notification.
How can I achieve this? I cannot see how to load a parameter from another table based on the value of a field.
Any help would be much appreciated.
Yes, it's possible. You may trigger changing a field and when field is changed, insert email address into virtual field. Then using virtual field in Email field for your acknowledgement email. Since I don't know type of your datapage, I created code for details datapage.
Insert script in the footer of your datapage:
var x= document.getElementById("EditRecordEmail").value;
document.getElementById("cbParamVirtual1").value = x;
Insert your fieldname which you would like to trigger instead of Field1
Also I assume that you have email field on your datapage, so you need to insert your field name instead on Email in my code.
This way an email will be sent only if you changed value in specified field
Hope that helps