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 3.0

Version 3.0

Contents
  • Version 3.0.16
  • Version 3.0.15
  • Version 3.0.14
  • Version 3.0.13
  • Version 3.0.12
  • Version 3.0.11
  • Version 3.0.10
  • Version 3.0.9
  • Version 3.0.8
  • Version 3.0.7
  • Version 3.0.6
  • Version 3.0.5
  • Version 3.0.4
  • Version 3.0.3
  • Version 3.0.1
  • Version 3.0.0

The SeaTable Changelog is only available in English.

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

Version 3.0.16 #

  • FixedA bug when reading a base larger than 200MB from the dtable-storage-server
  • FixedTemporarily calculated fields are removed when saving a base to reduce storage

Version 3.0.15 #

  • FixedA UI problem when editing link columns in the row details dialog

Version 3.0.14 #

  • FixedAvatar image issue and error handling
  • FixedExcel European number format issue fix
  • Removed"Add record" from the automation rule's action when the trigger condition is "New record added".
  • UpdatedAutomation rules UI improvement

Version 3.0.13 #

  • FixedFormula column filter condition issue on the mobile devices
  • FixedINNER_DTABLE_SERVER_URL fixes
  • Fixedseatable-controller configuration file wording error
  • UpdatedThe abuse report symbol on the admin's page

Version 3.0.12 #

  • AddedBase UUID in the response of the external links API for team/system admins
  • Fixedbug fix when batch downloading files
  • RemovedNewly created column's name shouldn't support "."
  • UpdatedDefault text filter condition is set to "is" in the big data view

Version 3.0.11 #

  • AddedDouble colored symbols
  • Addedfilter conditions support for re-arranging by drag&drop
  • FixedIssue with team admin's invite links
  • FixedOperation log issue when the first column is single select and has been modified
  • Updatedlink columns can be renamed when batch downloading files

Version 3.0.10 #

  • AddedA reminder to archive when the base has more than 80,000 records
  • AddedBase UUID is returned in the team/system admin's API request to list all base external links
  • Fixedbugs when appending data via CSV
  • Fixedform filling history drop-down covers the input field
  • FixedIssue that the personal info page is blank on the mobile terminal
  • FixedIssue when transforming other columns to formula
  • Fixedlink formula column (date type) deduction with date column issue
  • Updatedadministration backstage improvement
  • UpdatedExternal app URL improvement
  • UpdatedPython SQL generator improvement
  • UpdatedYou can add/delete tables on the view settings menu

Version 3.0.9 #

  • Fixedbug fixes

Version 3.0.8 #

  • AddedExternal query app support for limiting the query to a specific view
  • AddedInternal URL configuration in the dtable-server and run the proxy in the docker
  • FixedArchived view: Search current view bug fix
  • FixedMultiple select sorting issue
  • Fixedquery app result display issue
  • FixedRow details page of a linked record shows a hidden column
  • FixedScripts log display issue
  • FixedView settings saving issue
  • UpdatedA table's common dataset sync settings can be kept after duplicating it
  • UpdatedCreate time and modification time aligned right
  • UpdatedImprovement in the duration, number, and collaborator column types
  • UpdatedPython SQL statement translation function enhancement
  • UpdatedSingle base API request cannot exceed 5000 request per day (configurable)
  • UpdatedTeam management administrator page UI improvement

Version 3.0.7 #

  • AddedDocker network's name option added in the Python runner's configuration
  • FixedFormula column cannot be modified
  • FixedIssue when adding results from formula and link formula cells
  • Fixedlink editor bug fix
  • FixedNumber precision issue in the number filter
  • FixedProblems with format settings in link column
  • FixedSorting issue concerning multiple formula columns
  • FixedWhen the page is in 80% size, the scrollbars are not displayed
  • UpdatedDisable "Enforce precision" and "Default value" in the number column
  • UpdatedDocker wording improvement
  • UpdatedNotification/Automation "Rules" appear as an independent symbol
  • UpdatedThird party integration - Email UI improvement

Version 3.0.6 #

  • AddedAPI tolist bases in a group
  • AddedSummaries in the big data view
  • FixedFormula column coloring issue
  • FixedIssue when filtering teams by roles
  • FixedIssue when linking a link column to formula, collaborator, creator, or last modifier columns
  • FixedPassword reset and forget password issue
  • FixedPerformance issue when adding link records in a table that has a lot of records
  • Fixedsnapshot error handling
  • Fixedtext column cell format verification issue
  • FixedThe base header is always orange after sharing to other users
  • FixedWindows horizontal scroll bar is covered in some cases
  • UpdatedAbuse report button redesigned
  • UpdatedAPI to list all team users (with their 2FA status)
  • UpdatedAutomation rules statistics UI wording improvement
  • Updatedautomation ruls and form permissions can be duplicated with a base
  • Updatedautomation/notification rules improvement on valid/invalid verification
  • UpdatedNavigation improvement on the mobile terminal
  • UpdatedTable headings redesigned
  • Updatedthird party accounts feature improvement

Version 3.0.5 #

  • Fixed"Deleted option" is displayed when changing a single select column to multiple select
  • Fixedbug when exporting to Excel
  • FixedCommon dataset sync bug
  • FixedDate default values issue when the view is sorted by date
  • FixedIssue when selecting date range in the plugins
  • Fixedlink column display bug
  • UpdatedBetter formatting when copying and pasting dates
  • UpdatedSearch group members UI improvement
  • UpdatedSummary abbriviation improvement

