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	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

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://...)

Editing: Clicking a markdown cell opens a dedicated editing dialog.

On PC: The screen splits left and right — the input area on the left, a live preview of what you've written on the right
On mobile: Since screen space is limited, you switch between "Input" and "Preview" tabs to edit

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.

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

yearmonth (Year-Month)

Description: Stores only the year and month (no day).

Use cases:

Join month, departure month
Contract renewal month
Budget tracking month

Features: Selectable via a calendar UI (year and month only).

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
|   +-- 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]

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.

Data Types

Overview

Data Type Availability by Plan

Data Type List

Data Type Details

1. Basic Text Types

string (Text)

markdown (Markdown)

rich_text (Rich Text)

url (URL)

2. Numeric Types

number (Number)

rating (Rating)

progress (Progress)

formula (Formula)

auto_number (Auto Number) [Paid]

3. Selection Types

select (Dropdown)

radio (Radio Button)

multi_select (Multi-select)

4. Date & Time Types

date (Date)

datetime (Date & Time)

yearmonth (Year-Month)

5. Media Types

image (Image)

audio (Audio)

video (Video)

file (File Attachment) [Paid]

6. Boolean Type

checkbox (Checkbox)

7. Location

location (Location)

8. Organization Types [Paid]

user_select (User Select)

team_select (Team Select)

dept_select (Department Select)

9. Advanced Types

rollup (Rollup)

sub_table (Sub-table) [Paid]

qr_code (QR Code) [Paid]

drawing (Drawing) [Paid]

embed (Embed) [Paid]

button (Button) [Paid]

Choosing the Right Data Type

Selection Flowchart

Practical Examples

Example 1: Task Management Table

Example 2: Product Management Table

FAQ

Q1: Can I change a data type after creating a column?

Q2: Can I create custom data types?

Q3: I'm not sure which data type to choose.

Q4: What happens when I upgrade to access paid data types?

Comments

Memoreru

Properties