SeaTable
  • Functions
  • Templates
  • Solutions
    • Marketing - – The next marketing campaign is bound to come. Nothing is easier than that.
    • Project management - – Plan, track and manage team projects from start to finish.
    • Human Resources - – Structure HR processes for new hires and onboarding.
    • Distribution - Manage your entire sales pipeline and customer relationships in one place.
    • Software development - Increase the quality and speed of your development team with SeaTable.
  • Support
    • Quick guide - – Everything you need to know to get SeaTable up and running in minutes.
    • Help area - – Find answers to your questions and get tips on how to get the most out of SeaTable.
    • Integrations - – Connect SeaTable with tools like Zapier, Integromat or n8n. Or use SeaTable's API.
    • SeaTable Blog - – Here you will find product information, news and many examples of how you can use SeaTable optimally.
  • Home Blog
  • Industries
    • Marketing
    • Project management
  • Topics
    • No Code / Low Code
    • Product Updates
    • Success stories
    • News
    • Productivity
  • Prices
  • Login
  • login
  • Registration
  • Menu Menu

Changelog

  • Version 3.3
  • Version 3.2
  • Version 3.1
  • Version 3.0
  • Version 2.8
  • Version 2.7
  • Version 2.6
  • Version 2.5
  • Version 2.4
  • Version 2.3
  • Version 2.2
  • Version 2.1
  • Version 2.0
  • Version 1.9
  • Version 1.8
  • Version 1.7
  • Version 1.6
  • Version 1.5
  • Version 1.4
  • Version 1.3
  • Version 1.2
  • Version 1.1
  • Version 1.0

First steps

  • Glossary of terms used by SeaTable
  • What is SeaTable?
  • Registration and login
  • The first base
  • Data analysis
  • Cooperation
  • Extensions

Use SeaTable

  • Use SeaTable
  • Bases
  • Views
  • Grouping, sorting and filtering
  • Statistics
  • Web forms
  • Templates
  • Data import and export
  • Personal settings

Expert knowledge

  • Formula Reference
  • Webhooks
  • API tokens
  • Zapier Integration
  • DTABLE file format

Working with groups

  • Introduction to working with groups
  • Create a new group
  • Rename a group
  • Change the order of the groups
  • Copy a Base to a Group
  • Release a Base to a Group
  • Share individual spreadsheets of a base
  • Delete a group
  • Create a folder
  • Move a Base to a Folder
  • Get workspace ID of a group
  • Add a Base to Favorites

Group members and permissions

  • Add a team member to a group
  • Assign permissions in a group
  • Transfer a group to another user
  • Group members and their permissions

Manage bases

  • Introduction to working with bases and tables
  • Create a new base
  • Creating a Base Using a Template
  • Duplicate an existing base
  • Delete a Base
  • How to add a description to a base
  • Customize the appearance of a base (icon and color)

Working in tables

  • Add a table in a base
  • Move a table
  • Link tables with each other
  • 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

  • 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

History and versions

  • 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
  • Saving a base as a DTABLE file

Working with columns

  • Overview of all column types
  • Adding a column
  • The specifics of the first column
  • Adding a column description
  • How to customize the column type
  • Duplicate a column
  • Customize the first column
  • Double column height
  • Hide column arrows

Text and numbers

  • The numbers column
  • The Automatic Number column type
  • The e-mail column and its use
  • The URL column

File and image attachments

  • The file column
  • How to remove attachments permanently
  • Differences between image and file column
  • The preview of image files
  • Delete images and files from a row
  • Access to deleted attachments

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
  • 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 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 comparing 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
  • Differences between formulas in Excel and SeaTable

Date, duration and people

  • The date column
  • The duration column
  • The columns Creator and Created
  • The employee column
  • The "Last edited" and "Last edited" 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
  • Select multiple rows
  • Duplicate a row
  • Locking a row
  • Change the order of rows
  • Delete a row
  • Display of changes on a row

Line details

  • What is the rows-ID?
  • How to find out who added a row ?
  • rows comment
  • Print row details

View basics

  • What is a view?
  • Create a new view
  • Rename a view
  • Delete a view
  • Differences between private and normal views
  • Duplicating views
  • Printing a view
  • Change the order of views
  • Group views in folders

