Question

Laserfiche Forms 9.1.1.1517 Performing Database Lookup Immediately on Form Load

Forms Version 9

Updated August 13, 2014

asked on July 7, 2014

I have a form that I created with 4 different fields on it. The first 3 fields are used to populate a 4th field (Validation Key) from a database.

1. Username

2. Password

3. Number

4. Validation Key (Default Value of 'Waiting for Validation')

I have disable the AutoSuggest for forms 9.1.1 per KB 1013402. The issue is that as soon as the form loads, it immediately performs the lookup on the first 3 fields, thus clearing out the default value for the field Validation Key. I need to prevent this from happening, and only allow the database lookup to execute when the Auto Fill button is clicked by the end user. Thank you for the help.

0 1

Replies

replied on July 7, 2014

One way to maintain the default value is with a field rule. It can be configured so that the acquired key field will show when all 3 ID fields are not blank. Similarly, a “dummy” field with the desired default value can be set to hide when all 3 ID fields are not blank. See the example below.

0 0

replied on July 7, 2014

Hi Kathryn,

Thank you for the update. Currently I am hiding the Validation Key field until Username, Password, and Number fields are not blank; however, it is still removing the default value for the Validation Key field.

I thought that the lookup would not run if there were multiple conditions that first had to be met (hence the Auto Fill button. Please let me know if you have a moment, and thank you for the help.

0 0

replied on July 9, 2014

Hi Lance,

All the lookup rules for the form will run on page load even there are multiple conditions for the lookup rule. Since the return value for the lookup rule is blank so the populated field will become blank. We have enhance this in 9.2 that the default value won't be override if the return value in blank on page load.

There seems no workaround in 9.1 to keep the default value for the populated field.

0 0

replied on July 10, 2014

could they use javascript and on blur or field change, if value is blank repopulate?

0 0

replied on August 13, 2014

Just wanted to post an update.

I found that entering a default value for both the Validation Key (Waiting for Validation) and a default value for Number (Please enter a number) seems to prevent the default value for ValidationKey from being populated on page load.

FORMS_VK_Lookup.png (28.14 KB)

| Download

0 0

You are not allowed to follow up in this post.

Question

Question

Laserfiche Forms 9.1.1.1517 Performing Database Lookup Immediately on Form Load

Replies

Sign in to reply to this post.