読み込み中...
Memoreru tables support 30 different data types. Choosing the right data type makes data entry easier and ensures accurate sorting, filtering, and aggregation.
| # | Data Type | Description | Plan | Details |
|---|---|---|---|---|
| Basic Input | ||||
| 1 | string | Text | Free | Short text (names, titles, etc.) |
| 2 | number | Number | Free | Numbers, currency, percentages |
| 3 | checkbox | Checkbox | Free | On/Off toggle |
| Selection | ||||
| 4 | select | Dropdown | Free | Single selection |
| 5 | radio | Radio Button | Free | Radio button format |
| 6 | multi_select | Multi-select | Free | Multiple selections |
| Date & Time | ||||
| 7 | date | Date | Free | Year/Month/Day |
| 8 | datetime | Date & Time | Free | Date + Time |
| 9 | yearmonth | Year-Month | Free | Year and month only |
| Text & Link | ||||
| 10 | markdown | Markdown | Free | Long-form text with Markdown syntax |
| 11 | rich_text | Rich Text | Free | WYSIWYG editor |
| 12 | url | URL | Free | Links (with OGP support) |
| Calculation & Rating | ||||
| 13 | formula | Formula | Free | Auto-calculation using formulas |
| 14 | rating | Rating | Free | Star rating |
| 15 | progress | Progress | Free | Progress bar |
| Reference & Media | ||||
| 16 | rollup | Rollup | Free | Aggregate related data |
| 17 | location | Location | Free | Address, GPS coordinates |
| 18 | image | Image | Free | Image files |
| 19 | audio | Audio | Free | Audio files |
| 20 | video | Video | Free | Video files |
| Business (Paid) | ||||
| 21 | file | File Attachment | Paid | PDF, Excel, etc. |
| 22 | user_select | User Select | Paid | Select assignees |
| 23 | team_select | Team Select | Paid | Select teams |
| 24 | dept_select | Department Select | Paid | Select organizations/companies |
| 25 | sub_table | Sub-table | Paid | Detail rows (invoice line items, etc.) |
| 26 | embed | Embed | Paid | YouTube, Maps, etc. |
| 27 | qr_code | QR Code | Paid | QR code generation |
| 28 | auto_number | Auto Number | Paid | Automatic sequential numbering |
| 29 | drawing | Drawing | Paid | Freehand drawings |
| 30 | button | Button | Paid | Action buttons |
Handle everything from short text to long-form content.
Description: Stores short text strings.
Use cases:
Examples:
Task Name: Implement login feature
Product Code: ABC-001
Contact Name: John Smith
Limit: Up to 1,000 characters (configurable per column)
Description: Stores long-form text using Markdown syntax.
Use cases:
Examples:
## Overview
Implement the login feature.
## Requirements
- Login with email and password
- Maintain login state
## References
[Auth Design Doc](https://...)Editing: Clicking a markdown cell opens a dedicated editing dialog.
Limit: Up to 100,000 characters
Description: Create formatted text using a WYSIWYG editor.
Use cases:
Description: Stores URLs (web addresses).
Use cases:
Examples:
Reference: https://example.com/docs
GitHub: https://github.com/user/repo
Features: Clicking opens the link in a new tab. Supports OGP (link preview).
Handle numeric data for calculations and aggregation.
Description: Stores integers or decimals.
Use cases:
Examples:
Price: 1000
Stock: 50
Score: 85.5
Features: Supports sorting and aggregation (sum, average, etc.).
Description: Stores star ratings.
Use cases:
Display: Shown as star icons (1-5 scale)
Description: Stores a progress percentage from 0 to 100%.
Use cases:
Display: Visually shown as a progress bar
Description: Automatically calculates values using other columns in the same row.
Use cases:
Examples:
Unit Price: $10
Quantity: 5
Total (formula): Unit Price x Quantity = $50
Formula examples:
unit_price * quantity - Multiplication(revenue - cost) / revenue * 100 - Profit margin (%)unit_price * quantity * (1 + tax_rate) - Tax-inclusive amountDescription: Automatically assigns a sequential number to each row.
Use cases:
Features: Not editable. Numbers are not reused when rows are deleted.
Choose from predefined options.
Description: Select one option from multiple choices.
Use cases:
Examples:
Status: Choose one from [Not Started, In Progress, Done, On Hold]
Priority: Choose one from [High, Medium, Low]
Features: Each option can have a custom color.
Description: Same as select, but displayed as radio buttons.
Use cases:
Description: Select multiple options from a list.
Use cases:
Examples:
Tags: Select multiple from [Important, Urgent, Needs Review]
Skills: Select multiple from [JavaScript, React, TypeScript]
Handle dates and times.
Description: Stores a date (year/month/day).
Use cases:
Features: Selectable via calendar UI. Sorts accurately.
Description: Stores both date and time.
Use cases:
Description: Stores only the year and month (no day).
Use cases:
Features: Selectable via a calendar UI (year and month only).
Handle images, audio, video, and files.
Description: Stores image files.
Supported formats: JPG, PNG, GIF, WebP
Features: Thumbnail display. Click to enlarge.
Description: Stores audio files.
Supported formats: MP3, WAV, OGG
Description: Stores video files.
Supported formats: MP4, WebM, MOV
Description: Stores any type of file.
Supported formats: PDF, DOCX, XLSX, ZIP, etc.
Description: Stores a checkbox (on/off) value.
Use cases:
Features: Easily filter to show "checked only" items.
Description: Stores address and location information.
Use cases:
Features: Map display supported (using Leaflet).
Description: Select users.
Use cases:
Features: Select from user list. Multiple selection supported.
Description: Select teams.
Use cases:
Description: Select organizations, companies, or groups.
Use cases:
Description: Aggregates data from another table or other rows.
Use cases:
Examples:
[Parent table: Projects]
- Task Count (rollup): 15 <- Count rows from the Tasks table
- Total Hours (rollup): 120 hours <- Sum hours from Tasks
Aggregation functions:
Difference from formula:
Description: A small table embedded within a record.
Use cases:
Examples:
Order ID: 001
Product List (sub_table):
- Product A x 2 = $20.00
- Product B x 1 = $15.00
Total: $35.00
Description: Automatically generates a QR code from text.
Use cases:
Description: Stores freehand drawings and sketches.
Use cases:
Description: Embeds external content.
Use cases:
Description: Places custom action buttons.
Use cases:
What are you storing?
+-- Short text -> string
+-- Long text -> markdown or rich_text
+-- Numbers
| +-- General numbers -> number
| +-- Ratings -> rating
| +-- Progress percentage -> progress
| +-- Auto-incrementing -> auto_number [Paid]
| +-- Calculated result -> formula
+-- Choose from options
| +-- Single selection -> select or radio
| +-- Multiple selections -> multi_select
+-- Date & Time
| +-- Date only -> date
| +-- Date + Time -> datetime
| +-- Year and month only -> yearmonth
+-- Files
| +-- Images -> image
| +-- Audio -> audio
| +-- Video -> video
| +-- Other files -> file [Paid]
+-- On/Off toggle -> checkbox
+-- Users/Teams -> user_select, team_select, dept_select [Paid]
+-- Other
+-- URLs -> url
+-- Addresses -> location
+-- Aggregation -> rollup
+-- QR codes -> qr_code [Paid]
Column structure:
1. ID (auto_number) - Auto-incrementing [Paid]
2. Task Name (string) - Short text
3. Description (markdown) - Long text
4. Status (select) - Single selection
5. Priority (select) - Single selection
6. Assignee (user_select) - User selection [Paid]
7. Due Date (date) - Date
8. Done (checkbox) - Checkbox
9. Progress (progress) - Progress bar
10. Tags (multi_select) - Multiple selections
Column structure:
1. Product Code (string) - Short text
2. Product Name (string) - Short text
3. Price (number) - Number
4. Stock (number) - Number
5. Stock Value (formula) - Formula (Price x Stock)
6. Category (select) - Single selection
7. Published (checkbox) - Checkbox
8. Product Image (image) - Image
9. Description (markdown) - Long text
10. Product URL (url) - Link
11. QR Code (qr_code) - QR code [Paid]
A: Yes, you can change it. However, converting to an incompatible data type may result in data loss.
A: Custom data types are not currently supported. Please choose from the 30 standard data types.
A: When in doubt, start with the string type. You can always change it to a more appropriate type later.
A: Upgrading to the Standard plan or above unlocks 10 additional types: file, user_select, team_select, dept_select, sub_table, embed, qr_code, auto_number, drawing, and button.
コメント
まだコメントがありません
最初のコメントを投稿してみましょう