View options

  • Filtering entries in a view
  • Link filter rules with AND and OR
  • Sorting entries in a view
  • Grouping entries in a view
  • Adjust row height
  • Hide and move columns
  • Cell coloring
  • Color marking of rows
  • Adjust the number of fixed columns
  • Lock views

View releases

  • Sharing a view with a team member
  • Create external link for a view

Working with plugins

  • What is a plugin?
  • Activate a plugin in a Base

Calendar plugin

  • Calendar plugin guide
  • Create new calendar entries in the calendar plugin
  • Create multiple calendars for one Base

Gallery plugin

  • Gallery plugin guide
  • Add a new row via the gallery plugin

Kanban plugin

  • Kanban plugin guide

Web forms

  • Creating a web form
  • Prefill form fields via URL
  • Conditional display of individual form fields
  • Configuration options and visual adjustments of a web form

Team collaboration

  • How collaboration works in SeaTable
  • Base and view shares at a glance
  • Groups for collaboration

Authorisations

  • Overview of all permissions
  • table permissions set
  • Create custom share

Release links

  • Create invitation link
  • Create external link for a base
  • Create a user share
  • Releasing a Base to a Group
  • Differences between invitation links and external links

Comments

  • The comment function in SeaTable

Team management

  • Unlock a team member
  • The functions of the team management in the overview
  • Groups and their members in the team management
  • Bases in the team management
  • View all access permissions of a Base
  • Empty the recycle bin in team management
  • Add a new team member
  • Make a team member an administrator
  • Delete the complete team
  • Lock or delete a team member
  • Changing the team name
  • Create a new group
  • Force two-factor authentication for the entire team
  • Enable two-factor authentication for a team member
  • View the terms of use or privacy policy
  • Open a support ticket
  • Request an AV contract

Subscription / Billing

  • Where can I find my invoices?
  • Plus or Enterprise subscription booking
  • Change current subscription: Customize package, duration and team size
  • Cancel the subscription
  • Customize billing address
  • Deposit of the tax ID
  • Change credit card
  • Payment by invoice
  • Discounts for public, non-profit or educational institutions
  • Is SeaTable free of charge? Can I try the Plus or Enterprise subscription?
  • Subscription packages
  • Subscription management

Working with automations

  • Automation overview
  • Functionality of automations
  • Create an automation
  • Manage and edit automations
  • Show execution log of an automation
  • Stop automations
  • Delete automations
  • Automation Trigger
  • Automation actions
  • Why can't I find the automations in my base?

Automation examples

  • rows Lock by automation
  • Linking entries via automation

Third party email

  • Set up Gmail to send emails via SMTP

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

  • rows Move to the Big Data backend
  • To create a Big Data view
  • Enabling the Big Data backend in a Base
  • Home
  • Help
  • Changelog
  • Version 2.0

Version 2.0

Contents
  • Version 2.0.6
  • Version 2.0.5
  • Version 2.0.4
  • Version 2.0.3
  • Version 2.0.2
  • Version 2.0.1
  • Version 2.0.0

This changelog is only available in English

Version 2.0.6 #

(To be released soon)

  • Fixed favicon loading problem when a new notification is available
  • Fixed Linked labels are displayed as ID when exported to Excel
  • Fixed Mouse cursor problem when importing data from the common dataset

#

Version 2.0.5 #

(Released on 27 May 2021)

  • Fixed Issue of switching to a view after renaming it
  • Fixed Undo menu UI improvement in German
  • Updated Calendar plugin

 

Version 2.0.4 #

(Released on 27 May 2021)

  • Added support for custom favicon
  • Added Undo and redo buttons in the History menu
  • Fixed Column type setting panel UI issue
  • Fixed Conditional formatting English menu issue
  • Fixed Error when exporting a shared view to Excel
  • Fixed Formula column with if() function cannot be selected in the notification rules settings
  • Fixed Issues with the API requests to create/modify views
  • Fixed View options (filters, sorts, and groups) display issue in German
  • Updated Rating type support for drag-to-fill
  • Updated Speed-limit for rows and filtered-rows GET API

#

Version 2.0.3 #

