Question

Lookup overrides default value for dropdown field

Classic Form Designer Forms Forms Layout Designer

Updated December 5, 2024

asked on July 15, 2024

We have a lookup for a Form that currently returns just one result, and populates a dropdown table. Since the dropdown is optional and we don't want the one result populating by default in this case, I added a default option and checked the box for lookup results to be appended. This way, I thought, there would be more than one option available, and the 'default value' would just be this informative message:

However, when I load the Form, the returned lookup value still populates by default, ignoring the usual behavior when there is more than one option and overriding my designated default value. To clarify, my custom value still does appear on this list, but is not selected.

I built a work-around by adding the desired value to my lookup table, but it's somewhat frustrating. Anyone have any thoughts? Do others have the same issue, Is this a known bug vs expected behavior, other workaround ideas, etc.?

Using classic Forms designer, Professional Version 11.0.2311.50564

0 0

Replies

replied on July 16, 2024

I believe your expectation is accurate, I have inquired internally and will post an update here when I get an answer.

1 0

replied on August 14, 2024

Hi Zachary,

I have another oddity associated with lookups and existing values. I currently have a drop-down field I'll call "Sponsor" with a single option of "Other." The rest of the options are populated by a lookup, with the original value appended to the lookup results.

I have another field with a formula. Assuming I select "Other" from the Sponsor list, if I set the formula like this:

=IF(Sponsor="Other", "True", "False")

I get "False"

If I set the formula like this:

=IF(Sponsor="Other", "", Sponsor)

I get "Choice 1"

Interestingly, if I set the formula like this:

=IF(Sponsor="Choice 1", "", Sponsor)

I get "Other"

There's some obvious mis-matching going on, but I cannot set the value differently and still allow lookup results to be appended to existing options (the field settings are mutually exclusive).

Short of adding "Other" to a table I really don't want to manipulate in that way, I'm not even sure how to get around this if I want logic predicated on the "other" choice. Any ideas?

0 0

replied on December 5, 2024

I'm experiencing the same issue. I'm trying to use the "Other" option appended to a dropdown with a lookup in a formula and it's just not working.

0 0

You are not allowed to follow up in this post.

Question

Question

Lookup overrides default value for dropdown field

Replies

Sign in to reply to this post.