Question

Data Query values into dropdown

Laserfiche Cloud Rules

Updated August 14

asked on July 28

Hi,

Is it possible to populate a form's dropdown with a data query rule?

In the Data Query Editor Rule test it shows this:
A
I have this selected in the form:

I've tried using the Rules Service Task, selecting the Output values, selecting the Rule parameters and the Form variable.

I've tested it and viewed the Monitor option. In the Monitor->History tab, it shows the parameter value with all 52 values, and the form field value only has the first one.

I've also tried to use the Workflow Service Task by creating a workflow that returns the results in a multivalued output Parameter.

I get the same result, only the first row shows as an option.

0 0

Replies

replied on August 14 • Show version history

Currently, Forms only supports Data Query Rules that use a Lookup Table, not Remote Agent. We will be releasing an update to Cloud that enables direct connections to databases (no Remote Agent) and query rules created from these data sources can be used in Forms. This means you can directly query your external database and use that data in your Forms. Look for this new feature in the next month or so.

- Andrew

2 0

replied on August 5

Yes, we populate Drop Downs all the time with a look up rule. We would set the Drop down with no choices as you have done. If by chance you are also attempting to populate or Select and option in the Drop Down with a URL, then you will find the Drop Down will only show you the option you are injecting with the URL and not the whole list.

0 0

replied on August 11 • Show version history

Hi Steve, the lookup rule is on lookup tables that are created.(I was trying to not use up a lookup table.) I am referring to data query which is using the remote agent. It pulls the data but cannot populate it into the dropdown. It considers each row a completely new dropdown. I tried finding an answer and came upon this post.

I eventually did use a lookup table and did these steps:
1. Create a data query rule to get the data
2. Create a lookup table for the data
3. Create 3 rules, an insert, query, and delete rule for the lookup table
*There's a replace lookup table data tool in the workflow but I think it's based on the document being a csv
4. Create a workflow that uses the delete and insert rule
5. Schedule the workflow to run each night
6. Use the lookup query rule to populate the dropdown upon form start

I am excited for the feature.

1 0

You are not allowed to follow up in this post.

Question

Question

Data Query values into dropdown

Replies

Sign in to reply to this post.