Skip to Main Content
Feature Request FR-2942
Product Area Page Components
Status CLOSED

12 Voters

Manual Entry on LOV with Validation

jessica.wilson4 Public · Jan 23 2023

Idea Summary
Alllow for pasting of data into pop-up LOV or select list fields without needing to open up the LOV box first.

Use Case
I have interactive grids with 30-40 lines where the users want to cut/paste data from another source. The only way to allow them to paste directly into the field is to allow for manual entry. But this allows for invalid values to be entered. To prevent the invalids, I have to use custom javascript to let them know their value isn't valid immediately or do a page validation. If I don't allow manual entry, they have a few extra clicks per line to open the LOV and select the value they want.

Preferred Solution (Optional)
It would be great if the "manual entry" and "display extra values" could work together to allow for pasting of LOV data but still validating it against the valid values.

We reviewed this idea carefully, and while it was interesting, we concluded that due to all the internal implications we need to take into account, it is unlikely to make its way into APEX.

Comments

Comments

  • vincent morneau Admin OP 1.7 years ago

    Hi @jessica.wilson4 

    In the upcoming APEX release, the new combobox will support this and could superseed some use cases for popup LOV like this one. I'm going to mark this idea as closed, but only because it will be possible using a slightly different approach in the future.

  • jessica.wilson42 OP 1.2 years ago

    Hi @vincent morneau

    Unfortunately, I just got the chance to try the new combobox and it still doesn't meet the need.  I can paste into it but because of the manual entry feature, there doesn't seem to be any validation against valid values.  Seems like I'm still stuck with JS to validate or page validations.