Configure Columns

The next step is to configure the columns by setting their general properties, constraints, and other settings.

1. To configure the columns, click on the link as shown below:

Click to configure the columns

1. 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 (since we want it to be the primary key). Other details can be optionally configured if required.

Configure column - EmployeeID

1. Configure the remaining columns (FirstName, LastName, etc.) one by one, wherever applicable. The columns that are not configured are indicated using a red warning symbol, as seen in the above image. You can choose to modify the existing settings or retain the same.

2. Click Save to save the configured settings for all columns.

Note: 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.