📝 Overview
In Yoom, columns in a database have a specific data format, known as Data Types.
🔍 Specifications
Data Type | Description | Notes |
Text | A single line of text. | Max: 255 characters. Treated as a string in other applications. |
Long Text | Supports multiple lines of text. | Max: 65,535 characters. Line breaks can be inserted with Shift+Enter. |
Numeric | Allows only numbers. | Commas are automatically inserted every three digits. |
Dropdown | Select a value from predefined options. | Values are color-coded automatically (6 types). |
Date | Enter a date in yyyy-mm-dd format. | The format cannot be changed here but can be modified in Flowbot. |
Date Time | Enter a date and time in yyyy-mm-dd hh:mm format. | The format cannot be changed here but can be modified in Flowbot. |
Single Checkbox | Displayed as a checkbox. | When retrieving data: ✔️ Checked: true Not checked: false |
File | Attach files that can be downloaded. | Max: 5 files per record. Storage capacity: depends on the plan |
Image | Display Images with the option to enlarge or delete. | Max: 5 files per record. Storage capacity: depends on the plan |
Function | Perform calculations between columns within the same record. | Only functions available in the formula editor can be used. Data synchronized from other Yoom tables via Data Connect cannot be used in functions. |
URL | Display entered URLs as clickable links. | Must be in |
User | Assign any user registered in the same workspace. |
|
Creation Date and Time | Automatically record when the record was created. | Cannot be manually added or updated when operating the database.
|
Update Date and Time | Automatically record when the record was last updated. | Cannot be manually added or updated when managing the database. |
📚 Related Guides
Files and Image Attachment Feature in Yoom Database - View Guide
Search Keywords
Search Keywords
Data Type, Data Format, Column, Manage Database, Database, functionality