Oracle APEX: allow additional values in the select list
I have a select list that has a is set to Static LOV with two values 'YES' and 'NO' but I want to allow the user to add additional values to it by typing them in or be setting the select list to a value in code. I have Display Extra Values selected but that still does not work. If the field is set to a value not in the static list, nothing gets selected. But if I check session state, P1_RESPONSE is set to the value I set it to in code. What can I do to allow an extra value to be entered?
Solution
A page item of type "select list" does not support that functionality. The "show additional values" attribute will display a value even if it is not available in the list definition.
Available alternatives are:
- Popup LOV. This supports additional values out of the box: check the "Manual Entry" attribute
- Use a select list combined with a dynamic action to control an additional page item. When a user selects value "other", the additional page item is shown allowing to enter the user whatever he wants.
- Exporting Combined Data from Multiple SQL Queries into a Single CSV Report in Oracle APEX
- setting a datetime into global application item
- Why I got error Ajax call returned server error ORA-01422: exact fetch returns more than requested number of rows for ajax_dispatch_request.?
- Populating Form Items with Values from an Uploaded CSV File in Oracle APEX
- Oracle Apex Change date picker format
- Select a row in a IG when dialog closed
- Set page item with value from interactive grid column when clicking on the grid region
- Can't disable session state protection on Oracle APEX 18.1.0.00.45 for Dynamic Actions updating Page Items
- Authentication scheme subscription gets lost on deployment of Apex applications
- Is there a way to modify the Rich Text Editor toolbar in an apex application when the editor is in a column inside an interactive grid?
- Oracle APEX - What is source of "Request" in "Request is contained in Value"
- Custom user attributes in Oracle Apex / User-specific filtering based on attributes
- Oracle APEX Dynamic Action call to package throwing error "ORA-06550: line 11, column 19: PLS-00302: component 'GET_EMP_INFO' must be declared"
- Maximizing a region using jQuery
- How to Handle Large REST API Responses in Oracle APEX Exceeding Page Item Character Limits
- Oracle SQL Insert Trigger to Handle Duplicate Contacts and Update Owner Field
- Oracle Apex page process calling stored procedure not working
- How can I keep anonymous user account perpetually open on Apex 19.2 running on Oracle DB 21c XE?
- Adding hyperlink to a row and displaying the specific row in another page
- How do I override the value of APP_VERSION substitution string in Oracle APEX?
- How to call an external API in Oracle Apex?
- Apex 22.1 How To Pass JWT To A REST Data Source
- How to find Oracle APEX WORKSPACE NAME and USERNAME?
- Selecting a column in a where statement
- Customizing the Record Level Actions of Interactive Grid with Oracle Apex
- SQL query inside PL/SQL Block is not working properly, Fetches all Data and ignoring WHERE clause
- Success message for an end user inside an SQL procedure
- ORACLE APEX ADMIN LOGIN ISSUE
- Invalid Login Credentials in Oracle APEX After Resetting the Password from the Administration Panel in ADB-S
- apex_exec.open_query_context where clause with bind variables