General

In this category, you can define the following properties:

1. Input type

Specify the input data type to be allowed in each column using this dropdown. EDITable allows the following data types as inputs:

  • Number

  • Decimal

  • Text

  • Single-select

  • Check-box

  • Date Time

  • Date

  • Image

  • Person

  • URL

  • Email

Input type

Further, you can configure additional properties based on the selected input type.

Example: For number type input, you can set the minimum and maximum allowed values. For single-select type, you can either manually configure the dropdown values or fetch them from a lookup table. These properties are explained in the upcoming sections.

2. Allow Edits

Check this box to enable users to edit the column values. Uncheck it to restrict users from modifying the column values.

In the example below, we have made all columns editable.

Primary keys and surrogate keys (in case of configuring Type 2 SCDs) are usually disabled from editing by the users.

Allow Edits

3. Required

This box indicates whether the user must enter the values in the column or if they can be left empty. Checking this box will make the column mandatory. You can select which columns you want to be required.

Typically, primary keys and business keys are considered required columns.

Required

We have discussed the general configurations. In the next section, we will explain about setting constraints.

Last updated