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.
  • Prices
  • Login
  • login
  • Registration
  • Menu Menu

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
  • Set default value for a 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
  • Home
  • Help
  • Use SeaTable
  • Working with columns
  • Customize the first column

Customize the first column

The first column of a table has various special features compared to the other columns. Customizing the column is possible only with restrictions. Here you can learn how to customize the first column in SeaTable.

How to customize the first column

Customize the first column

  1. Click the triangle icon to the right of the first column name.
  2. Go to Customize column type.
  3. Click in the field of the current column type.
  4. Select a new column type for the first column.
  5. Make format settings if necessary.
  6. Click Submit.
  7. Confirm the adjustment by clicking Convert.

There are only six column types to choose from for the first column:

  • Text
  • Number
  • Date
  • Single selection
  • Automatic number
  • Formula

Formulas in the first column

For example, if you define a formula as the first column of a table, you can use the simple formula {column name} to quote the entries from almost all other columns of your table, even if the respective column type is not supported in the first column.

Possibilities with the Formula column type in the first column of a table

Frequently asked questions

Why is the first column so special?

The first column of a table is special because it is modeled on the primary key in relational databases. SeaTable uses the first column to identify a record. Therefore it is very important.

What are the limitations of the first column?

The first column cannot be hidden, moved or deleted.

Is it possible to change the type of the first column afterwards?

Yes, this is possible. However, in some cases information may be lost when changing the column type, for example from text to number. Therefore, after a conversion, check whether all information has been transferred correctly and completely.

What is an automatic number?

If you want your rows to have a unique number, the Automatic number column type could serve you well. Examples are invoice numbers, test cases or employee IDs. The number can be additionally supplemented with any prefix.

How helpful was this article?
Updated on 18 April 2023
How to customize the column typeThe specifics of the first column
Contents
  • How to customize the first column
  • Formulas in the first column
  • Frequently asked questions
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
  • Русский