Question

Creating a Four-Tiered Dynamic Field Configuration in Forms

Forms Version 10 How To

Updated September 29, 2017

asked on September 26, 2017

It appears the closes way to create a four-tier "dynamic field" like experience in forms is to use Lookup rules to populate drop down fields from a database table. As you can see from the images below, when the lookup rules have multiple "When" conditions, an Auto fill button will appear on the form next to the field specified in the second condition.

Can someone confirm that this is still the "best practice" to create a dynamic field-like experience in forms, the way we have in using Laserfiche Templates?

Multiple When conditions Require Auto fill button-New Hire Form.png

Multiple When conditions Require Auto fill button-SQL Table.png

Multiple When conditions Require Auto fill button-Lookup Rules.png

Multiple When conditions Require Auto fill button-New Hire Form.png (13.45 KB)

| Download

Multiple When conditions Require Auto fill button-SQL Table.png (163.47 KB)

| Download

Multiple When conditions Require Auto fill button-Lookup Rules.png (101.46 KB)

| Download

0 0

Answer

SELECTED ANSWER

replied on September 29, 2017

Based on Steve's reply and a little more research of previous posts on the Autofill button, I was able to achieve the "Dynamic Fields-like" experience I was seeking in a four-tier drop down field configuration in forms by combining the same Lookup Rules shown above, along with a short javascript code that uses the CSS class LookupCondition for each of the fields (Business Unit, Department, and Division) that are used in the conditions for the lookup rule.

The Autofill button is then hidden using the CSS rule.

Thanks for providing me the direction, Steve and Eric Cressey for previous posts on the Autofill button!

Multiple When conditions Require Auto fill button-New Hire Form-Rev 2.png

JavaScript for Triggering the Autofill Button When the Lookup Condition Changes.png

CSS Rule that Hides the Autofill Button.png

Multiple When conditions Require Auto fill button-New Hire Form-Rev 2.png (6.69 KB)

| Download

JavaScript for Triggering the Autofill Button When the Lookup Condition Changes.png (13.28 KB)

| Download

CSS Rule that Hides the Autofill Button.png (7.79 KB)

| Download

0 0

Replies

replied on September 27, 2017

Hi John

In the case of nested lookups, not really a better way that I've found

In the latest versions of Forms (10.x), they have added a feature (Checkbox) in the Lookup rule to Hide the Autofill button so you don't have to deal with clicking the Autofill button.

It makes for a better experience.

If you are at a version where this is not available, I've seen where people will use JS to hide/click the AutoFillbutton, but if upgrading is an option I'd look at that.

0 0

You are not allowed to follow up in this post.

Question

Question

Creating a Four-Tiered Dynamic Field Configuration in Forms

Answer

Replies

Sign in to reply to this post.