Table Features Overview

Overview

Memoreru's Table feature is a powerful database management system that goes far beyond a simple spreadsheet. By combining 30 data types, views, graphs, and dashboards, you can efficiently manage any kind of information.

Key Features

1. Rich Data Types (30 Types)

While typical spreadsheet tools only offer a handful of data types like text, numbers, and dates, Memoreru supports 30 different data types.

Main data types:

Basic: string, markdown, rich_text, number, date, datetime
Selection: select, multi_select, radio
Rating: rating, progress, checkbox
Media: image, audio, video, file
Link: url, location
Advanced: formula, rollup, auto_number
Organization: user_select, team_select, dept_select
Special: qr_code, drawing, button, sub_table, embed

For details, see Data Types.

2. Flexible Data Management

Free-form Row and Column Editing

Add, edit, and delete columns: Modify table structure anytime
Add, edit, and delete rows: Easily add, update, or remove data
Cell-level editing: Edit each cell individually

Sorting, Filtering, and Search

Sort: Sort by multiple columns
Filter: Narrow down data with advanced conditions
Search: Find data using full-text search

For details, see Sorting, Filtering, and Search.

3. Views for Data Extraction

Views let you look at your data from multiple perspectives within a single table.

Example: Task Management Table

Original table: All tasks (200 items)

View 1: Incomplete tasks (50 items)
  -> Status = "Not Started" OR "In Progress"

View 2: Due this week (15 items)
  -> Due Date >= This Monday AND Due Date <= This Sunday

View 3: High-priority tasks (20 items)
  -> Priority = "High"

For details, see Views for Data Extraction.

4. Graphs for Data Visualization

Visualize your table data with various chart types.

Supported graph types:

Bar chart: Compare values across categories
Line chart: Track trends over time
Pie chart: Show proportions of a whole
Area chart: Visualize trends as filled areas over time
Scatter plot: Show correlation between two variables
Combo chart: Combine bar and line charts in a single graph

Example: Task Management Visualization

Graph 1: Tasks by status (pie chart)
Graph 2: Weekly task completion trend (line chart)
Graph 3: Tasks by assignee (bar chart)

5. Dashboards for Integrated Display

Combine multiple views and graphs into a single screen.

Example: Project Dashboard

+-------------------+-------------------+
| Completion Rate   | Weekly Progress   |
| (Pie Chart)       | (Line Chart)      |
+-------------------+-------------------+
| Incomplete Task List                  |
| (View)                                |
+-------------------+-------------------+
| By Assignee       | By Priority       |
| (Bar Chart)       | (Pie Chart)       |
+-------------------+-------------------+

Table Structure

Basic Table Structure

Table
+-- Column definitions
|   +-- Column 1: Name, Data Type, Options
|   +-- Column 2: ...
|   +-- Column 3: ...
+-- Data (Rows)
    +-- Row 1: Data for each column
    +-- Row 2: ...
    +-- Row 3: ...

Column Components

Each column consists of the following elements:

Column name: The name of the column (e.g., "Task Name", "Due Date")
Data type: The kind of data it stores (text, date, select, etc.)
Required/Optional: Whether input is mandatory for this column
Default value: An initial value (optional)
Options: Additional settings specific to each data type

Use Cases

Example 1: Task Management

Table name: Task Management

Column structure:
- Task Name (string, required)
- Description (rich_text)
- Status (select: Not Started / In Progress / Done / On Hold)
- Priority (select: High / Medium / Low)
- Assignee (user_select)
- Due Date (date)
- Completion Date (date)
- Progress (progress)

Usage:
- Views: Incomplete tasks, Due this week
- Graphs: Tasks by status, Completion rate by assignee
- Dashboard: Overall project progress

Example 2: Customer Management (CRM)

Table name: Customer Management

Column structure:
- Company Name (string, required)
- Contact Person (string, required)
- Email Address (string)
- Phone Number (string)
- Customer Status (select: Lead / In Negotiation / Contracted / Lost)
- Contract Plan (select: Free / Standard / Business)
- Monthly Contract Amount (number)
- Contract Start Date (date)
- Next Follow-up Date (date)
- Sales Rep (user_select)
- Notes (rich_text)

Usage:
- Views: Customers in negotiation, Follow-up schedule
- Graphs: Customers by status, Monthly revenue trend
- Dashboard: Sales activity summary

Example 3: Inventory Management

Table name: Inventory Management

Column structure:
- Product Name (string, required)
- Product Code (string, required)
- Category (select)
- Stock Quantity (number)
- Unit Price (number)
- Stock Value (formula: Stock Quantity x Unit Price)
- Supplier (dept_select)
- Last Received Date (date)
- Product Image (image)
- Notes (rich_text)

Usage:
- Views: Out-of-stock items, Items needing reorder
- Graphs: Stock value by category, Receiving trend
- Dashboard: Inventory status summary

Example 4: Reading List

Table name: Reading List

Column structure:
- Book Title (string, required)
- Author (string, required)
- Rating (rating)
- Date Finished (date)
- Page Count (number)
- Genre (select: Fiction / Business / Technical / Other)
- Recommendation Score (number, 1-10)
- Cover Image (image)
- Notes (markdown)
- Purchase Link (url)
- Reading Status (select: Unread / Reading / Finished)

Usage:
- Views: Want-to-read list, Finished books list
- Graphs: Books read by genre, Monthly reading count trend
- Dashboard: Reading record summary

Comparison with Other Tools

vs. Spreadsheets (Excel / Google Sheets)

Feature	Spreadsheets	Memoreru Tables
Data types	3-5 types	30 types
Views	None	Yes (saved filters)
Graphs	Manual creation	Auto-generated
Dashboards	None	Yes
Visibility settings	Limited	Flexible (3 levels)
AI assistance	None	Yes (table design)

vs. Databases (Airtable / Notion Database)

Feature	Airtable	Memoreru Tables
Data types	~20 types	30 types
Japanese support	Partial	Full support
Views	Yes	Yes
Graphs	Yes (paid)	Yes
Dashboards	Yes (paid)	Yes
AI assistance	None	Yes
Visibility settings	Limited	Flexible (3 levels)

Plan-based Limits

Table features have the following limits based on your plan:

Plan	Tables	Rows / Table	Columns / Table
Free	30	1,000	30
Light	100	10,000	100
Standard	300	30,000	300
Business	1,000	100,000	1,000