Search the Community
Showing results for tags 'different table'.
Hello, 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. Thanks, Julien