General
The General section allows you to configure the data type, validation rules, constraints, and default values for a column.
Configure general properties
To configure the general properties:
Select Setup > Columns.
The column configuration window opens. Select the pencil icon next to the column name or double-click the column name.
Select the General tab in the side panel.
You can configure the following properties:
Input type
Use the Input Type property to specify how data is entered, stored, and displayed in a column.
Powertable sheet supports a wide range of input types. The available input types are determined by the underlying SQL data type assigned to the column.
For example:
Numeric data types such as INT, BIGINT, FLOAT, and DECIMAL support input types such as Number, Single Select, Decimal, Currency, Percent, Percent Complete, and Rating.
Date and time data types support input types such as Date Time and Single Select.
Text-based data types such as VARCHAR and NVARCHAR support input types such as Text, Email, URL, Phone Number, Person (name or email), Image (URL-based), Single Select, and Check Box.
Boolean data types support input types such as Check Box.
Depending on the input type you have chosen, you can set additional properties. For example, you can set minimum and maximum values for numeric input types and a list of selectable values for single-select columns.
For a complete list of supported column types and their details, see Supported column types.
Constraints
Use the Constraints section to limit input values and configure field validation.
Minimum and maximum
Use Minimum and Maximum to define the allowed range of values for a column. Values outside the configured range are not accepted.
These constraints are available for the input types of Number, Currency and Date Time.
Existing table values remain unchanged. When you enter values outside the configured range, powertable sheet displays a message indicating the permitted limits.
For Date and Date Time columns, you can define a valid date range or a date-time range. Values outside the configured range are not accepted.
Field validation
Use Field Validation to control the type of values that users can enter in a text column.
The following validation options are available:
Any value
Numeric
Alphanumeric
Non Numeric
Regex
When Regex is selected, specify a regular expression pattern to validate user input. Values that do not match the configured validation rule are rejected.
Other number properties
For decimal input type, you can configure the default number of decimal places to be displayed.
Select Allow Negative Numbers to allow negative entries in the column.
Default value
Use Default Value to automatically populate a column when new rows are created. This helps ensure that new records already contain a valid initial value and reduces manual data entry. The column values in the existing records remain unchanged.
Default values can be set using a manual static value or a formula.
Manual value
To configure a static default value:
Select Manual.
Enter the required value.
In the following example, NA is configured as the default value for the Product Description column.
When a new row is inserted, the configured default value is automatically populated, and you can later modify it when required.
Reset to default on update
Enable Reset to Default on Update to automatically reset the column to its configured default value whenever the record is updated.
When this option is enabled:
Existing values remain unchanged until the record is updated.
The value is reset to the configured default when you modify other fields in the same record.
In this example, changing the product name automatically resets the product description to the default value NA.
Additional default value options are available for specific input types:
Person - Use a user's name or email address as the default value.
Single Select - Select a default value from the configured list of options.
Check Box - Configure default values such as True/False, 1/0, Yes/No, or any custom text by selecting Checked or Unchecked values.
Formula
Use Formula to calculate default values dynamically by using formulas.
Powertable sheet supports formulas and functions for generating default values. These values are automatically recalculated based on the underlying reference data.
Formula-based default values are supported for the following input types:
Number
Decimal
Text
Date Time
Person
Email
Recalculate data on update
Enable Recalculate data on update to have the column automatically reset to its calculated default value whenever the record is updated.
When this option is enabled:
Existing values remain unchanged until the record is updated.
When you modify another field in the same record, the value is reset to the formula-derived default.
In this example, changing the product size calculates the default value and resets the product price to it.
Last updated
Was this helpful?