Formatting
Introduction
When working with data, you might encounter various types of information such as dates, times, and numbers. To make this data more user-friendly and readable, we offer a range of formatting tools. Below, we will detail these formatting features:
Number Formatting
When dealing with numeric data, sometimes you want to present it in a specific way. Teable provides the following number of formatting options:
Decimals: You can choose the number of decimal places to display, ranging from 0 to 5.
Percentage: Converts numbers into a percentage form. For example, 0.25 is displayed as 25%.
Currency: You can add a currency symbol, such as "$", and choose the number of decimal places.
Date and Time Formatting
In Teable, you can choose from various display options for dates and times:
Date Format: Depending 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
International 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 Format: Teable offers several time formats:
24-hour format: e.g., 23:59
12-hour format (including AM/PM): e.g., 11:59 PM
Hide time
Time Zone Selection: You can choose the appropriate time zone based on your location to ensure accurate timing.
These formatting options ensure you can select the most suitable way to display dates and times according to your preferences and needs.
Field Basic Data Type List
Single Line Text
Text
No
No
Long Text
Text
No
No
User
Text
No
No
Attachment
Text
No
No
Checkbox
Boolean
No
No
Multi-Select
Text
No
No
Single Select
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
Creation Time
Date
Yes
No
Last Modified Time
Date
Yes
No
Creator
Text
No
No
Last Modifier
Text
No
No
Auto Number
Number
Yes
No
Button
Text
No
No
The Rating field is displayed as an interactive score bar, represented by a series of icons that can be highlighted, not subject to number formatting but considered a numeric type for calculations.
The formatting for Formula and Rollup fields depends on their output type, meaning if the result is a date or number, they can be formatted. If the result is text or a boolean value, formatting does not apply.
All fields can be referenced, and once referenced, they still adhere to the basic value type of the field.
Conclusion
Whether you are dealing with dates, times, or numbers, formatting features can make your data more user-friendly and clear. With simple settings, you can easily present your data as expected.
Last updated