Formatting
Teable provides various formatting options, including number formatting, date/time formatting, and text formatting, to ensure data is displayed appropriately in different contexts.
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 Type | Basic Data Type | Supports Formatting | Dynamic Type Flag |
|---|---|---|---|
| SingleLineText | Text | No | No |
| LongText | Text | No | No |
| User | Text | No | No |
| Attachment | Text | No | No |
| Checkbox | Boolean | No | No |
| MultipleSelect | Text | No | No |
| SingleSelect | Text | No | No |
| Date | Date | Yes | No |
| Number | Number | Yes | No |
| Duration | Number | Yes | No |
| Rating | Number | No* | No |
| Formula* | Dynamic | Yes* | Yes |
| Rollup* | Dynamic | Yes* | Yes |
| Count | Number | Yes | No |
| Link | Text | No | No |
| CreatedTime | Date | Yes | No |
| LastModifiedTime | Date | Yes | No |
| CreatedBy | Text | No | No |
| LastModifiedBy | Text | No | No |
| AutoNumber | Number | Yes | No |
| Button | Text | No | No |
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.