{"id":13941,"date":"2024-02-01T14:21:08","date_gmt":"2024-02-01T20:21:08","guid":{"rendered":"https:\/\/traust.com\/?p=13941"},"modified":"2024-02-01T14:29:58","modified_gmt":"2024-02-01T20:29:58","slug":"change-select-list-color-in-oracle-apex-based-on-user-defined-colors","status":"publish","type":"post","link":"https:\/\/traust.com\/blog\/change-select-list-color-in-oracle-apex-based-on-user-defined-colors\/","title":{"rendered":"Change Select List Color in Oracle APEX Based on User-Defined Colors"},"content":{"rendered":"

In a previous Oracle APEX tutorial, my colleague Andrew Schultz wrote about how to conditionally change the background color of a select list<\/a> based on the chosen option. This works great when you have a fixed set of options that will never change, but the solution is limited, because it requires a developer to make edits to the code if you need to add or change colors. In this tutorial, we\u2019ll show you how to expand this functionality, allowing authorized users to define a list of colors that can then be used to dynamically change the color of a select list in Oracle APEX.<\/p>\n

Manufacturing Production Kits<\/h2>\n

For this tutorial, imagine a manufacturer who assembles bulk parts into a variety of different packages for resale. Each of these production kits has a distinct Bill of Materials (BOM) and is classified using a separate color. Workers on the assembly floor receive production orders for these production kits based on color and can then reference the BOM for that color in order to assemble each of the different kits. Our APEX app will allow users to define the available colors for each production kit and then select from a list of those colors for each kit.<\/p>\n

For our demo app, we\u2019ll need the following:<\/p>\n