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.5
  • Version 3.4
  • 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

  • What is SeaTable?
  • Create SeaTable account
  • First steps with SeaTable
  • Glossary of terms used by SeaTable
  • Get help

Quick guides

  • The home page of SeaTable
  • The first base
  • Start with a template
  • The elements of SeaTable at a glance

Personal settings

  • Personal settings
  • Change own password
  • Customizing the interface language
  • Customize avatar image
  • Unsubscribe from SeaTable notification emails
  • Enable 2-factor authentication

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
  • 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

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
  • 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 with the help of 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 column
  • Differences between image and file column
  • The preview of image files
  • Delete images and files from a row
  • How to remove attachments permanently
  • 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
  • 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

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

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
  • 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 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

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

  • Filtering entries in a view
  • Link filter rules with AND and OR
  • What is the ID of the user and how can you filter with it?
  • Sorting entries in a view
  • Grouping entries in a view
  • The status-row and its functions
  • Adjust row height
  • Hide and move columns
  • Cell coloring
  • Color marking of rows
  • Lock views

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

  • Page design plugin tutorial
  • Static image
  • Static text
  • Dynamic elements
  • Table fields
  • Entries and pages
  • Header and footer

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
  • Stop automations
  • Delete automations
  • Automation Trigger
  • Automation actions
  • Why can't I find the automations in my base?

Automation examples

  • Email dispatch via automation
  • rows Add via automation
  • Add entries to other tables via automation
  • rows Lock by automation
  • Linking entries via automation
  • Perform data processing operation by automation
  • Capture times of a status change with an automation

Notifications

  • Sense and purpose of notifications in SeaTable
  • Create notification rule
  • Edit and remove notification rules
  • Send notifications via automation
  • Delete all notifications or mark as read

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 work and 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
  • Retrieve entries from Big Data
  • Limitations in the use of Big Data

Team management and subscription

  • Subscription and billing at a glance
  • The functions of the team management in the overview
  • What subscription packages are available?

Team management

  • Add a new team member
  • Lock or delete a team member
  • Unlock a team member
  • Make a team member an administrator
  • Changing the team name
  • 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
  • Delete the complete team
  • Create a new group
  • base sharing Allow via invitation link
  • Force two-factor authentication for the entire team
  • Enable two-factor authentication for a team member
  • Changing the ID of the user in the team management
  • View the terms of use or privacy policy
  • Request an AV contract
  • Open a support ticket

Managing your subscription

  • Plus or Enterprise subscription booking
  • Change current subscription: Customize package, duration and team size
  • Where can I find my invoices?
  • How are inactive users considered in billing?
  • What happens to my data when I delete my team?
  • What to do if you have exceeded the subscription limits?
  • What payment methods does SeaTable offer?
  • Cancel the subscription
  • Customize billing address
  • Deposit of the tax ID
  • Change credit card
  • How team members influence subscription costs
  • Payment by invoice
  • Discounts for public, non-profit or educational institutions
  • Is SeaTable free of charge? Can I try the Plus or Enterprise subscription?

Frequently asked questions

  • Does SeaTable work on mobile devices and phones?
  • Credit card payments could not be completed
  • I have forgotten my password. Can I reset it?
  • The confirmation email does not arrive. What now?
  • Is it possible to merge two SeaTable accounts?
  • Can I use SeaTable offline?
  • What are the technical requirements of SeaTable Cloud?
  • Does SeaTable also have a dark theme (dark mode)?
  • How to subscribe or unsubscribe from the SeaTable newsletter?
  • What to do if you have exceeded the limits?
  • Why are there two release options in one Base?
  • How to export the base structure (e.g. for a forum entry)?
  • How do I find missing data in a Base?
  • How long are the different elements stored in SeaTable?
  • What is the difference between individual shares and shared records?
  • Why can't I delete the first column of my table?
  • How to find out who added a row ?
  • What is the rows-ID?
  • Read-only access because limits reached?
  • How to change your email address?

Known problems

  • Blank page at page design plugin

Scripts, API and integrations

  • Overview of all integrations in and with SeaTable
  • What are webhooks and what do you use them for?

JavaScript & Python

  • Differences between JavaScript and Python scripts in SeaTable
  • Creating and deleting a script
  • Import and export of a script
  • Run script manually, by button or by automation
  • The execution log of scripts
  • JavaScript example: set one checkbox, remove all others
  • Python example: Create a few random entries
  • Python example: Reading the metastructure of a base
  • Supported Python libraries

Integrations within SeaTable

  • Set up Microsoft 365 to send emails via SMTP
  • Set up Gmail to send emails via SMTP
  • Set up GMX or Web.de to send e-mails via SMTP

SeaTable API

  • Introduction to the use of the SeaTable API
  • Creating an API token
  • Edit and delete an existing API token
  • Typical errors in dealing with the SeaTable API

Webhooks

  • Creating and deleting a webhook
  • Structure of the webhook data
  • Processing a webhook with the help of PHP
  • The secret key of a webhook
  • Deactivation of a webhook in case of errors

Automation platforms

  • Zapier Integration
  • Extensions

Apps

  • What apps are available?
  • Universal app
  • Gallery App
  • Data retrieval app
  • Adding Apps to a Base
  • Edit apps
  • Show the preview of an app
  • Share data query and gallery app
  • Delete apps
  • Change settings of a universal app
  • Create and manage pages and folders in a universal app
  • Page types in the Universal App
  • Page permissions in a universal app
  • User and role management of a universal app
  • Home
  • Help
  • Use SeaTable
  • Working with views
  • View options
  • Hide and move columns

Hide and move columns

Contents
  • Hide columns
  • Move columns

The more columns you create to enter data, the more confusing your table becomes. To ensure that you always have an overview of your data, you can hide individual table columns that are not currently needed or are irrelevant. In addition, you can adjust the order of the columns as you wish using drag-and-drop.

Hide columns #

Hide columns

  1. Click Hide in the view options of any table.
  2. Hide any number of columns by clicking on them. Using the search field, you can narrow the selection of columns or search for a specific column you want to hide.
  3. Note
    You can decide individually for each column whether it should be shown or hidden, or with a click on Hide All you can hide all columns except the first column of the table at the same time. Just as effortlessly, you can show all columns again with a click on Show All.

Move columns #

Hold the mouse button on the Six dots symbols Icon for moving elements in front of the column names and drag them up or down in the list to change the order of the columns in the table as you wish.

Move columns

In addition, you can also move the columns directly in the table view using drag-and-drop. To do this, hold down the mouse button on the name of a column and move the column to the right or left.

Move columns from the table view.

Important note
Please note that the first column of a table cannot be moved. You can read about other special features of the first column in the corresponding overview article.
How helpful was this article?
Updated on 2 January 2023
Adjust row heightCell coloring
Contents
  • Hide columns
  • Move columns
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
  • Русский