You are viewing limited content. For full access, please sign in.

Question

Question

Feature Request: Do Lookup Based on Field Value

asked on February 4, 2015

We have a Form for our onboarding process that is used for all new employees. Depending on the type of employee we hide certain fields since they are not required. Depending on the type of employee as well, we need to be able to different database lookups.

So what we would like to be able to do is dependent on what is selected from a radio button, tell Forms to perform a specific lookup. In our case we would have 3 different lookups that could be performed depending on the 3 options that may be selected from the radio button. When setting up the Lookup Rule, if there was an additional field directly after you specify the source that allowed you to say "When <fieldname> <=, !=> <fieldvalue>" that would be great.

0 0

Replies

replied on February 9, 2015

Hi Blake,

Thank you for the request! I've passed the information along to the Forms development team!

1 0
replied on May 24, 2017

Any update on this feature request?

0 0
replied on January 6, 2017

Is there any progress on this since it's nearly been 2 years since the last post? I just stumbled across this lack of feature in Forms today, couldn't believe it wasn't supported. Hoping there has been some progress made in the last 2 years....

1 0
replied on February 9, 2015

I think a stored procedure lookup instead of a regular lookup would work work in this case.  You can have the logic within the stored procedure direct to different tables dependent on a field. 

0 0
replied on February 9, 2015

Robert, I believe you are correct that stored procedure lookup could probably work, but the idea would be to have the functionality within Forms so that a user would not have to have someone create the stored procedure for them. wink

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.