Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to set default value for Popup LOV?

John like many othersJun 22 2020 — edited Jun 24 2020

Hello

I have a table in an Interactive Grid and one column is displayed as Popup LOV. I would like now to set a default value if the user clicks on button "Add Row".

LOV example:

Display name     Value

Apple                    1

Banana                 2

Coconut               3

I want to set "Apple" as default whenever a new record will be created. That sounds pretty simple... If I set the default for this column as "Apple" it displays "Apple" on a new record but on saving I got an error as it tries to insert "Apple" into a numeric field. Sure, I could use the default of 1 (value of Apple) but that is not so nice and confuses the user expecting "Apple".

So how I can set a default value on adding a new row?

-> Working with Apex 19.1

This post has been answered by InoL on Jun 22 2020
Jump to Answer
Comments
Post Details
Added on Jun 22 2020
4 comments
4,263 views