Rutvik Prajapati

In my previous post , I explained how to use Shuttle Item. In this post, I will explain how to use another multi-select item Checkbox Group.  In Oracle APEX, Checkbox Group displays multiple values as checkboxes and enables end-user to select multiple values. Like the Shuttle item, the Checkbox Group also stores values of checked boxes in a colon-delimited string. We need to provide a list of values for values displayed as checkboxes.   How to create a Checkbox Group?  Create a VARCHAR2 column having a large size as it stores a colon-delimited string. Navigate to an APEX page and create a page item in a region that is based on the database table. Change its type to "Checkbox Group". Go to the "List of Values" section in the property section and select the list of values type. Here I selected "Static Values".  Click on the "Static Values" and a popup will open. Add Display Value and Return Value in this popup as shown below.  Enter the number of

Often a time in our project we have a requirement to create a multi-select list item in order to represent a many-to-many relationship. For e.g. you want to implement a functionality where a customer can select multiple products they are interested in. I encountered one such requirement recently in my Telegram Integration application where a user can send a message in multiple telegram groups. For that user needs to select all the telegram groups in which he wants to send a message.  There are three native multi-select items available in Oracle APEX; Checkbox Group, List Manager, and Shuttle. In this post, I will explain how to create a Shuttle Item in Oracle APEX.  What is a Shuttle item? In Oracle APEX, a shuttle item renders as a multi-select list value. It has two boxes left and right. The left box (source list) displays all the values available to select and the right box (destination list) displays all the selected values. A user can select the values from left box to right box u