Version 3.0.4 #

  • FixedLong text uploaded in the form/workflow is not correctly parsed
  • UpdatedBig data rows usage is displayed in the team info
  • UpdatedBig data storage buffer improvement
  • UpdatedBig data view search improvement
  • UpdatedCommon dataset sync symbols improvement
  • UpdatedGeolocation is supported on the big data view
  • UpdatedImage and file columns can be edited on the big data view
  • UpdatedStatistics figures can be duplicated
  • UpdatedTeams page in the system admin's page is improved

Version 3.0.3 #

  • FixedCell coloring issue towards formula column type
  • FixedIssue when selecting date range in the plugins
  • FixedLegends are not displayed on the preview of the statistics figure
  • UpdatedUse public/forms directory instead of forms directory for the normal form

Version 3.0.1 #

  • AddedConfigurable limitation for a group's archive usage
  • AddedDescription pop-over when opening a data collection form for the first time
  • AddedSystem admin can overview the total data usage of dtable-db
  • FixedAnimation is missing when the plugin panel disappears
  • Fixedbug fixes in the big data feature
  • Fixedbug when the team admin deletes an external link
  • FixedCommon dataset list accuracy issue
  • FixedCompatibility issue when using text for the number filter conditions
  • FixedDuration column is missing as an option in the statistics
  • FixedIssue when adding links on the mobile terminal
  • FixedIssue when the form title is very long
  • FixedThe link dialog is not updated after editing a link cell on the row details page
  • FixedTime zone issue in the filter conditions and in the calendar
  • FixedWebhook description wording issue
  • Removed Base API token status
  • Updated50.000 records can be loaded at once on the big data view
  • UpdatedCell color dialog supports submitting by pressing Enter
  • UpdatedColor rules - highlight duplicated values improvement
  • UpdatedError handling improvement when translating filters into SQL statements
  • Updatederror handling when listing daily active users
  • UpdatedExport table to Excel optimization
  • Updatedform and data collection table mobile view sharing dialog UI improvement
  • UpdatedIMAP optional configs can be used in the 3rd party account
  • UpdatedModifications done to a link cell can be undone via the operation logs
  • UpdatedThe system admin can reset a base's password from the search result
  • UpdatedWebhook x-seatable-signature security level optimization

Version 3.0.0 #

  • AddedA general external app that supports multiple pages
  • AddedA notice when using lookup-text to filter by contains/not contains
  • AddedAn extra symbol for columns that are synchronized
  • AddedAn interface to send dtable-db data back to dtable-server
  • AddedColumn type format verification
  • AddedCommon dataset management in the system administration
  • Addeddtable-storage-server in the docker image
  • Addedmore watchable column types in the automation/notification rules settings
  • AddedTeam admin's API to list, edit, or remove invite links of a base
  • AddedTeam admin's API to rename a group
  • FixedAfter editing a link on the row details page the interface is not updated
  • FixedEmpty cells handling when calculating rank in the data processing
  • FixedEmpty value handling for link formula
  • FixedFilename on top not updating when previewing different images
  • FixedFormula calculation error in Safari
  • FixedIssue that cells cannot be copied and pasted across bases
  • FixedIssue when undoing copying row action by button
  • FixedIssues when grouping/sorting by the link column (displayed as text)
  • FixedLDAP_Sync and SAML compatibility issues
  • FixedLinked text column can be selected as "Users in column" in the notification rules settings
  • FixedPDF online preview UI issue
  • FixedStatistics table issue with sorted data from the formula column
  • FixedSupport fix for lookup-formula-text, lookup-formula-bool
  • FixedSupport fix for numer, formula-number, link-formula-number and percentage
  • Removedfilter and sorting icons when there's no result to show on the external query page
  • UpdatedArchive data feature improvement
  • UpdatedAutomation rules statistics feature optimization for the admin
  • UpdatedChange "Archive view" into "Big data view
  • UpdatedCommon dataset regular syncing optimization
  • UpdatedDisplay the webpage's title differently when opening a table or a view
  • Updatedlarge() and small() function error message unification
  • UpdatedLookup (formula-bool) filter method update
  • UpdatedMenu title wording modification
  • UpdatedPublish common dataset dialog can list off the existing common datasets in the current table
  • UpdatedSelect widget style unification
  • UpdatedStatistics figure includes null values in the checkbox column
  • UpdatedTeam admin's API to get team info also returns the team's role
  • UpdatedTeam admin's API to get team's info now includes the count of Python runs
  • UpdatedTeam admin's API to list group members now includes 2FA usage
  • UpdatedTeam admin's API to list the external links of a base
  • UpdatedTeams can be listed by roles in the system administration
  • UpdatedUI improvement when clicking on the common dataset sync button
  • UpdatedUser's API to restore group trashed base uses the base's UUID

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 3.1Version 2.8
Contents
  • Version 3.0.16
  • Version 3.0.15
  • Version 3.0.14
  • Version 3.0.13
  • Version 3.0.12
  • Version 3.0.11
  • Version 3.0.10
  • Version 3.0.9
  • Version 3.0.8
  • Version 3.0.7
  • Version 3.0.6
  • Version 3.0.5
  • Version 3.0.4
  • Version 3.0.3
  • Version 3.0.1
  • Version 3.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
  • Русский