Pigment is a structured modeling platform. To guarantee accurate user data entry and consistent calculations, Pigment requires you to specify a data type for each input.
List of data types
Available data types for Metrics and List Properties include:
Type | Description | Example |
Number | Allows you to input numerical values with decimals. |
|
Integer | Allows you to input numerical values without decimals. This format is useful when you want to ensure that Members input only non-decimal values. |
|
Date | Limits input to dates only. The Member is asked to select a date. |
|
Text | Allows you to input text, symbols and even emojis in cells. |
|
Dimension | Allows Members to select an Item from a Dimension list. This data type is key when it comes to grouping, allocating, and mapping data. |
|
Boolean | Supports TRUE or FALSE values. It is displayed as a checkbox in the grid. There are three Boolean states: TRUE, FALSE, and BLANK. Blank and FALSE values may appear similar, but FALSE values feature an outlined checkbox. BLANK values are entirely grayed out. | ☑️ |
Access Rights | Allows you to give read/write rights to Members. This data type is useful when you manage access rights within your Application. | - |
Permissions | Allows you to adjust Board permissions for Members in your Application. |
|
How do the different data types work together? Below is a list of the data type compatibility in Pigment:
Number and Integer are compatible without specific functions.
If you enter a decimal where data type is listed as Integer, it is automatically truncated.
Number and Integer can be used in the formula of a Text object without any functions, though the TEXT function can also be used.
Boolean can be used in the Text object. It returns the words TRUE or FALSE.
To convert Text to Number or Integer, you need to use the VALUE function.
To convert Text to Date, use the DATE function.