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

Question

Question

How to autofill two drop downs but still let people chose items from the dropdowns once they've been selected.

asked on September 29, 2022

So I'm in a weird predicament. I accidentally removed a Form from a Data Source and broke the form, I've readded the Form to the Data Source but the Field Lookup rules have been erased and I didn't make this Form and really need help getting it rebuilt and I'm hoping it won't be that difficult.

All that I need is this. There are two drop-downs that fill with info from a lookup, Name, and Address. The way this worked before when you picked a Name it would autoselect the correct Address from the lookup or vice versa. However, when this happens you'd be able to still use the drop-down to change your selection.

However, with what I've been able to recreate when you pick one it auto fills the other but it wipes the dropdown to only include the Name and a blank space.

So with this if they accidentally select the wrong Name or Address the entire form is ruined and they have to restart from scratch.

How can I set this up in a way that picking a Name or Address autofills the other but still lets users change their option should they need to?

 

0 0

Replies

replied on September 30, 2022

It sounds like you need to remove the lookup condition from the lookup associated with the dropdown.

A dropdown populated from a lookup will only populate the matching results, so if you have no condition it will show all of the options. If you have a condition, it will only show the options that match the filter/condition.

It should probably look something more like this

Of course there are scenarios in which you do want a condition on a dropdown lookup, but in your case it sounds like you're using a condition that removes options you don't want removed.

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

Sign in to reply to this post.