Question

Using a value Placed in a Form field to automatically fill in another Field based on a data query

Laserfiche Cloud

Updated April 30, 2021

asked on April 28, 2021

I have setup a Data Query based on a simple Lookup Table in Data Management.

Its a List of 2 Columns. Item and Amount for example

Cheese 30.00

Milk 20.00

In my form i want to create a Table with these two fields.

When I choose "Cheese" in the Item Field i want The Lookup Query to bring back "30.00" from my Query and fill in the Cost field. The problem is that there seems to be no way to take that value and pass it to the "WHERE" statement in the Lookup Query.

The setup is quite different from the On Premise version of the lookup rule in forms.

Can anyone tell me if this can be done easily.

I have successfully created the lookup rule for selecting the Item from the table query but it will not fill in the second field .

It seems that Using an input Sting from one field to Limit or Fill values to another should be a Common function.

Thanks in advance.

Milton

0 0

Replies

replied on April 30, 2021

Any Ideas on a way to do this. In the On Premise version of Forms, the Lookup Rule allows you to use a WHERE statement that USES a value that was filled out on the form to execute the query. On the Cloud Version the Query has to be defined outside the Form and during setup it pretty much only allows you to use a static value in the WHERE statement. This limits the ability to automatically fill in data in other fields based on Value the user Chose on the Form. I would simply like confirmation from the Cloud team that i am not missing something here.

Thanks,

Milton

0 0

replied on April 30, 2021 • Show version history

Your query should be built with Select: Price, Where: Item and Item needs to be set as an input parameter to the rule. (Make sure to check the box for "Set as input parameter" when configuring the WHERE input value).

Then when you go to your form, go to the lookup rules tab and add a lookup. You should be able to hook up the Item column in your form to the item input parameter and hook the second column to fill with cost.

0 0

replied on April 30, 2021

Thanks Jared, we will give that a try.

Best,

Milton

0 0

You are not allowed to follow up in this post.

Question

Question

Using a value Placed in a Form field to automatically fill in another Field based on a data query

Replies

Sign in to reply to this post.