General
Last updated
Last updated
In this category, you can define the following properties:
Constraints and
Specify the input data type to be allowed in each column using this dropdown.
PowerTable allows the following data types as inputs:
Number
Decimal
Text
Date Time
Date
Single Select
Check Box
Image
Person
URL
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 next sections.
This section provides options for limiting input values and configuring field validation.
Here you can specify the minimum and maximum values that can be entered into the columns. Any values outside of this range are not permitted. These limits can be applied to the input types: Number, Decimal, Date Time, and Date.
Consider the example below, where the minimum and maximum values are set for the Product Cost column.
The existing values remain unchanged. However, if a user enters a value that falls outside the specified range, they will be notified of the minimum and maximum limits.
Note: You can also set only one of these limits (minimum or maximum) and not both.
For the 'Date' and 'Date Time' input types, users may choose a date range or both date and time range. Any date or time outside of this range will not be accepted.
This option is available for the text input type and allows you to specify which types of inputs can be entered into a column. This way, you can ensure that the data is correct and accurate.
You can allow users to enter any value or only numeric, alphanumeric, non-numeric, email, URL, or regex-matching inputs.
With Regex, you can specify a pattern and allow only matching inputs. In the example below, we have entered the regex pattern against which the user input will be validated.
The entered value is validated against the specified input type configuration. Inputs that do not match the pattern are identified and rejected.
PowerTable lets you configure default values for the columns. When a new row is added, the specified column is automatically filled with the default value if you have set one.
To set a static value, select Manual and enter the value.
In the example below, we have added 'NA' as the default value for the 'Product Description' column.
Whenever a new row is added, this column value is automatically populated with 'NA' by default, which can be modified later.
Checking the 'Reset to default on update' option not only sets the default value for the column but also disables the column from editing. The existing values are retained, but they are automatically changed to the default value only when users edit other values in the specific record.
Find below an example where the existing value changes to the default value after an update.
For the 'Decimal' input type, you can specify the default number of decimal digits to be allowed.
For the 'Person' input type, you can either use their name or email address as default.
For the 'Single-select' type, you can choose the default value from the list of options you have configured.
For the 'Check Box' type, the default values are automatically configured with the Boolean values: true and false. You can change these to 1 and 0 or yes and no, etc., if necessary.
You can set derived values as defaults instead of using static values. These derived values are calculated using configurable formulas.
PowerTable provides many Excel-like formulas and functions to help you perform these calculations. These values change dynamically as the underlying reference data changes.
Derived values can be set for the field types - Number, Decimal, Text, Date, Date Time, Person, and Email.
Checking the 'Recalculate data on update' option sets the calculated value as default for newly inserted rows and also disables the column from editing. The existing values are retained, and they are automatically changed to the derived value only when users edit other values in the specific record.
We have discussed setting the type, constraints, and defaults for table data. In the next section, we will explore how to select and look up values from a table or visual for a single-select field type.
