Skip to Main Content
Feature Request FR-3801
Product Area Page Components
Status ROADMAP

25 Voters

Default Selection in Text Field with Autocomplete when only one selection remains

jon dixon Public
· May 18 2024

Idea Summary
Provide an option for the Text Field with an Autocomplete page item to prevent users from tabbing out of the field without selecting a valid value. Also automatically select the option in the filter if the user has narrowed the search to just one number. For example, take a LOV with the following account numbers: 129812, 128309, 128310, and  125910. When users type 129, allow them to tab out of the field and automatically select account number 129812.

Currently, the Text Field with Autocomplete page item allows you to tab out of the field (and does not autocomplete) if you have narrowed down the result to just one option. This means you have to perform additional validations on save.

Use Case
Many power users enter large amounts of data, e.g., accountants who enter account strings with account numbers, cost centers, companies, etc. These users know the number they want to type and want it to be defaulted as soon as there is only one selection left and a tab out of the field. 

Preferred Solution (Optional)
Add an additional property to the Text Field with an Autocomplete item type called ‘Defaulting Behavior’. When selected (and there is 1 choice remaining in the filtered list of items in the LOV), the field would allow the user to tab out of the field and automatically select the value. 

Also, add another property, ‘Prevent Partial Selections’. When selected, the user cannot select a partial value and tab out of the field.

These two options would provide significant throughput improvements to users who enter a lot of code-type entries while still ensuring only valid selections are allowed.

This is currently on the roadmap for a future release of Oracle APEX.

Comments

Comments

  • jochen.zehe OP 1.1 years ago

    I don't use Textfield with Autocomplete a lot, but still this feels like a very good improvement to the item type!