Creating and Editing Tables

Overview

A Table is a content type for managing structured data in a database-like format. You can use it for task management, reading logs, customer records, and any information that can be organized into rows and columns.

---

Creating a Table

Creating a table in Memoreru is a 3-step process.

Getting Started: Open the Table Creation Screen

1. Tap the create button (+) at the bottom-right of the screen
2. Select "Table"

Step 1: Table Design

Design your table's structure and data. This step has two tabs.

Tab 1: Column Design (Defining Columns)

Define the columns of your table. This determines the table's structure.

How to Define Columns

Method 1: Define manually

For each column, configure the following:

• Column name: The name of the column (e.g., "Book Title," "Author," "Rating")
• Data type: Choose from 30 types (details below)
• Required / Optional: Whether this column must be filled in
• Default value: Set an initial value (optional)

Method 2: AI-assisted design

The AI Table Designer lets you describe your table in plain language and automatically generates an optimal structure.

How to use it:

1. On the table creation screen, select "AI-assisted design"
2. Enter a description of your table (e.g., "I want to create a table for managing my reading list")
3. Select an industry or use case (optional)
4. Enter additional context (optional)
5. Click the "Design Table with AI" button

What the AI suggests:

• Column names and data types
• Required / Optional settings
• Default values
• Options for select-type columns
• Best practice recommendations for table design

Advantages:

• Saves time on table design
• Optimal data type selection
• Industry-standard structures

Limitations:

• Not 100% accurate (review and adjust as needed)
• May not handle very complex requirements

Tips:

• The more specific your description, the better the results
• You can edit and adjust the generated design
• Industry presets improve accuracy

Example:

Main Data Types

For all 30 data types, see Data Types and How to Use Them.

Adding, Editing, and Deleting Columns

• Add: Click the "+ Add Column" button
• Edit: Click the pencil icon next to the column name
• Delete: Click the trash icon next to the column name
• Reorder: Drag and drop columns to rearrange them

Example: Column definitions for a Reading List

Tab 2: Data Entry (Initial Data)

You can enter initial data when creating the table.

• You can skip this: Add data later if you prefer
• Add rows: Click "+ Add Row" to create new rows
• Enter data: Click each cell to input values

Example: Initial data for a Reading List

Step 2: Basic Information

Set the basic information for your table.

Required Fields

• Title: The name of the table (e.g., "Reading List 2025")
• Visibility: Choose from PRIVATE / TEAM / PUBLIC (set in the next step)

Optional Fields

• Description: A summary of the table (displayed in search results and content cards)
• Category: Select a category to classify the table
• Parent folder: Choose a folder to place the table in

Example:

Step 3: Set Visibility

Choose the visibility level for your table.

• PRIVATE: Only you can view and edit it
• TEAM: Team members can view and edit it
• PUBLIC: Anyone can view it (only the creator can edit)

Once you are done, click the "Create" button to save your table.

---

Viewing a Table

Table View

Your created table is displayed in a spreadsheet-like format.

Screen layout:

Column Operations

Click a column header to access the following options:

• Sort: Sort ascending or descending
• Filter: Narrow down data by specific conditions
• Hide: Temporarily hide the column
• Column settings: Edit or delete the column

Row Operations

Each row has a set of operation buttons on the right side of the table. From left to right, the buttons are Add, Duplicate, Edit, History, and Delete. Delete is the only button with a color accent; the other buttons are shown in a subdued gray.

• Add: Add a row
• Duplicate: Duplicate the row
• Edit (pencil): Open the row editing screen in a new tab. A normal click opens it in a new tab, and you can also use the browser's "Open link in new tab"
• History: View the row's change history
• Delete: Remove the row

---

Editing a Table

Adding Data

Adding new rows

1. Click the "+ New Row" button at the top of the table
2. An empty row is added
3. Click each cell to enter data

Importing data

You can bulk import data from a CSV file. Select "CSV Import" from the menu in the upper right of the table screen and upload your file.

Editing Data

Inline editing

1. Click the cell you want to edit
2. Enter or change the value
3. Press Enter or click another cell to save

Editing in the row editing screen

1. Click Edit (pencil) in the operation buttons on the right side of the row
2. The row editing screen opens in a new tab
3. Edit each field
4. Click the "Save" button

Deleting Data

Deleting a single row

1. Click Delete in the operation buttons on the right side of the row you want to delete
2. Click "Delete" in the confirmation dialog

Bulk deleting rows

1. Select the checkboxes at the left end of the rows you want to delete
2. Click the "Delete" button at the top of the table
3. Click "Delete" in the confirmation dialog

Adding, Editing, and Deleting Columns

Adding a column

1. Open the table edit screen (click the "Edit" button in the upper right)
2. Click the "+ Add Column" button
3. Set the column name and data type
4. Click "Save"

Editing a column

1. Open the table edit screen
2. Click the pencil icon next to the column you want to edit
3. Change the column name or data type
4. Click "Save"

Deleting a column

1. Open the table edit screen
2. Click the trash icon next to the column you want to delete
3. Click "Delete" in the confirmation dialog

Warning: Deleting a column permanently removes all data in that column.

---

Practical Examples

Example 1: Task Management

Example 2: Reading List

Example 3: Customer Management

---

Tips and Tricks

1. Start with Only the Columns You Need

Define just the essential columns at first and add more as needed.

2. Choose the Right Data Type

• Use the date type for dates (ensures accurate sorting and filtering)
• Use the select type when there is a fixed set of choices
• Use the rating type for ratings (visually intuitive)

3. Use Views to Focus on What Matters

For large tables, use the View feature to extract only the data you need.

Example:

4. Visualize Progress with Graphs

Turning your table data into graphs makes progress easy to see at a glance.

Example:

---

FAQ

Q1: What is the maximum number of rows?

A: It depends on your plan.

• Free: 1,000 rows
• Light: 10,000 rows
• Standard: 30,000 rows
• Business: 100,000 rows

Q2: What is the maximum number of columns?

A: It depends on your plan.

• Free: 30 columns
• Light: 100 columns
• Standard: 300 columns
• Business: 1,000 columns

Q3: Can I export a table?

A: Yes, CSV export is available. Select "CSV Export" from the menu in the upper right of the table screen.

Q4: Can I import data from other tools?

A: Yes, CSV import is available. Select "CSV Import" from the menu in the upper right of the table screen and upload your file.