Question

3
Replies
1423
Views
Close popover
Jerome Recker (Jerome@quavo)
375008155608
Lead System Architect
375008155608
US
Jerome@quavo Member since 2015 27 posts
375008155608
Posted: February 24, 2017
Last activity: February 26, 2017
Closed

Enforced Auto Completes

Has anyone developed a reusable control that enforces auto complete selection? My problem scenario is below.

The auto complete is sourced by D_CompanyDetails, allows searching by ID, City, or Name, and sets the .SelectedCompanyID property to the value of .CompanyID.

CompanyID City Name

1234 Chicago Pizza Hut

5678 Detroit Little Ceasars

My problem is that nothing out of box enforces that a valid value is selected. For example, I could type in 9999 and tab off and my .SelectedCompanyID property would have an invalid value (9999 does not exist). Likewise, I could type in "Pizza Hut" and if I did not specifically arrow down and click enter on the "Pizza Hut" option, it would not set my .SelectedCompanyID to "1234". It would have the invalid value of "Pizza Hut".

I am able to create a when rule/activity that checks that my .SelectedCompanyID exists in the D_CompanyDetails data page, and force the user to select a valid value, however the problem with this is that the solution only works for this one scenario. The next time that I need to use an auto complete for something else, I have to create another activity/when rule to handle the validation.

Ideally a control would exist that does this for free. I'm only currently worried about data page sourced auto completes, however in the perfect world, the solution would also validate against the other sourcing options as well.

If the data set was small, I could enforce this with a dropdown. For a data set with thousands of records, this is not feasible.

User Experience
Moderation Team has archived post