Link Search Menu Expand Document

Checkbox Group

The Checkbox Group cell type allows you to create multiple checkboxes. It can be in both vertical and horizontal format.

chekbox-group-celltype

Note: If you want to save the checkbox group data in a table, set the destination field to “text type”. This is because the value of the selection items such as “Item 1, Item 2, Item 3” separated by commas is the value stored in the table field.

Steps to create a checkbox group with cell type:

  • Select a cell and go to Cell Type drop-down list.
  • Select Checkbox Group cell type.
  • Multiple checkboxes will be created in the selected cell to form a checkbox group.
  • You can place the checkboxes horizontally or vertically, merge cells and adjust cell widths. Click on the Cell Type tab at the bottom of the right pane for checkbox group settings. The controls are as follows:

checkbox-group-celltype-tab

ControlsDescription
Commands..Sets the command to be executed when the value changes. See the command for more information.
Set UI Permissions..Allows you to do enable/ visible/editable settings.
LayoutSpecifies the placement direction of the checkboxes- Vertical/Horizontal.
checkbox-group-celltype-layout
List itemSpecifies the text to be displayed on the right side of the checkbox. Default text is Item 1, Item 2, ..so on
- If you uncheck Get items from data table, you need to manually set the text.
- You can increase or decrease checkbox items with + and -
checkbox-group-celltype-list-items
-Click on Advanced.. to specify the value to be displayed in each checkbox i.e. Display Value and the value used in formulas and data concatenation i.e. Value separately.
If you check Get items from data table, you can get the value to be displayed and the value from the field of the table. When the data in the table changes, it is automatically reflected in the list items.
checkbox-group-celltype-list-items-data-table
You can set query conditions by Data Query.

Note: You cannot use Query Criteria in List View.

By clicking Sort Order, you can set the conditions for how to sort and display at runtime. –> Check Add an item “Other” to display Other as an item and allow the user to enter a value in the text box. You can specify the width of the text box for input in pixels. The default value is 100. It cannot be used when Style is Toggle or Button.
If you use related fields, the table associations must be between tables in the same database and in the same instance. For example, if you have an association between Forguncy’s internal database and an external database such as SQL Server or Oracle Database, or if the databases are different and the instances are not the same between SQL Servers, the related fields cannot be used.
Same width for all itemsThis setting is displayed for Horizontal layout. If checked, all items will be displayed with the same width as the item with the longest string, regardless of the length of the item string.
Note: This setting is reflected only at run time, and there is no change in the display at design time. This item cannot be set in the celltype on the list view.
Column CountThis setting is displayed for Vertical layouts. The items are automatically wrapped and displayed so that the number of columns matches with this setting value. Note: This setting is reflected only at run time, and there is no change in the display at design time. This item cannot be set in the celltype on the list view.
Margin between itemsSpecifies the margin between checkboxes (in pixels).
StyleAllows you to choose from four options: System, Modern, Toggle, and Button. The default value is Modern.
Primary ColorSpecifies the fill color of the checkbox. It is not applicable for System type style.
Secondary ColorSpecifies the color of the tick mark. It is not applicable for System type style.
Read onlyIf checked, user cannot make changes to the state of the checkbox i.e. checkbox will appear in non-editable format.