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

Question

Drop down menu not updating with SQL table view in form

Forms

Updated May 7, 2018

asked on May 7, 2018 • Show version history

So I have a bunch of folders that I'm populating a drop down list with in Forms from the Laserfiche repository database. I want it to be dynamic, so every time someone adds a new folder, the drop down list will automatically pick up those folders. My view in SQL is working correctly (picking up new folders created), but it will not show in Forms. Here are some results of the view in SQL, however it is not updating in Forms (see other picture). You can see all the scanned folders are being seen by the view but not in my form. I have tried refreshing the data source in Forms many times already. Any suggestions?

SQL:

List.png (23.46 KB)

| Download

0 0

Answer

SELECTED ANSWER

replied on May 7, 2018

Forms will automatically turn your fields into a "Distinct" field. This means if there are identical fields, it will combine them into a single field within dropdown.

Your best bet is since you are already using a view to concatenate your fields so that the column are you using to show inside forms is "ID + Folder" in a single column.

0 0

Question

Question

Drop down menu not updating with SQL table view in form

Answer

Replies

Sign in to reply to this post.