Configure Columns
The next step is to configure the columns by setting their general properties, constraints, and other settings.
To configure the columns, click on the link as shown below:
Configure the first column - EmployeeID as shown in the image below. We have set the input type for EmployeeID column as text, enabled editing and set it as a mandatory input. Other details can be optionally configured if required.
The columns that are not configured are indicated using a red warning symbol, as seen in the above image.
Then, configure the remaining columns (FirstName, LastName, etc.) one by one. For simplicity, we have configured only the General settings in the image above. In the following sections, we will look at some more advanced settings such as lookup & relation, constraints and display.
Editable supports the following column input types:
Number
Decimal
Text
Single-select dropdown
Checkbox
Date-Time
Date
Image
Person
URL
By default, the 'Checkbox' column type accepts Boolean values (true/false). To change it, go to the Constraints section - Default Value field in the 'Manage Columns' window.
In the same way, you can set constraints for each column input type under Constraints section.
The next step is configuring SCDs which is optional.
Last updated