Data Types
Overview
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 Availability by Plan
- Free / Light plans: 20 basic data types available
- Standard / Business plans: All 30 data types available
Data Type List
| # | 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 | time | Time | Free | Time 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 |
Data Type Details
1. Basic Text Types
Handle everything from short text to long-form content.
string (Text)
Description: Stores short text strings.
Use cases:
- Names, titles
- IDs, codes
- Short notes
Examples:
Task Name: Implement login feature
Product Code: ABC-001
Contact Name: John Smith
Limit: Up to 1,000 characters (configurable per column)
markdown (Markdown)
Description: Stores long-form text using Markdown syntax.
Use cases:
- Detailed notes
- Descriptions
- Documentation
Examples:
## Overview
Implement the login feature.
## Requirements
- Login with email and password
- Maintain login state
## References
[Auth Design Doc](https://...)Limit: Up to 100,000 characters
rich_text (Rich Text)
Description: Create formatted text using a WYSIWYG editor.
Use cases:
- Rich descriptions
- Formatted notes
url (URL)
Description: Stores URLs (web addresses).
Use cases:
- Website links
- Reference URLs
- Document links
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).
2. Numeric Types
Handle numeric data for calculations and aggregation.
number (Number)
Description: Stores integers or decimals.
Use cases:
- Amounts, prices
- Quantities, stock counts
- Scores, points
Examples:
Price: 1000
Stock: 50
Score: 85.5
Features: Supports sorting and aggregation (sum, average, etc.).
rating (Rating)
Description: Stores star ratings.
Use cases:
- Evaluations, ratings
- Satisfaction scores
- Recommendation levels
Display: Shown as star icons (1-5 scale)
progress (Progress)
Description: Stores a progress percentage from 0 to 100%.
Use cases:
- Task progress
- Completion rate
- Achievement level
Display: Visually shown as a progress bar
formula (Formula)
Description: Automatically calculates values using other columns in the same row.
Use cases:
- Total amount calculations
- Profit margin calculations
- Complex formulas
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 amount
auto_number (Auto Number) [Paid]
Description: Automatically assigns a sequential number to each row.
Use cases:
- Sequential IDs
- Management numbers
- Sequence numbers
Features: Not editable. Numbers are not reused when rows are deleted.
3. Selection Types
Choose from predefined options.
select (Dropdown)
Description: Select one option from multiple choices.
Use cases:
- Status
- Category
- Priority
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.
radio (Radio Button)
Description: Same as select, but displayed as radio buttons.
Use cases:
- Yes/No choices
- When there are few options
multi_select (Multi-select)
Description: Select multiple options from a list.
Use cases:
- Tags
- Skills
- Multiple categories
Examples:
Tags: Select multiple from [Important, Urgent, Needs Review]
Skills: Select multiple from [JavaScript, React, TypeScript]
4. Date & Time Types
Handle dates and times.
date (Date)
Description: Stores a date (year/month/day).
Use cases:
- Deadlines, due dates
- Start dates, end dates
- Birthdays
Features: Selectable via calendar UI. Sorts accurately.
datetime (Date & Time)
Description: Stores both date and time.
Use cases:
- Event date/time
- Appointment times
- Timestamps
time (Time)
Description: Stores time only.
Use cases:
- Business hours
- Start time, end time
5. Media Types
Handle images, audio, video, and files.
image (Image)
Description: Stores image files.
Supported formats: JPG, PNG, GIF, WebP
Features: Thumbnail display. Click to enlarge.
audio (Audio)
Description: Stores audio files.
Supported formats: MP3, WAV, OGG
video (Video)
Description: Stores video files.
Supported formats: MP4, WebM, MOV
file (File Attachment) [Paid]
Description: Stores any type of file.
Supported formats: PDF, DOCX, XLSX, ZIP, etc.
6. Boolean Type
checkbox (Checkbox)
Description: Stores a checkbox (on/off) value.
Use cases:
- Done/Not done
- Enabled/Disabled
- Published/Unpublished
Features: Easily filter to show "checked only" items.
7. Location
location (Location)
Description: Stores address and location information.
Use cases:
- Addresses
- Store locations
- Event venues
Features: Map display supported (using Leaflet).
8. Organization Types [Paid]
user_select (User Select)
Description: Select users.
Use cases:
- Assignees
- Authors
- Reviewers
Features: Select from user list. Multiple selection supported.
team_select (Team Select)
Description: Select teams.
Use cases:
- Assigned team
- Related teams
dept_select (Department Select)
Description: Select organizations, companies, or groups.
Use cases:
- Department/Organization
- Business partners
9. Advanced Types
rollup (Rollup)
Description: Aggregates data from another table or other rows.
Use cases:
- Display totals from child records on a parent record
- Count related records
- Calculate averages from related data
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:
- SUM - Sum of values
- AVG - Average of values
- COUNT - Number of records
- MIN - Minimum value
- MAX - Maximum value
Difference from formula:
- formula: Calculates using columns within the same row
- rollup: Aggregates data from other tables or rows
sub_table (Sub-table) [Paid]
Description: A small table embedded within a record.
Use cases:
- Invoice line items (multiple items in one invoice)
- Product lists (multiple products in one order)
- Detailed task items
Examples:
Order ID: 001
Product List (sub_table):
- Product A x 2 = $20.00
- Product B x 1 = $15.00
Total: $35.00
qr_code (QR Code) [Paid]
Description: Automatically generates a QR code from text.
Use cases:
- QR codes for URLs
- QR codes for product codes
drawing (Drawing) [Paid]
Description: Stores freehand drawings and sketches.
Use cases:
- Simple diagrams
- Handwritten notes
- Signatures
embed (Embed) [Paid]
Description: Embeds external content.
Use cases:
- YouTube videos
- Google Maps
- External widgets
button (Button) [Paid]
Description: Places custom action buttons.
Use cases:
- Trigger workflows
- Call external APIs
- Trigger automated processes
Choosing the Right Data Type
Selection Flowchart
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
| +-- Time only -> time
+-- 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]
Practical Examples
Example 1: Task Management Table
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
Example 2: Product Management Table
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]
FAQ
Q1: Can I change a data type after creating a column?
A: Yes, you can change it. However, converting to an incompatible data type may result in data loss.
Q2: Can I create custom data types?
A: Custom data types are not currently supported. Please choose from the 30 standard data types.
Q3: I'm not sure which data type to choose.
A: When in doubt, start with the string type. You can always change it to a more appropriate type later.
Q4: What happens when I upgrade to access paid data types?
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.
