Can't select entry from lookup list with extra display fields using keyboard (v2024)

PHPMaker General Discussion (PHPMaker)
1

This is similar to This Post but it did not solve my problem. I have V2024 and wish to allow my users to use the keyboard for grid entry. If I have a lookup field with display 1 = link (UserID), it works perfectly to advance using down arrow to select and tab or enter to accept or typing in the whole field and just pressing tab. Very fast data entry!.

But! If I have display 2 (First Name) and display 3 (Last Name), it fails with the browser indicating “Value does not exist” in small red below the box. It is as if it is trying to compare the lookup list allowable links to the browser field (which includes 2 display entries).

If I click on the desired item instead of arrow down and enter/tab, it works perfectly.

Edit Tag Config:
Custom Attributes : ["onkeyup" => "this.value = this.value.toUpperCase();"]
Use Lookup Table and Force Selection checked

Lookup Table Config:
Link field = Display field 1
Display fields 2 and 3 are other varchar fields in table
Order by is another field in the table
Sort ASC

I have tried many, many combos of the configuration and this is closest (and rational). I’m really hoping it is possible ‘cause the extra two fields are extremely helpful to make sure the operator selects the correct UserID!

2

If you use native HTML <select> element, keyboard selection works by matching the beginning of option text. That is default browser behavior. If you Select2 without search box, Select2 also search from the beginning.

You may however try either:

  1. Select2 with search

  2. AutoSuggest