Configure Properties
Last updated
Last updated
Configuring column properties ensures that your data is accurate and consistent in the database. Setting the right data types, constraints, and relationships prevents errors and improves data integrity. It keeps the database manageable and scalable, making future updates easier.
After loading your data into PowerTable, you can configure the column properties in the Columns section.
The column properties include the input type, whether the column is editable or not, its default value, minimum and maximum values (constraints), lookup and relation, prefix, suffix, etc.
While importing CSV data or creating a database from scratch, you will be allowed to configure these properties during the initial steps.
When connecting to a database, PowerTable automatically detects and configures the input type and other basic settings. You can either retain them or change them as needed to meet specific business requirements.
You can modify the column properties at any time by selecting Setup > Columns.
This opens the column setup window, as shown below.
The 'Display' field allows you to display or hide a column from the table. You can uncheck this box to hide a specific column. This is useful when certain data does not need to be displayed but should remain in the table.
This field specifies whether the user must enter the values in the column or if they can be left blank. Checking this box makes the column mandatory. You can specify which columns are required.
Typically, primary keys and business keys are considered required columns.
To edit a column's properties, click the pencil icon next to it or double-click the column name.
The column properties are broadly classified into General and Display properties.
Configuring general properties includes defining the column's input type, constraints, and default value.
Display properties include a column's display name and its description. For number-type columns, you can also configure the required prefix, suffix, and thousand separator.
We will explain each of the above in the upcoming sections.
