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

Question

Question

Fill dropdown field in Forms from SQL Database

Forms Version 9 Capture
Updated October 9, 2015
asked on May 9, 2013 • Show version history

How do I fill a dropdown choices with a column from database?

I added the datasource to LF Forms but I don't think a lookup rule is what I need.

I need that when the form is open the dropbox choices are fill the the values from the column.

Thanks

 

1 0

Answer

APPROVED ANSWER
replied on May 29, 2013

You can fill a dropdown list with choices from an external database using the lookup rules in Laserfiche Forms.

 

To do this, create a new lookup rule that matches one dropdown list to a data source column when another field is set to a specified value.

 

 

If you automatically want to fill this dropdown when the form is opened, you would just have to hide the Car Company field and preset it to match the lookup conditions.

 

Let us know if you have any other questions!

2 0
replied on October 9, 2015

Hi, 

 

I have a related question. 

 

If I need to fill ONE drop-down in the form with data from two or more different columns from a database table, how can it be done.

 

e.g. I have three columns in the database with three different names, and I want those three entries, in one drop-down as three distinct entires 

0 0

Replies

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

Sign in to reply to this post.

Details
Related Posts
Loading ...