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.8

Version 2.8

Contents
  • Version 2.8.12
  • Version 2.8.11
  • Version 2.8.10
  • Version 2.8.9
  • Version 2.8.8
  • Version 2.8.7
  • Version 2.8.6
  • Version 2.8.5
  • Version 2.8.4
  • Version 2.8.3
  • Version 2.8.2
  • Version 2.8.1
  • Version 2.8.0

The SeaTable Changelog is only available in English.

Since April 6, 2022, SeaTable Cloud https://cloud.seatable.io runs on version 2.8.12. All changes, updates, and improvements can be found in this changelog. Read more about this release in the release notes.

Version 2.8.12 #

  • FixedTypo and translation fixes

Version 2.8.11 #

  • FixedCreate column dialogue scrolling issue on smaller displays

Version 2.8.10 #

  • FixedNotification rules editing issue
  • FixedNumber column issue with the European format in the form

Version 2.8.9 #

  • AddedCollaborator column support for default value
  • AddedPassword symbol for shared/invited bases
  • FixedAlready filled filter condition terms are not emptied when switching predicates
  • FixedAPI issues
  • FixedDefault value issue when changing column type
  • FixedExport issue when the linked column is a formula column
  • FixedGroup heading UI issue when there's only one column
  • FixedIssue when grouping by link formula values
  • FixedIssue when inserting a column when there's hidden columns in the view
  • FixedIssue when switching to the previous/next image in the long text editor
  • FixedIssue with the Page design plugin PDF printing of linked tables
  • FixedProblems with the search feature
  • FixedSession logs can only record IP addresses of 127.0.0.1
  • RemovedData processing is removed from the data collection table
  • UpdatedError message improvement when the invite link is limited by the admin
  • UpdatedEuropean number formats like 1,22 can be used in the filter conditions
  • UpdatedSupport for exporting non-collaborators
  • UpdatedThe plugin management page can be used when the internet is disconnected

Version 2.8.8 #

  • AddedLDAP and SAML support for syncing user roles
  • Addedsupport to copy a creator/modifier column into a text column
  • FixedAutomation rules' bug when adding links
  • FixedCommon dataset sync issue for link columns
  • FixedCopy & paste issue with the geolocation values
  • FixedInvalid filter conditions in the sorting and grouping are ignored
  • FixedIssue with the printing feature in the latest browsers
  • FixedIssue with the single select filter condition showing "Deleted labels".
  • FixedJavaScript float number calculation precision issue
  • FixedSingle select default value coloring issue
  • FixedSorting issue when a view is grouped by multiple select or checkbox
  • FixedUI issue when grouping by single select options
  • UpdatedCommon dataset synchronization dialog improvement
  • UpdatedExcel interpretation error handling

Version 2.8.7 #

  • AddedA switch to turn the Archive feature on/off
  • Addedlink formula and formula columns displayed in the Add a link dialog
  • AddedSome help text when using link, and link formula columns as filter conditions
  • FixedCollaborators might be empty when printing a view or a row's details using compact mode
  • FixedIssue when adding filter conditions on the mobile terminal
  • FixedIssue with the error message when opening a URL with file:///xxx
  • FixedLogic fix for the and() function
  • RemovedLogin ID from the UI
  • Updatednotification/automation rules dialogue style unification
  • UpdatedWhen changing URL into image the image's URL is maintained

Version 2.8.6 #

  • FixedPage may crash if a row details page is opened where the multiple select column is empty

Version 2.8.5 #

  • FixedAutomation rules problem when running Python scripts
  • FixedIssue with the formula-string & formula-date unification
  • UpdatedNotifications optimization
  • UpdatedUI improvement when deleting a label

Version 2.8.4 #

  • AddedAPI to add/delete a team user
  • AddedAPI to batch insert/update/delete rows
  • Addedfilter, sort and group support for the URL column type
  • Addedlink columns displayed in the Add a link dialog
  • FixedDate column filtering issue
  • FixedDialogue navigation style issue
  • FixedIssues with the and() function
  • Updatedbase concurrent loading code improvement
  • Updateddtable-copy API error handling optimization
  • UpdatedExcel export error handling

