SeaTable 1.4: New options for data management and online collaboration

We are pleased to announce the release of SeaTable 1.4! We've included a new column type, improved database features, real-time chat, and many other improvements in this new release. Organizing data and working together as a team has never been easier or more convenient! And the best thing is: Every user benefits from the new features, including the free subscription.

For a full list of changes, visit the SeaTable Changelog. This release note summarizes the biggest and most exciting updates of SeaTable 1.4. So let’s get going!

Introducing column type #18

SeaTable 1.4 adds one more column type: The URL column. It is similar to the text column, but its contents are interpreted as links to network resources: https://seatable.io, www.seafile.com, 192.168.178.1 and localhost:8000 are all meaningful entries.

When saved in a URL column, a network resource is just two clicks away: Click on a cell and a link-icon appears on the right in the cell. Make another click on this icon and the resource is called in a new browser tab. http(s) gets automatically added as a prefix. If you are asking yourself why one click does not do the trick, here is the reason: Two clicks prevent accidental visits of the links’ target when navigating in a table, which might happen often especially on mobile devices.

More powerful, yet simpler database functions

Database afficionados will love the new wizard for linking records and the possibility to run queries across indirectly linked tables. SeaTable makes databases as simple as they should be!

Simplifying linking records

In version 1.3, selecting a linked record was a bit tedious. An in-cell dropdown displayed the content of the first column in the linked table – not ideal when there were two or more rows with the same content. In SeaTable 1.4: This problem is solved!

The dropdown has made way for a new, content-rich and context-dependent wizard. A double-click on a cell opens it up: For empty cells, the wizard lists all the records in the linked table including the content from the first few columns. Confusion about which record to choose is a thing of the past! When clicking on a cell with existing linked records, the window opens up with the details of the linked record. More records can be linked via the button “Add a new link” in the wizard’s top right corner.

New wizard for link to other records columns

The new wizard greatly facilitates the creation of links between tables, but that’s not all it can do. You can also create new records in the linked table right from the wizard. No need for switching tables. No awkward clicking sessions. No time lost. You basically work in two different tables from one.

Leveraging the full potential of database queries

Running queries across multiple tables is part of the magic of databases. While previous versions of SeaTable limited queries to directly linked fields, this restriction is no more with the newest release. As long as records are logically linked, SeaTable can walk down the link chain and retrieve the target value – no matter the number of tables it has to cross. The intuitive implementation in SeaTable ensures that not only database experts can benefit from the database magic.

Imagine managing your IT assets with SeaTable. In Table 1, you manage the users, Table 2 lists the rooms, and Table 3 lists the hardware. Each user has a 1:1 relationship with a room and a 1:n relationship with the IT assets. The user is therefore the link between the room and the asset. With SeaTable 1.4, creating a list of IT assets per room is a matter of a few clicks.

Chat with coworkers in real-time

Good communication within the team is key for efficient online collaboration. With the new real-time chat, SeaTable 1.4 introduces exactly what you need to stay in touch with your teammates! Bouncing off ideas, commenting on new data entries or discussing modifications – you can do it where it is easiest: right with the data.

Real-time chat in comments

If you don’t know the row comment feature yet, select a row and hit the SPACE key now to open the row details. In the top right corner, you find the comments panel. SeaTable’s new message backend goes to work right away and notifies users about your comment. If they are online, the group chat begins. Exchange your ideas and inspirations while they are fresh!

More automation with webhooks

What is better than SeaTable? SeaTable integrated with some of your other favorite applications! This is why it was important for us to put SeaTable on Zapier as quickly as possible.

But Zapier was only the first step. Webhooks introduced with this version are the second. SeaTables Webhooks makes it easy to trigger event-based actions in external applications. Here are two simple examples: A counter is incremented by one when a new entry is created or an email is sent when a value exceeds a critical threshold.

Python support for SeaTable scripts

Python support in SeaTable scripts

Last but not least, SeaTable 1.4 also has something in store for developers. This time, we have good news for all those fond of Python.

After adding JavaScript support in SeaTable 1.3, SeaTable 1.4 adds Python support to SeaTable scripts. Import your Python script or write it in SeaTable’s script editor to automate data processing and make SeaTable your custom application. To learn more about SeaTable scripts, read our SeaTable Scripts Programming Manual.

Spoiler alert: In one of the next releases, we’ll add time triggers for executing scripts.

Many other improvements

Not all of SeaTable’s team of roughly 30 work on the big new features individually mentioned above. A lot of resources also go into countless smaller, incremental improvements. Here just a few.

We have reorganized the navigation on the left in the base library. The new navigation is composed of two menu categories: The Workspace contains the bases, forms, and activities. Help and resources provide direct links to our growing set of templates as well as a direct link to the User’s Manual.

Talking about the activities menu: This menu itself has undergone a massive redesign. In the past, the activities listed off all actions in chronological order which became a bit unwieldy when user activity grew. The new activities menu maintains the chronological order, but groups the changes base by base and is much easier to navigate. A click on a base opens the details of all the changes on one day.

Small, impactful changes have also been brought upon the table view! When opening a base for the first time, its description will automatically push to the front. This is extremely helpful when sharing bases with others. Before diving into the data, they will be confronted with the instructions that you want them to read.

Feel inspired or interested? Allow us to remind you that registering is incredibly easy and SeaTable is permanently free of charge. If you have any questions or doubts, feel free to reach out to us via the SeaTable Forum.