​
Number Formatting

When working with numerical data, we sometimes want to display it in specific ways. Teable offers the following number formatting options:
  • Decimals: You can choose how many decimal places to display, ranging from 0 to 5.
  • Percentage: Convert numbers to percentage format. For example, 0.25 will be displayed as 25%.
  • Currency: You can add currency symbols like ”$” to numbers and select the number of decimal places.

​
Date and Time Formatting

In Teable, you can choose from various date and time display formats:
  • Date Formats: Based on your preference, you can select from the following date formats:
    • US Style: e.g., 12/31/2023
    • European Style: e.g., 31/12/2023
    • Asian Style: e.g., 2023/12/31
    • ISO Standard: e.g., 2023-12-31
    • Year-Month Only: e.g., 2023-12
    • Month-Day Only: e.g., 12-31
    • Year Only: e.g., 2023
    • Month Only: e.g., 12
    • Day Only: e.g., 31
  • Time Formats: Teable provides multiple time format options:
    • 24-hour format: e.g., 23:59
    • 12-hour format (with AM/PM): e.g., 11:59 PM
    • No time display
  • Timezone Selection: You can choose the appropriate timezone based on your location to ensure accurate time representation.
These formatting options ensure you can select the most suitable date and time display format according to your preferences and requirements.

​
Field Basic Data Type List

Teable Field TypeBasic Data TypeSupports FormattingDynamic Type Flag
SingleLineTextTextNoNo
LongTextTextNoNo
UserTextNoNo
AttachmentTextNoNo
CheckboxBooleanNoNo
MultipleSelectTextNoNo
SingleSelectTextNoNo
DateDateYesNo
NumberNumberYesNo
DurationNumberYesNo
RatingNumberNo*No
Formula*DynamicYes*Yes
Rollup*DynamicYes*Yes
CountNumberYesNo
LinkTextNoNo
CreatedTimeDateYesNo
LastModifiedTimeDateYesNo
CreatedByTextNoNo
LastModifiedByTextNoNo
AutoNumberNumberYesNo
ButtonTextNoNo
Rating fields are displayed as interactive rating bars represented by a series of icons that can be illuminated. While they can’t participate in number formatting, they are inherently numeric and can be used in numerical calculations. Formula and Rollup field formatting depends on their output type. This means if a formula or rollup results in a date or number type, it can be formatted. If the result is text or boolean, formatting is not applicable. All fields can be referenced, and when referenced, they maintain their basic value type.