Question

Is it possible to dynamically select a data source selection based on a form variable?

Forms Integrations

Updated March 11, 2019

asked on February 12, 2019

Hi All,

We have two databases, "North" and "South". We need to dynamically select a database for the in form lookups based on a variable in the form. IE if the user selects North from the drop down field then the data lookup need to come form the "North" database... Both databases have an identical table structure.

Has anyone successfully done this?

Thanks

0 0

Replies

replied on February 13, 2019

The only real way to do this natively (that I'm aware of) would be to have two separate dropdowns and use field rules to show only the one for the selected database.

Alternately, you could do it in SQL by setting up a stored proc that takes North/South as a parameter and queries the appropriate linked server.

0 0

replied on February 13, 2019

Thanks for your reply Scott,

After some hours of trial and failure we too have come to the conclusion that the easiest way to accomplish this is to have a *controller* database where a sproc is called, passing in the north/south variable as a parameter.

That database then calls the real north or south database to obtain the required data.

To expedite implementation as quickly as possible, this is the route we will pursue.

Cheers,

Kent.

0 0

replied on March 11, 2019

Thanks for the feature idea. I've included this idea in our Forms feature ingestion portal for review.

Hopefully the solution you went with worked for your use case.

0 0

You are not allowed to follow up in this post.

Question

Question

Is it possible to dynamically select a data source selection based on a form variable?

Replies

Sign in to reply to this post.