Question

Populate a Drop down list in forms from a Laserfiche search result and display a list of children in a laserfiche folder

Forms Laserfiche Cloud How To

Updated June 9, 2021

asked on June 9, 2021 • Show version history

Can anyone shed light on how i might be able to Populate a Drop down list in forms from a Laserfiche search result and display a list of children in a specific laserfiche folder.

For example: The \Employee folder in Laserfiche has Children folders for Each Employee.

I would like to populate the List in forms based on the folder names.

Right now the only way i can see, is to update Lists manually in the Data Management section of Process Automation.

Thanks for any ideas.

Note this form will only be used by authenticated Participant users or full users.

0 0

Replies

replied on June 9, 2021

In Forms Administration set up a data source that points to your database and then add the form to that data source. Do you need additional information?

1 0

replied on June 9, 2021

Thanks for the quick responses. Let me review these and see what works best. I will update you on the results.

Milton K

1 0

replied on June 9, 2021

You might be able to this by taking input parameters in a message start event and then running a WF to pass back information to a user task. Something like

Message start event - collect search parameters -> Submit (with the option to load next task turned on)

Run WF - pass search parameters to WF, run repo search with those parameters, get list of folder entry names, pass those into a list field as the workflow output

User task - assigned back to the initiator, list field populated by WF output.

0 0

replied on June 9, 2021

Better would be if you had this info stored in a lookup table. In your example, it seems like every employee has a folder and you're trying to get a list of employees. If you built a WF to go through that Employees folder, you could populate a lookup table with all the folder names. Going forward, whenever a new employee folder is created, also add it to the lookup table. Then your lookups become easy lookup table queries and they can be done on the message start event form.

You could have a starting event watch for changes within employees folder and update the lookup table accordingly if you tie each lookup table row to the entry ID of the folder.

0 0

You are not allowed to follow up in this post.

Question

Question

Populate a Drop down list in forms from a Laserfiche search result and display a list of children in a laserfiche folder

Replies

Sign in to reply to this post.