Version 2.8.3 #

  • Addedline breaks in the linked text cells
  • Fixed500 log issue on the mobile device when exporting to Excel
  • FixedCommon dataset sync empty value validation issue
  • FixedForm submission issue when long text is set as required
  • Fixedlink expiration time verification issue
  • FixedSingle/multiple select options cannot be copied and pasted in the data collection table
  • FixedTeam admin interface UI issue
  • Fixedwording issue on the row comments panel
  • Updateddata limitation validation when copying a table
  • UpdatedImprove the API to get user avatar from the user ID list
  • UpdatedUser selection module style modification

Version 2.8.2 #

  • AddedAPI tolist trashed bases in the group trash bin
  • AddedAPI torestore bases from the group trash bin
  • UpdatedEmpty value handling
  • UpdatedOptimization when deleting a list item with the DEL key in the long text editor

Version 2.8.1 #

  • AddedAPIs to rename, delete, and duplicate table in the dtable-server
  • AddedDate column support in the small() and large() formula functions
  • Addedfilter condition support for image, file, and URL columns
  • AddedGroup base trash bin
  • AddedSearch support for link column and formula column
  • AddedShow an ellipsis when there are more than 40 items to show in a lookup cell
  • AddedSorting support when the view is grouped by linked column(s)
  • AddedSQL query support for the link, formula, and link formula columns
  • Addedsupport to copy collaborators column into a text column
  • Fixedbug when modifying a multiple select cell on the row details page
  • FixedCell highlighting issue when recognizing percentages
  • FixedColor rules cannot be added
  • FixedFilter module, frontend filtering and SQL unification bug fix
  • FixedHidden columns are sometimes not hidden in a shared view's plugins
  • FixedHours and Minutes component UI issue in the date widget
  • FixedImage display issue in the advanced statistics plugin
  • FixedIssue that a user's id_in_org is not deleted after the user is deleted
  • FixedIssue when deleting a group in the team/system admin
  • FixedIssue with the column description operation
  • FixedLinks are sometimes not removed when linked record is deleted
  • Fixedpotential issue when inserting a column
  • Fixedproblem with multiple frozen columns + hidden columns
  • FixedProblems when generating SQL statements from incomplete filter conditions
  • FixedTable header font color contrast issue
  • UpdatedBetter Euro currency format when exporting to Excel
  • UpdatedChange Front/Back into Before/After in the currency settings
  • Updatedcode optimization for updating user/team used row count
  • UpdatedCommon dataset sync algorithm improvement
  • UpdatedDepartment members submission UI improvement
  • Updateddropdown widget style unification
  • Updatedfilter condition improvement for case insensitive terms
  • UpdatedImprove the display of script running log
  • UpdatedMultiple matching conditions can be added in lookup and copy feature in the Data processing
  • UpdatedProper error message when synchronizing common dataset manually
  • UpdatedProper error message when the filter is invalid in the common dataset
  • UpdatedRound() function's unification with Excel
  • UpdatedSharing UI modification
  • UpdatedSystem/team admin can list and delete bases in a group/department
  • Updatedteam admin backstage improvement
  • UpdatedTeam admin can jump to an external webpage to manage the team and users
  • UpdatedTeam admin page and system admin page UI unification
  • Updatedteam management style improvement in the system admin
  • UpdatedUI modification for deleting rows in an archived view

