--- title: "Add a List or Combo Box" slug: "add-a-list-or-combo-box" updated: 2026-07-06T13:24:50Z published: 2026-07-06T13:24:50Z canonical: "skthelp.syniti.com/add-a-list-or-combo-box" stale: true --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # Add a List or Combo Box ## Overview A List or Combo box is a column input type that displays a field as a list or a text box with options from a selected table or view. It is recommended to create a view based on the tables for the list box. This SQL view or table, registered as [Datasets](/v1/docs/datasets), stores selectable options available in a list or combo box and configured as a column property on the construct page. - Use a list box when the list view contains a finite number of records that can display in a short, scrolling list. You can default a list box to a required value while adding records using the Default Value property, and also restrict editing operation using the Control Status property. - Use a combo box when the list view contains more than 3000 records to display as a list box. This option allows users to start typing in order to find values included in the list dataset, minimizing server queries and improving responsiveness. > [!NOTE] > Note > > To convert the column input type from a list box into a combo box, turn on the **Combo Box** toggle. When creating list views: - Create a dataset as a view based on the tables used for the list box, and use the following naming convention: webXXXList, where XXX describes what is being listed. For example, webProductList. - Include only the columns that apply to the field - **List Value Field:** The value stored in the table - **List Display Field:** The option visible in the list box - **List WHERE Clause:** Restricts values that display in a list box - **List Description Field:** The tooltip value that display on hovering a list box record. - Include a unique set of data. - Do not sort in the view’s DDL statement. ## Create a List Box 1. On the Cloud Construct’s home page, edit the required WebApp. The WebApp configuration page is displayed. 2. Access the Grid or Form node of your required construct page. 3. Select the Fields node and click **Add** **Fields**. The Add or Remove Fields dialog box is displayed. 4. Select the required field from the Dataset and set the column’s input type to **List**. 5. Click **Save**. 6. In the Fields node, select the List Box column input type. The Details Pane is updated with the selected column input field. 7. Enter the properties for List Box as required using the table below. | Field Name | Description | Supported Values/Notes | | --- | --- | --- | | Name | The field or property name | Select the name of the column from your dataset to display in grid/form | | Ordinal | Specifies order of fields within a container | Any integer. default: 0 | | Control Status | Controls the availability of the field when switching between edit/insert mode. | *** Disabled:** The field won’t be available for updates, but display-only *** Enabled:** The field will be available and displayed for updates *** Hide:** The field won’t be displayed and not available for updates. default: Enabled | | Control Status Field | Select the column from the same grid or form container dataset whose per-row value controls whether this field is disabled (0), enabled (1), or hidden (2). | This property offers an alternative to using a separate dataset (for example, CCD) to control the state of a field. | | Is Key | Specifies if field is a key field | default: false | | Required | Is the field required for add/update | default: false | | Required Type | *** Hard:** When set to hard required, the user must populate the field before saving the record. *** Soft:** When set to soft required, the user can save the record with an empty field, but a validation error appears after saving, indicating that the field should be populated. | default: Hard | | Combo Box | When enabled, the list box is converted into a combo box. The combo box remains empty until the user types at least one character. | > [!NOTE] > Note > > Recommended for large list datasets that has more than 3,000 records. default: false | | Default Value | Default value when adding records | A value as per the field data type to be used as a default value when adding records. maxLength: 50 | | Placeholder Text | Text displayed when field is empty | Any string within length constraints. maxLength: 255 | | Dataset | SKP dataset for the data used for this field. Select the required Dataset. Scroll down the Dataset list to auto-create a dataset using a table or view based on Cloud Construct’s recommendation. > [!NOTE] > Note > > If a dataset is being created from a SQL view, you must set its **Affected Table**. Click the **Open Details** ![](https://cdn.document360.io/ca09b4e9-1857-4c63-9f0e-1f25f166f447/Images/Documentation/image(896).png?sv=2026-02-06&spr=https&st=2026-11-17T19%3A45%3A29Z&se=2026-11-17T20%3A45%3A29Z&sr=b&sp=r&sig=CNnCD0LaT2K9bn2SXd8YI%2F2jf9xEy7LO%2Bfr6ucob1d4%3D) button next to the Dataset list to open it in the SKP Catalog. | > [!NOTE] > Note > > - The **Update Dataset** button opens a dialog box that allows you to rescan the dataset and add any newly available fields from the underlying table or view to the dataset used in this container. > - Specify the dataset classification. > - If the scan errors out, access the associated Datastore’s scan logs in the SKP Catalog module to troubleshoot the error. | | Stored Value ***required*** | Stored value field from dataset. Select the field name from the dataset that will be used as the *value* behind the scenes — like an ID or code that the system uses internally. | For example, if you have a countries list box dataset, the stored value field might be the `country_code` with values like `US`, `FR`, `DE`. | | Display | List display field from dataset. Select the field name from the dataset that will be *shown* to the user — something readable and user-friendly. | For example, for the same countries list box dataset, the display field might be `country_name` with values like `United States`, `France`, `Germany`. | | List Selector | List options selector field from dataset. Select the field name from the dataset that contains all possible values/options that users can choose from when adding/editing records or filtering in the grid. | For example, for the same countries list box dataset, the list selector field might be the same `country_name` field with values like `United States`, `France`, `Germany`, `United Kingdom`, `Canada`, `Japan` ; defining which countries appear as selectable options. | | List Allow Insert | Controls whether a user can use a value in the list or combo box that is not included in its dataset. | *** No:** Insert is not allowed. Users can only select values from the list dataset. *** Yes:** Users can enter any custom value in the field, but these custom values are not persisted in the list dataset. They only persist in the table for that record on the Construct page, providing flexibility for unique or one-off entries without affecting the list dataset. *** ConstrainedToTable:** Provides a filtered viewing experience while maintaining data integrity. When filters are applied to the list, users see only filtered values, but users who know unfiltered values can still enter them as this mode ignores the applied filters. This mode is useful when you want to constrain the display while allowing users access to all options from that list dataset. default: No. | | Tooltip | List Description field from dataset. Select the help text or description field that appears when users hover over the List Box record. | For example, for the same countries list box dataset, the tooltip field might be `description` with values like `Select the country where your business operates` or `Primary location for tax purposes`. | ### Add Dependent List Box Filter 1. If required, specify list filters to implement dependent list fields that constrain the options (records) returned to the required list fields. For example, when a user selects a Country from the Country list box, the State and City list boxes will be filtered to show only options for that country, enabling users to select valid combinations without manually filtering the Grid. You can also apply multiple filter conditions to the list box using the same field. For example, you can set criteria such as “EmployeeID greater than 2 AND EmployeeID lesser than 10” to restrict the list box dataset to a specific range of values. > [!NOTE] > Note > > Click **Add** to set up required dependent list filter conditions. | Field Name | Description | Supported Values/Notes | | --- | --- | --- | | List Dataset Field | Field in the List dataset to be used for the Comparison against a fixed value or a field in the grid or properties card's dataset to limit the values available in the list. | For example, .Country. The column in the list dataset that identifies which country each state belongs to. | | Comparison Operator | Comparison operator | Select one of the following supported operator values: - Equals - NotEquals - GreaterThan - GreaterThanOrEqual - LessThan - LessThanOrEqual - Like - NotLike | | Data Record Field Value | Data Record field from the Grid or Property Card dataset for the comparison against the List Data Set Field. The value in this field for the current Grid or Property Card’s record is used as the Comparison value. | For example, .address_country. When you have the List Data Set Field set to Country and a comparison operator of Equals, then the value you have in your address_country field will be used to filter the values available in your List box. | | Fixed Value | Constant value that will be compared | Static value for filtering. For example, United States. maxLength: 250 | | Dynamic Field | Runtime parameter name used to filter the list box dynamically through shared fields. The value is resolved at runtime from the page context and compared against the List Dataset Field. | For example, selectedRegion or parentCountryCode. The value is looked up from context variables available to the page, such as Shared field values passed from a parent container. When set to selectedRegion with List Dataset Field as Region and Equals operator, the runtime value of selectedRegion filters the available list box options. maxLength: 128 | ### Add List Box Order By Fields 1. If required, add List Box Order By Fields to sort selectable options in a list box based on another field. By default, the fields used to sort the list are sorted in ascending order. > [!NOTE] > Note > > Click **Add** to set up required sorting order using another field. | Field Name | Description | Supported Values/Notes | | --- | --- | --- | | Ordinal | Specify the priority of the selected field used to sort the list box dataset. | Any integer. default: 0 | | Sort Order | Select the sort order to sort the list box. | default: Ascending | | List Column Name | Select the column in the list box dataset that determines the order of the list values. | NA | ### Add Page Bindings 1. If required, add the required page bindings to define how data is passed between pages when navigating through links. Refer to [Link to a Page and Add Page Bindings](/v1/docs/link-to-a-page-and-add-page-bindings) for more information. ### Grid Configurations 1. If required, complete the following additional configuration as needed: > [!NOTE] > Note > > These fields are applicable only to columns added to a grid container. | Field Name | Description | Supported Values/Notes | | --- | --- | --- | | Is Hidden on Grid By Default | Controls column visibility by default | default: false | | Width Flex Grow | Controls if field grows based on content | default: false | | Sortable | Specifies if field is sortable | default: true | | Filterable | Specifies if field is filterable | default: true | | Resizable | Specifies if field is resizable | default: true | | Sort Mode | Configures default column sort order | * Ascending * Descending * None default: None | | Sort Priority | Priority for sort operation. Used with Sort Mode to configure the default column sort order | Any integer. default: 0 | 2. Click **Save** after completing the required list box configurations. ## Related Articles - [Build Assist](/v1/docs/build-assist) - [Configure Column Properties](/v1/docs/configure-column-properties) - [Configure Form Display](/v1/docs/create-a-construct-page#configure-form-display) - [Configure Grid Display](/v1/docs/create-a-construct-page#configure-grid-display) - [Datasets](/v1/docs/datasets) - [View for a List Box](/v1/docs/view-quick-reference-guide#view-for-a-list-box) - [Working with the JSON Editor](/v1/docs/working-with-the-json-editor-1)