You are viewing limited content. For full access, please sign in.

Question

Question

Forms lookup doesn't fill dropdown with value

asked on August 18, 2020

When a user enters their basic information, it is supposed to automatically pull information from the form as a convenience feature. We have a pretty simple lookup that works correctly on all of our text fields, but not on the dropdowns.

 

 

The values are unique in the database, and there's no issues with extra white spaces or misspellings. Even weirder, when I inspect the response from the forms server on lookup I get all the possible values of Property Type and Type of Business, when I would really only expect one:

 

    {
        "defaultValue": "",
        "id": 7,
        "type": "select",
        "validationFieldValues": [],
        "value": [
            "Bed and Breakfast",
            "Hotel",
            "Motel",
            "Cabin",
            "Cottage",
            "Lodge",
            "Campsite",
            "Other"
        ]
    },
    {
        "defaultValue": "0",
        "id": 8,
        "type": "select",
        "validationFieldValues": [],
        "value": [
            "Brick and Mortar",
            "Internet"
        ]
    }

We only have test data in the DB right now, here is a snip showing the values:

Can anyone help make sense of this?

This is with Laserfiche Forms Professional Version 10.4.3.216

0 0

Answer

SELECTED ANSWER
replied on August 19, 2020

Brian, on your list field, check to see if the box for "Append choices to lookup results" is checked. If so, that's likely why it's not automatically selecting from the lookup. Try turning it off.

1 0
replied on August 19, 2020

Thanks Pieter, that was exactly it. I could have thought I was going crazy...

1 0

Replies

replied on August 18, 2020

Brian, have you tried just filling one drop down?

0 0
replied on August 19, 2020

Hi Jim, I have and got the same behavior.

0 0
replied on August 18, 2020

Besides lookup response, you may also inspect the request to see whether trigger values and return values actually match.

0 0
replied on August 19, 2020

Thanks Ziyan. I'm sure that the trigger values match because there are many more fields associated with that lookup rule, I only showed the dropdowns. All the text fields associated with the same lookup rule get populated with the correct information.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.