Version 2.8.0 #

  • AddedA base's archived data can be listed
  • AddedA pop-over window to indicate progress when deleting archived data
  • Addedadministrator can delete the archived data of deleted bases
  • AddedAPI for the system admin to delete invalid archives
  • AddedAPI for the system admin to list the backups of an archive
  • AddedAPI for the team admin to search for bases
  • AddedAPI to rename and update common dataset sync configuration
  • AddedAPI to update single/multiple select options
  • AddedColumn description can be added
  • AddedCommon dataset can be renamed
  • AddedCommon dataset support for periodic synchronization
  • AddedDeduplication plugin's support for the email column type
  • Addedfeature to create an archived view
  • AddedMedian calculation in the column calculations
  • Addednaming limitations for bases, views, external apps, folders, and username
  • AddedNumber labels can be displayed in the statistics' figures
  • AddedOnline members list in the base editor
  • Addedsmall() and large() functions in the formula
  • AddedTable header background color is customizable
  • FixedBase colors cannot change if they are in a folder
  • Fixedbug in the data processing's auto add link feature
  • FixedDark mode issue with the advanced statistics
  • FixedDate column format issue with the dateutils function
  • FixedFilter condition "Is current user" result issue in the plugins
  • FixedForm multiple select UI issue fix
  • FixedGroup header summary lacks of support for the displaying of decimals
  • FixedIssue when changing a column's type to link
  • FixedIssue when copying and pasting a list in the long text editor
  • FixedIssue when copying texts from lists to paragraphs
  • FixedIssue when opening local file via button
  • FixedIssue when submitting a form multiple times
  • FixedIssue when undoing deletion of a link column
  • FixedIssue with "View shares" in group bases
  • FixedIssue with security settings
  • FixedIssue with the Select All checkbox
  • FixedJavaScript is hidden from the automation rules actions
  • FixedLa Réunion is missing in Countries
  • FixedMobile view bug when filling data collection table - new single select labels can be added
  • FixedNumber type issue when summarizing in the rollup's max/min
  • FixedNumbers format issue when exported from a formula column into Excel
  • FixedOnline members list UI bug fix
  • Fixedpermission verification issue when renaming bases/folders in a group
  • FixedScripts cannot add link records in a newly created link column
  • FixedSome permission verification issues
  • FixedThe empty spaces on the table tabs are not symmetrical on a read only view
  • FixedTimeline issue when the view is grouped with multiple layers
  • FixedUnordered lists cannot be added in ordered lists as sub items in the long text editor
  • RemovedArchives management from the system admin in the Developer Edition
  • UpdatedA collaborator is not removed from the column after they are deleted as collaborator
  • UpdatedAdvanced statistics improvement
  • UpdatedArchive view notice wording improvement
  • Updated Archived view automatically loads more data when scrolled to the bottom
  • UpdatedArchived view data count display improvement
  • UpdatedBase password feature improvement
  • UpdatedBases of a deleted user can be restored into the system admin's personal library
  • UpdatedCalendar's agenda list can display multiple strings
  • UpdatedChange the font size of all the instruction texts on the user interface to 13px
  • UpdatedCommon dataset periodic synchronization UI improvement
  • UpdatedCommon dataset synchronization strategy improvement
  • UpdatedCurrency symbol can be displayed before or after the number
  • Updateddataset module code utilization
  • UpdatedDefault font size on the home page changed to 14px
  • Updateddrop down menu style unification
  • Updatederror handling improvement
  • Updatedform help text support for long text
  • UpdatedKanban improvement
  • UpdatedLinked table's font size can be customized in the page design plugin
  • Updatedlog display optimization
  • UpdatedLong text improvement for tables, lists and images
  • UpdatedOptimization for mobile list view
  • UpdatedPOST method is used instead of GET in the API request to export a base
  • UpdatedQuery app support for sorting
  • UpdatedSQL plugin optimization
  • UpdatedSystem admin can search a base by name
  • UpdatedTeam admin can rename and delete all departments
  • UpdatedTeam admin can search a base by name or by UUID
  • UpdatedText line breaks are automatically added in the page design plugin
  • UpdatedUI optimization for adding views/archived views
  • UpdatedWebhook relevant code simplified
  • UpdatedWhen a team is deleted, its workspaces and users are all deleted
  • UpdatedWhen there are more than 10 links in a cell, display an ellipsis

For comments or questions: We would be glad to welcome you on the SeaTable Forum.

How helpful was this article?
Updated on 26 August 2022
Version 3.0Version 2.7
Contents
  • Version 2.8.12
  • Version 2.8.11
  • Version 2.8.10
  • Version 2.8.9
  • Version 2.8.8
  • Version 2.8.7
  • Version 2.8.6
  • Version 2.8.5
  • Version 2.8.4
  • Version 2.8.3
  • Version 2.8.2
  • Version 2.8.1
  • Version 2.8.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
  • Русский