Question

Load datas in dropdownlist in forms from database

Forms

Updated March 12

asked on May 30, 2015

I have a Form which has dropdownlist control,i need to fill the control with the data which contains in the Laserfiche repository,Is it possible to get the datas directly from Repository ? or i have to insert these into database and from database i have to fill the dropdown control?

Suggestions welcome!!

0 0

Replies

replied on June 2, 2015

Hi there,

Currently you cannot retrieve data from Laserfiche repository to Forms dropdown field options. I'll suggest creating a database table with the options and use lookup rules to retrieve the options when form loads.

1 0

replied on March 12

Is this something that can be done now? I have a list of document types and want to have one distinct list, not two places to maintain it.

0 0

replied on June 2, 2015

What exactly are you trying to do? You can set up a Forms data source and read data from the SQL database associated with your Laserfiche repository.

0 0

replied on July 20, 2015

Hi Miruna,

Are there any examples or documentation for configuring a drop-down in Forms to be populated by the contents of an LF template field that is a list?

0 0

View 2 previous replies

replied on July 20, 2015

List values for Laserfiche list fields are stored in the "LUP" table in the SQL database by field ID (prop_id). You can match the field IDs to their names in the PropDef table.

0 0

replied on July 20, 2015

Perfect, thanks!

0 0

replied on November 6, 2019

Miruna, which SQL database would the document name be in? We want to use this to drive the linking of associated documents further down the pike in our process, rather than having to open the repository, look up the correct document, and copy the name exactly. Thanks.

0 0

replied on November 7, 2019

Entry names are stored in the TOC table in the SQL database associated with the repository.

1 0

replied on November 7, 2019

Thank you!

0 0

You are not allowed to follow up in this post.

Question

Question

Load datas in dropdownlist in forms from database

Replies

Sign in to reply to this post.