Use SeaTable

A general overview
Introduction to working with bases and tables
Data acquisition
Cooperation
Views and plugins
Statistics and data analysis
Working with groups
- Introduction to working with groups
- Create a new group
- Groups for collaboration
- Add a team member to a group
- Assign permissions in a group
- Group members and their permissions
- Rename a group
- Change the order of the groups
- Delete a group
- Get workspace ID of a group
- Transfer a group to another user
Working with bases
- General information about bases in SeaTable
- Create a new base
- Creating a Base Using a Template
- Duplicate a Base
- Delete a Base
- Create a folder
- Move a Base to a Folder
- Copy a Base to a Group
- Add a Base to Favorites
- How to add a description to a base
- Customize the appearance of a base (icon and color)
- Add your own colors in a base
- Security settings in a Base
- Set password for a Base
- Setting up an email account in a Base
Working in tables
- Add a table in a base
- Move a table
- Link tables with each other
- table permissions set
- Add a table description
- Delete a table from a base
- Restore a deleted table
- Use of emojis in table name
- Adding data via copy-and-paste
- Search and replace values
- Find a cell or value in a table
- Keyboard shortcuts and key combinations
Data import
- Data import and export
- Transferring a Base to another User
- What import formats does SeaTable support?
- Import Excel files into SeaTable
- Data import using CSV in SeaTable
- Data import from Microsoft Access into SeaTable
- Data import from Google Sheets into SeaTable
- Limitations of CSV/Excel import
- Tips and tricks when importing CSV or XLSX files
- Import CSV records into an existing base
- Creating a base from a DTABLE file
- Exporting a base as a DTABLE file
- The DTABLE file format
- Migration from Airtable Bases to SeaTable
History and versions
- History and logs
- Data recovery options with SeaTable
- Restore a deleted Base
- Retrieve tables, rows and columns from the recycle bin
- Undo actions
- Undo changes via the logs
- Saving the current Base as a Snapshot
- Restoring a snapshot
Working with columns
- Overview of all column types
- Adding a column
- How to customize the column type
- Customize the first column
- The specifics of the first column
- Set default value for a column
- Adjust the number of fixed columns
- Duplicate a column
- Adding a column description
- column permissions specify
- Lock table header
- Hide column arrows
- Double the height of the table header
- Text and numbers
  - The Text and Formatted Text columns
  - Formatting using Markdown / Rich text
  - Validation of input for text fields with regular expressions
  - The numbers column
  - The Automatic Number column type
  - The email column
  - The URL column
- Files and images
  - The file management of a Base
  - The file column
  - The image column
  - The signature column
  - Differences between image and file column
  - Delete images and files from a row
  - Access to deleted files and images
  - How to remove files permanently
- Selection columns
  - Create a single selection column
  - Adding options to a single-selection column
  - Changing the order of single-selection options
  - Cascading a single selection
  - The multiple selection column
  - Export and import options in single or multiple selection columns
  - The checkbox column
  - The rating column
- Links
  - How to link tables together in SeaTable
  - The Lookup Formula
  - The rollup formula
  - The Findmin formula
  - The Findmax formula
  - The Countlinks Formula
- Formulas
  - Basics of SeaTable formulas
  - Formula example: Simple multiplication with a formula
  - Formula example: Merging text columns with the help of a formula
  - Formula example: Logical if operators for conditional filling of values
  - Formula example: Search for a word in a text
  - Formula example: Calculate the duration of a vacation
  - Formula example: Calculate days to an event
  - Tips for working with formulas
  - Typical mistakes when working with formulas
  - Differences between formulas in Excel and SeaTable
  - Formula Reference
- Date, duration and people
  - The date column
  - The duration column
  - The Creator and Creation Date columns
  - The employee column
  - The Last Processor and Processed Date columns
- Other columns
  - The geoposition column
  - The button
  - Send an e-mail via button
  - Save a PDF document by button in a column
Work with rows
- Adding a row
- Duplicate a row
- Locking a row
- Change the order of rows
- Select multiple rows
- Delete a row
- Display of changes on a row
- Copy the rows URL
- rows comment
- Print row details
- The comment function in SeaTable
Working with views
- What is a view?
- Grouping, sorting and filtering
- Differences between private and normal views
- Create a new view
- Rename a view
- Delete a view
- Duplicating views
- Printing a view
- Change the order of views
- Group views in folders
- Pin views
- View options
Plugins
- What is a plugin?
- All plugins at a glance
- Activate a plugin in a Base
- Calendar plugin guide
- Create new calendar entries in the calendar plugin
- Create multiple calendars for one Base
- Gallery plugin guide
- Add a new row via the gallery plugin
- Timeline plugin guide
- Kanban plugin guide
- Map plugin guide
- Data deduplication plugin guide
- SQL Query Plugin Guide
- Statistics plugin guide
- Page design plugin
Web forms
- Web forms
- Creating a web form
- Configuration options of a web form
- Conditional display of individual form fields
- Prefill form fields via URL
Releases
- Base and view shares at a glance
- Share a Base with a User
- Release a Base to a Group
- Create invitation link
- Create external link for a base
- Differences between invitation links and external links
- Delete external links and invitation links
- Release individual tables of a base
- Create custom share
- Exit shared bases
- Sharing a view with a team member
- Sharing a view with a group
- Create external link for a view
Automations
- Automation overview
- Functionality of automations
- Create an automation
- Manage and edit automations
- Show execution log of an automation
- Execution limit for automations
- Stop automations
- Delete automations
- Automation Trigger
- Automation actions
- Why can't I find the automations in my base?
- Automation examples
- Notifications
Data processing
- Data processing operations in SeaTable
- Create data processing operations
- Perform data processing operations manually
- Edit data processing operations
- Delete data processing operations
- Data processing: Calculate cumulative values
- Data processing: Calculate changes
- Data processing: Calculate ranking
- Data processing: Calculate percentage
- Data processing: compare and copy
- Data processing: Transfer user name
- Data processing: compare and link
Common data sets
- Functionality of shared data sets
- Create a common data set
- Synchronization of a common data set
- Create a new table with a common record
- Add columns to a table created with a common data set
- Sharing a common record with another group
- Deleting a common record
- Why do shared records only work in groups?
Big Data
- Introduction to the possibilities of Big Data
- Enabling the Big Data backend in a Base
- To create a Big Data view
- rows Move to the Big Data backend
- rows Retrieve from the Big Data backend
- Limitations in the use of Big Data
Apps
- What apps are available?
- Universal app
- Gallery App
- Data retrieval app
- Adding Apps to a Base
- Edit apps
- Copy apps
- Show the preview of an app
- Share data query and gallery app
- Disable apps temporarily
- Delete apps
- Universal apps