You organize data in SeaTable in bases. A base is a container for one or more tables. The tables in a base can be independent of each other, or they can be linked to each other by relations, as in a database. You can also share bases with other team members or invite external third parties to work on them together. Unbeknownst to you, SeaTable maintains a history for each Base in the background, allowing you to undo changes and restore previous states quickly and easily should you need to.
The home page #
After logging in, you will find yourself on the start page. Here you manage your bases. If you selected templates during registration, they will be displayed here. With a click on the avatar image in the upper right corner you can switch to the personal settings and the account settings, for example to adjust the language and other things.
Click on Add Base to create your first base. Enter a name and the base is placed on the start page. If you move the mouse pointer over the name of the base, a pencil icon and the three-dot icon for the advanced functions appear to the right of the name. You can use the pencil icon to rename the base and assign a different icon and colour to it. The advanced functions include, for example, the release of a base or its export. You open the base by clicking on its name.
Table view #
The new base opens in the table view. The table view is the central, but not the only view of SeaTable. In the table view you manage the tables of the base, you define their layout and you enter/analyse your data.
Before data entry, the table layout must be defined. The table layout determines which data or data types you can enter in the table, which view options you have and how the fields behave in web forms.
SeaTable offers a total of 17 column types. From traditional spreadsheet programmes you know text and date columns. Of course, SeaTable also knows these. In addition, SeaTable offers columns for storing files and formatted text as well as single and multiple selection fields. You want to store pictures for an entry? Just drag the picture into a picture column and SeaTable stores it directly in the table. In SeaTable you have all your data in one place!
Another column type that you are not familiar with from a spreadsheet is the link. With links you create relations between rows different tables. This procedure, which corresponds to the way relational database systems work, avoids double entries, ensures data consistency and creates an overview. Here is just one application example: A property management company records the managed objects in one table and links them to tenants who are managed in another table. If something changes in the object properties, the manager only has to change the adjustment in the object table. By linking, the changed information is automatically updated for all assigned tenants.
You can create further tables using the table tabs. Each table has its own individual layout. Design the columns according to your wishes and needs.