Question

Dynamic Fields in a Laserfiche Form?

Forms

Updated May 1, 2014

asked on May 1, 2014

I am using dynamic fields on a couple of our templates but now that we have some forms published on our public web site, I need to have those same dynamic fields available in the form fields. I see where I can create a lookup rule but not sure how to go about making them dynamic (selection in field one controls available choices in field 2). Anyway to link a Laserfiche Form field back to a template field?

Thanks in advance.

Eric

0 0

Answer

APPROVED ANSWER

replied on May 1, 2014 • Show version history

You can associate form fields with a Laserfiche template when you go to save the form in the repository (using a Save to Repository service task in your process model).

Lookup rules are the way to get dynamic fields in Forms. Getting them to work is like creating dynamic fields with an external table in Laserfiche.

You'll need to:

Create a table in your database that has the values you want.
Make sure the table has been added as a data source to Forms.
Make sure the process has access to the data source.
Create a look up rule using that data source.

1 0

Replies

replied on May 1, 2014 • Show version history

Are you needing to have the available options in the drop-down field tied to a database?

You could make multiple fields with the appropriate options for each field. Then using Field Rules to say if this field equals this than show these fields. Then you would do the same thing with when an option is selected from the new fields that are shown.

This is an example of one we are using:

If you need to have a database lookup tied to the options in the fields, using Lookup Rules you can fill in the fields mentioned above very easily.

0 0

replied on May 1, 2014

I will need to do a database lookup. The initial drop down will have about 500 possible values. Then, there could be up to 20 possible values based on what was selected in the initial field.

Shortly after I posted this question, I found a topic that seemed to address what I am trying to do so I think I can take care of it. Our public forms server is in the DMZ which complicates it a little but I think we have a method to connect to an existing database that the Forms server will have access to.

0 0

You are not allowed to follow up in this post.

Question

Question

Dynamic Fields in a Laserfiche Form?

Answer

Replies

Sign in to reply to this post.