• 0
Login to follow this  
logistics

Access field from a different table in a submission form

Question

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

Share this post


Link to post
Share on other sites

1 answer to this question

  • 0
On 6/16/2017 at 5:02 AM, logistics said:

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

Hi Julien, 

It seems that you just need to use cascading fields. You can use different data sources for parent and child fields

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Login to follow this