(Released on 27 May 2021)

  • Added button action to open a certain Page Design page
  • Added Russian language support
  • Added Sys-admin can list all the notification rules in the system
  • Fixed External link scrollbar issue on displays with lower resolution
  • Fixed Filter issue in the collaborator column
  • Fixed Issues when importing a CSV file
  • Fixed Seafile choose file dialog doesn't update the recently used files
  • Removed Redundant options when copying a template
  • Updated Calendar support for the user to set the beginning day of the week (Mon/Sun)
  • Updated Calendar's item color can be retrieved from the row's color
  • Updated Collaborator column support for sorting by collaborators' names
  • Updated Column type arrangement optimized
  • Updated Create link column API request optimization
  • Updated Data collection table: Participants cannot add new single/multiple select options
  • Updated rollup() function support for duration type
  • Updated Sort for creator and modifier column types
  • Updated support for Rating column type in the form
  • Updated Table, row, column, and API request limit

#

Version 2.0.2 #

(Released on 27 May 2021)

  • Fixed form filter bug fixes
  • Fixed Group URL problem on the system administration page
  • Fixed Pasting problem in the long text editor
  • Updated Common dataset UI improvement
  • Updated Insert/delete/modify rows and other batch operations limited to 1000 rows at once
  • Updated Link column search for the first column and other text columns
  • Updated View external link / collection table page won't load notification
  • Updated When a table has more than 100,000 rows, no new rows can be added
  • Updated When a table has more than 150,000 rows, it cannot be accessed

#

Version 2.0.1 #

(Released on 27 May 2021)

  • Added dtable_uuid and op_id conjoined indexing for the operation_log
  • Added Simple SSO
  • Updated Mobile terminal layout improvement
  • Updated web interface optimization

#

Version 2.0.0 #

(Released on 27 May 2021)

  • Added API request for the system administrator to delete a base
  • Added Creation time in the API response when listing rows in a view
  • Added Kanban plugin
  • Added Limit of number of tables in a base
  • Added More options for the linked column type
  • Added Pre-filled values in form
  • Added Rating column type
  • Fixed Accumulative fixes in the "Last modifier" column
  • Fixed API request cannot forward user's role
  • Fixed Error message persists on the sharing dialogue when password or expiration is invalid
  • Fixed filename encoding problem
  • Fixed First character missing problem in the long text editor
  • Fixed Highlighted search results could overlap each other when dragging horizontally
  • Fixed link_id missing when inserting a link column via API request
  • Fixed Locked rows can be deleted under mobile view
  • Fixed third-party email account setting problem
  • Updated API request to delete a row/row link returns the number of rows/row links deleted
  • Updated Common dataset group permission setting page German UI improvement
  • Updated countlinks() function support filter conditions
  • Updated Discriminated bases by workspaces in the base library search result
  • Updated dtable-server API URL optimization
  • Updated Geolocation support for automatic recognition
  • Updated Geolocation support for country and region
  • Updated Link column support for searching in the content of all the other text columns
  • Updated Linked columns can be used to sort
  • Updated Notification: Collaborator search code optimization
  • Updated Notifications are not reloaded when the server is re-connected
  • Updated Optimization for the admin to download dtable file
  • Updated Optimization of the getting of formtoken on the form submission page
  • Updated Performance optimization of the formula
  • Updated Report function UI improvement
  • Updated The plugins panel closes automatically after clicking on a plugin
  • Updated When logging in with SAML/LDAP, the id_in_org can be filled in automatically

See the Release Note for SeaTable 2.0 for detailed information to the functionalities.
For comments or questions: We would be glad to welcome you on the SeaTable Forum.

How helpful was this article?
Updated on 25 August 2022
Version 2.1Version 1.9
Contents
  • Version 2.0.6
  • Version 2.0.5
  • Version 2.0.4
  • Version 2.0.3
  • Version 2.0.2
  • Version 2.0.1
  • Version 2.0.0
SeaTable Logo

Do it like thousands of other people who use SeaTable to develop powerful processes, bring order to their data, and complete their tasks more efficiently.

SeaTable on Linkedin SeaTable on Medium.com SeaTable on Instagram SeaTable on Twitter SeaTable on Github SeaTable on YouTube SeaTable at Docker Hub

Products

  • SeaTable Cloud
  • SeaTable Dedicated
  • SeaTable Server
  • Support

Support

  • Quick guide
  • Help area
  • Templates
  • Integrations
  • Forum
  • Developer API
  • Status

Company

  • About us
  • We hire
  • Press
  • Contact
  • Blog
  • Imprint
  • Security
  • Data protection
  • Terms of use
  • EULA
Scroll up
  • Deutsch
  • Français
  • Español
  • Português
  • Русский