Information about data types is necessary to understand the rules by which data is stored, displayed, and processed.
When working with data in scripts, consider the internal representation of data.
Number
A floating-point number. For readability, number digits are separated by a space, and the fractional part is separated by a comma. When editing a number value in the table, it will be presented in internal format, without separators and with a dot between the fractional part.
External representation: 1 234,56.
Internal representation: 1234.56.
String
A string has a limit of 2,000 characters.
Percent
External representation: 45.
Internal representation: 0.45.
Displayed and edited in the table in external representation. When working with formulas, remember that the internal representation will be used there.
If used in the context of numbers, it will be represented as 1 and 0.
Date
Displayed in human-readable format, but can be stored in two formats. As a date in ISO format or as a unix-time number in milliseconds.
When working with dates in the context of numbers, they will be represented as a unix-time number in milliseconds.
Dates are saved in the UTC+0 time zone. And displayed in the user's local time zone or another selected time zone for the column.
Regardless of what hour is specified in the internal date format, when reading and processing data, dates are always reset to the beginning of the day in the selected time zone!
This data type is similar to Date in all characteristics, except for resetting the time to the beginning of the day. This data type shows the time in its original state.
Days
Number of days. Can be used in combination with formulas and calculations between dates.
External representation: Number of days.
Internal representation: Number from milliseconds count.
In the table, reading and editing occurs in external format.