Memoreru

Creating and Editing Tables

Memoreru
2 か月前
0

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:

Input: "I want to create a table for managing my reading list" → AI suggests the following columns: - Book Title (string, required) - Author (string, required) - Rating (rating) - Date Read (date) - Notes (rich_text) - Genre (select: Fiction, Business, Technical, Essay, Other) - Page Count (number) - Reading Status (select: Unread, Reading, Finished)

Main Data Types

Data TypeDescriptionExample Use
stringShort textNames, titles
rich_textRich textLong notes, descriptions
numberNumeric valuesAmounts, quantities
dateDateDeadlines, birthdays
selectSingle selectionStatus, priority
multi_selectMultiple selectionsTags, categories
ratingStar ratingRatings, satisfaction
checkboxCheckboxDone / Not done
imageImagePhotos, screenshots
fileFilePDFs, documents
urlURLWebsite links

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

1. Book Title (string, required) 2. Author (string, required) 3. Rating (rating) 4. Date Read (date) 5. Notes (rich_text) 6. Genre (select: Fiction, Business, Technical, Other) 7. Recommendation Score (number, 0-10) 8. Cover Image (image)

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

| Book Title | Author | Rating | Date Read | Genre | |------------|--------|--------|-----------|-------| | The Art of Readable Code | Boswell & Foucher | ⭐⭐⭐⭐⭐ | 2025-10-15 | Technical | | How to Win Friends | D. Carnegie | ⭐⭐⭐⭐ | 2025-09-20 | Business |

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:

Title: Reading List 2025 Description: A record and rating of books read in 2025 Category: Reading Parent folder: Personal

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:

┌─────────────────────────────────────────┐ │ Table Name [Edit] [...]│ ├─────────────────────────────────────────┤ │ [Search] [Filter] [Sort] [+ New Row] │ ├──────┬──────┬──────┬──────┬──────┤ │ Title │ Author│ Rating│ Date │ Genre │ ├──────┼──────┼──────┼──────┼──────┤ │ ... │ ... │ ... │ ... │ ... │ └──────┴──────┴──────┴──────┴──────┘

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

Click the menu (...) at the left end of each row for these options:

  • Detail view: Open the row's detail screen
  • Edit: Switch to inline editing mode
  • Duplicate: Copy the row
  • 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 from the detail screen

  1. Select "Detail View" from the row menu (...)
  2. The detail screen opens
  3. Edit each field
  4. Click the "Save" button

Deleting Data

Deleting a single row

  1. Click the menu (...) at the left end of the row you want to delete
  2. Select "Delete"
  3. 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

Table name: Task Management Column definitions: - 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) - Checklist (multi_select) Sample data: | Task Name | Status | Priority | Assignee | Due Date | Progress | |-----------|--------|----------|----------|----------|----------| | Implement login feature | In Progress | High | Tanaka | 2025-11-20 | 70% | | API design | Done | High | Sato | 2025-11-15 | 100% | | Design mockup | Not Started | Medium | Suzuki | 2025-11-25 | 0% |

Example 2: Reading List

Table name: Reading List 2025 Column definitions: - Book Title (string, required) - Author (string, required) - Rating (rating) - Date Read (date) - Page Count (number) - Genre (select: Fiction, Business, Technical, Essay, Other) - Recommendation Score (number, 1-10) - Cover Image (image) - Notes (rich_text) - Purchase Link (url) - Reading Status (select: Unread, Reading, Finished) Sample data: | Book Title | Author | Rating | Date Read | Genre | Score | Status | |------------|--------|--------|-----------|-------|-------|--------| | The Art of Readable Code | Boswell | ⭐⭐⭐⭐⭐ | 2025-10-15 | Technical | 10 | Finished | | How to Win Friends | Carnegie | ⭐⭐⭐⭐ | 2025-09-20 | Business | 9 | Finished | | Clean Architecture | Martin | - | - | Technical | - | Reading |

Example 3: Customer Management

Table name: Customer Management Column definitions: - Company Name (string, required) - Contact Person (string, required) - Email Address (string) - Phone Number (string) - Address (string) - Customer Status (select: Lead, In Negotiation, Contracted, Lost) - Plan (select: Free, Standard, Business) - Monthly Amount (number) - Contract Start Date (date) - Next Follow-up Date (date) - Account Manager (user_select) - Notes (rich_text) Sample data: | Company | Contact | Status | Plan | Monthly | Manager | |---------|---------|--------|------|---------|---------| | Company A | Taro Yamada | Contracted | Business | $500 | Sato | | Company B | Hanako Suzuki | In Negotiation | Standard | - | Tanaka | | Company C | Jiro Takahashi | Lead | - | - | Sato |

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:

Table: Task Management View 1: Incomplete Tasks (Status = "Not Started" OR "In Progress") View 2: Due This Week (Due Date = this week) View 3: High Priority Tasks (Priority = "High")

4. Visualize Progress with Graphs

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

Example:

Table: Task Management Graph: Tasks by Status (Pie Chart) Graph: Progress by Assignee (Bar Chart)

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.

0
0
0

Memoreru

0
投稿
0
フォロワー
0
いいね

プロパティ

ページ
DOCS
英語