Configure Column Properties

You can configure various column properties as required based on the column input types that define the field behavior, what must be displayed, and how values are stored in both the Grid and Form display on a construct page.

Column input types such as Buttons, List Boxes, DateTime, define how columns work with configured properties. You can also manage the field behavior during editing or inserting actions in both displays using the Control Status property. Column properties can be applied to the Gird and Form display, which determine the context in which the control appears as configured. For example, a field can be a List Box in the Grid, but can be a display-only field on the Form. In this case, set the field’s Control Status in the Grid as Enabled, and set the Control Status as Disabled on the Form.

To display the complete dataset columns from a table or view by default, select the required Grid or Form display container and turn on the Display Fields in Dataset by Default toggle.

Column Input Types

Before adding column properties or overriding the Display Fields in Dataset by Default functionality for both the Grid and Form display, the column input type for each column must be set.

Currently, the following table lists the supported column input types:

Column Input Types	Description
List	Displays a field as a List Box with options from a selected Table or View registered as a Dataset. Refer to Add a List Box for more information.
Date	Displays a date picker on the formatted field that may or may not accept input.
Time	Displays a time picker on the formatted field that may or may not accept input.
Datetime	Displays a date and time picker on the formatted field that may or may not accept input.
Text	Displays a text field with an option to aid in linking pages and adding page binding criteria.
Number	Displays a number field with an option to aid in linking pages and adding page binding criteria.
Checkbox	Displays a check box that indicates whether a setting is enabled or disabled.
Toggle Switch	Displays a toggle switch that indicates whether a setting is enabled or disabled.
Text Area	Displays a text area field that accepts multi-line text input.
Button	Displays a button that can be clicked to run an event or navigate to another page. Refer to Link to a Page and Add Page Bindings for more information.
Default	Displays field based on schema defined within the dataset.

The steps for adding a column input type in the Grid and on a From are the same. However, after the record is saved in the Gird, the fields that display on the Form depend on the column input type added to that Form’s field.

To add a column input type:

On the Construct Preview’s home page, edit the required WebApp. The WebApp configuration page is displayed.
Access the Grid’s or Form’s node of your required Construct page.
Select the Fields node and click Add Fields. The Add or Remove Fields dialog box is displayed.
If required, turn on the Display All Fields toggle to include all fields from the dataset associated with the Grid or Form container.
In the Available Fields section, select the required fields from the dataset and click the Select (>) button. Multiple selected fields are moved to the Display Fields section.
Note
- You can also double-click on each required field or click the Select All (») button to select all fields.
- To deselect a field in the Display FIelds section, double-click on each required field or click the Deselect (<) or Deselect All («) button.
If required, modify the column input type using the datatype list displayed next to the selected field.
If required, you can sort the display fields by selecting a field and clicking the Up (↑) or Down (↓) button.
Click Save.
In the Fields node, select the column input fields. The Details Pane is updated with the selected column input field.
Enter the column input type properties as required using the table below in the Column Base Properties section.
Repeat Steps 5 and 6 until all column input fields are configured.
Click Save & Preview WebApp to preview WebApp changes.
Click Save WebApp .

Add a Button Without a Dataset Column

To add a button to a grid or form container for events that do not require a dataset column:

On the Construct Preview’s home page, edit the required WebApp. The WebApp configuration page is displayed.
Access the Grid’s or Form’s node of your required Construct page.
Select the Fields node and click Add Button. The Create Button dialog box is displayed.
Enter a name for the button and click Save.
In the Fields node, select the newly added button input column. The Details Pane is updated with the button fields.
Enter the button column properties as required using the table below in the Column Base Properties section.
Click Save & Preview WebApp to preview WebApp changes.
Click Save WebApp .

Column Base Properties

In addition to the general properties listed below, the following column input types have additional properties to aid in linking pages and adding page binding criteria:

List Box
Text
Number
Button

All column input types inherit the following general properties:

Note
Fields in the Grid Configuration section are applicable only to columns added to a grid container.

Note

The following column types inherit all the properties (with no additional properties) in the table below:

Date
Time
Datetime
Checkbox
Toggle Switch
Text Area
Default

Field/Property (Name: Type)	Description	Supported Values/Notes
name: string	The column or property name	Enter the name of the column from your dataset to display in grid/form. maxLength: 128
ordinal: integer	Specifies order of columns within a container	Any integer default: 0
control_status: enum	Controls the availability of the column when switching between edit/insert mode	* Disabled - Display only, no updates * Enabled - Available for updates * Hide - Not displayed, no updates default: Enabled
required: boolean	Is the column required for add/update	true, false default: false
default_value: string	Default value when adding records	A value (matching the field’s data type) to be used as default. maxLength: 50
placeholder_text: string	Text displayed when column is empty	Any string within length constraints. maxLength: 255
is_hidden_on_grid_by_default: boolean	Controls column visibility by default	true, false default: false
is_key: boolean	Specifies if column is a key field	true, false default: false
sortable: boolean	Specifies if column is sortable	true, false default: true
filterable: boolean	Specifies if column is filterable	true, false default: true
resizable: boolean	Specifies if column is resizable	true, false default: true
width_flex_grow: boolean	Controls if column grows based on content	true, false default: false
sort_mode: enum	Configures default column sort order	* Ascending * Descending * None default: None
sort_priority: integer	Priority for sort operation. Used with Sort Mode to configure default order	Any integer default: 0
direct_update: boolean	Allows direct updates when grid/form is in display mode	true, false default: false

Delete a Column Input Type

All components of a WebApp use the same process to perform the delete action. This also applies to column input type components.

To delete a component in a WebApp:

On the Construct Preview’s home page, edit the required WebApp. The WebApp configuration page is displayed.
Access the required component node in the Tree Navigation panel.
Select the required component and click More Options (…) next to your selected component node.
Select Delete.
Click Save & Preview WebApp to preview WebApp changes.
Click Save WebApp .