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 1.6

Version 1.6

Contents
  • Version 1.6.5
  • Version 1.6.4
  • version 1.6.3
  • Version 1.6.2
  • Version 1.6.1
  • Version 1.6.0

This changelog is only available in English

Version 1.6.5 #

(Released: 13-Jan-2021)

  • Added option to disable SSO login users to change their password
  • Fixed problem when calculating across tables
  • Fixed view sharing bug fixes

Version 1.6.4 #

(Released: 12-Jan-2021)

  • Fixed potential security problem when sharing a view
  • Fixed Problems when embedding a base onto a website
  • Fixed Row re-locking (re-unlocking) problem
  • Updated Improvement of the API request for org-admin to add new groups
  • Updated UI to change the order of single/multiple select options
  • Updated When the org-admin deletes a user their bases will be put into the trash

Version 1.6.3 #

(Released: 12-Jan-2021)

  • Added batch replacing
  • Added Files can be saved into Seafile drive
  • Added Independent URL for "All notifications" dialog in the base editor
  • Fixed Activities permission bugs
  • Fixed Attachments request under customized sharing permission bugs
  • Fixed Auto-fill problems when text includes numbers
  • Fixed compatibility problem of the lookup() function
  • Fixed Conditional formatting problem with time conditions
  • Fixed Form submission feedback message not centered
  • Fixed Interface display problem when deleting a filter condition
  • Fixed Pie charts export excludes the labels
  • Fixed Problems in the linked 1:n situation
  • Fixed Scripts error message overflows the interface
  • Fixed Special symbols in the base name could cause table loss
  • Fixed Submission button problem after correcting invalid email address
  • Removed Mobile terminal statistics settings removed
  • Updated Compatibility improvement for transferring null data between link and formula column types
  • Updated Duration type input support for Chinese colon symbol
  • Updated Formula column can be created in an empty table
  • Updated General notification improvement
  • Updated Improvements for email notifications
  • Updated Map and Gallery plugin improvements
  • Updated Mobile terminal interface re-design
  • Updated notification details style improvement
  • Updated Press Enter key to save form name
  • Updated Read-only shared user can preview PDF online
  • Updated Reinforcement of the scripts editor
  • Updated Saving file to Seafile: UI improvement
  • Updated Statistics UI improvements
  • Updated UI to change the order of hidden columns conforms with the change of view orders
  • Updated Unified usage of dtable_uuid in the SeaTable API request
  • Updated User can "Download all" attachments in a shared view
  • Updated When duplicating tables, the linked records can also be copied

Version 1.6.2 #

(Released: 06-Jan-2021)

  • Added Date() function
  • Added descriptions of the operators in the formula editor
  • Added quoting formulas across tables
  • Fixed Batch operation (delete, drag to fill) to linked column fields triggers an error message
  • Fixed Error when exporting a base to Excel
  • Fixed interface crashes when deleting a table
  • Fixed Security problem fixes with some API requests
  • Removed Verification of the file existence

Version 1.6.1 #

(Released: 06-Jan-2021)

  • Added IFS() function
  • Added URLs for details on the "All notifications" dialog
  • Fixed Number conformity problem between form's and base's number editors
  • Fixed Print preview not showing grouping labels if they are numbers or linked fields
  • Updated Optimization of the expanded formula editing dialog

Version 1.6.0 #

(Released: 06-Jan-2021)

  • Added "Tell A Friend" link and page
  • Added attachments management
  • Added Autofill by numbers when numbers are included in texts
  • Added Comments preview in the notification
  • Added Customizable email notifications
  • Added DateDif() function to calculate the difference between two dates
  • Added Duration column type
  • Added Email column type
  • Added Eomonth() function to return the end of a month within a given time period
  • Added export function of statistics figures
  • Added feedback to executing scripts
  • Added form support for the duration field type
  • Added Formula editor gives an explanation of why a formula is invalid
  • Added getAccountInfo API to return an account's org_id
  • Added Invite group members
  • Added Notifying users from a certain column in the notification rules setting
  • Added Rename files with collaborator names in batch download attachment
  • Added support to embed a base to a website
  • Added trash bin for bases
  • Fixed Display of numeric values in the Gallery plugin
  • Fixed Display of percentage values in the statistics
  • Fixed Form setting display problem when "&" is in the name of a base
  • Fixed Grouping problem with the linked column type
  • Fixed Hidden column showing on print preview and row details page
  • Fixed Interface height display problem after deleting rows in a grouped view
  • Fixed Organization administrator API permission issues
  • Fixed performance issues when copying plenty of cell data
  • Fixed Pictogram for the URL column missing in the Gallery plugin
  • Fixed potential security problem with certain API requests
  • Fixed problem when inserting text after a code block in the long text editor
  • Fixed Problems when copying a selected row with Ctrl+C
  • Fixed Problems when selected a text cell and then collapse the group
  • Fixed Statistics crash problem on mobile devices (Normal on PC terminal)
  • Fixed UI problem when moving views and tables
  • Removed Redundant database queries
  • Updated Column type menu
  • Updated Creating base interaction UI improvement
  • Updated Custom sharing permission also available from the base library view
  • Updated Improved search function call with the key combination Ctrl+F
  • Updated Improvement of highlighting in statistics
  • Updated Map plugin improvements
  • Updated Multilingual translation optimization
  • Updated Non-modal display for the Gallery plugin
  • Updated Notices at the top and bottom in the form editor can directly be edited
  • Updated Optimization of page loading speed
  • Updated page loading optimization with new workspace API
  • Updated Sharing limit of 100 single users a base can be shared to (excluding groups)
  • Updated Sharing permission dialog improvement
  • Updated Sort by numbers when numbers are included in texts
  • Updated SQL query optimization
  • Updated Statistics performance optimization for mobile terminal
  • Updated Statistics user interface
  • Updated View dragging and renaming UI improvement

For further information, refer to the Release Note 1.6.
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 1.7Version 1.5
Contents
  • Version 1.6.5
  • Version 1.6.4
  • version 1.6.3
  • Version 1.6.2
  • Version 1.6.1
  • Version 1.6.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
  • Русский