Keyword archive for: Release Note

SeaTable 3.2: Interactive formula wizard and improved column types

Welcome SeaTable 3.2! In the new release SeaTable's column types are in the spotlight: The formula column wizard is now interactive and offers significantly improved error correction. Buttons in the column type of the same name now allow to perform multiple actions with one click. New functions in the file column simplify the management of files and the selection columns also offer more convenient use. But not only the column types have benefited. Enterprise users in particular can look forward to improved automations.

Since this morning the latest version is running on SeaTable Cloud. So if you want, you can try out and use the new features now. In the coming days, we will also make the corresponding Docker image available to self-hosters via the well-known Docker repository.

Interactive formula wizard

The Formula Wizard previously offered little guidance when creating complex formulas. With the new formula wizard, even interconnected formulas with various column references and multiple functions can be created quickly. It provides interactive support during input and, if something does go wrong, offers meaningful error messages for quick troubleshooting.

Seatable's interactive formula wizard

Where previously there was only gray text, there is now a clear color language: formulas are displayed in blue font, column references are purple, numbers are green and text appears in red. Brackets - round as well as curly ones - are automatically closed when typing and a fine shadow marks connected brackets. Single and double quotation marks for plain text are also automatically doubled to speed up typing. Of course, the new wizard works not only for new formulas, but also for existing ones.

Versatile button

SeaTable's button can now execute two actions with one click

Until now, the rule was "1 button - 1 action". This rule goes overboard with SeaTable 3.2. The new rule is "1 button - you choose the number of actions". For example, in SeaTable 3.2 you create a PDF document with the page design plugin with one click and then send it by email. Also, the row can be locked afterwards or cell values can be changed automatically (e.g. a status change). The available actions can be combined in any way. Existing buttons can, of course, also be assigned additional actions, making tables leaner and simpler.

Also new in SeaTable 3.2 is the execution of data processing options via a button. The specification of the operation is done in the menu of data processing operations itself, then in the configuration of the button the existing data processing operation is simply selected.

And individual operations have been improved as well! The previously static subject line in the "Send e-mail" action now shows its dynamic side. Like the other fields for quite some time, the subject line now supports referencing of columns in the format {column name}. This way, an ID, a project name, a user or a status from the row can easily be inserted in the email subject. All columns referenced in the "Send Email" action, be it in the "Subject", "Send to", "Send copy to" or even "Reply to (optional)" as well as the message itself, can also be hidden. The e-mail dispatch works nevertheless.

Even with these improvements, the column type button remains in active development. We still have many ideas that we will implement in the coming months.

Convenient file management

In SeaTable 3.2 a new element decorates selected cells in columns of type File and Image. A click on the double arrow opens a pop-up that shows the files of the cell in a list view. Previously, this required a click in the white space between the file icons - not infrequently a ticklish endeavor. We have also improved the file pop-up itself. The 3-dot icon for the advanced functions can now be used to rename files. Previously, this required a download and re-upload.

Updated file column in SeaTable 3.2

Another new feature is the ability to convert image columns to file columns without losing the cell contents. This is especially relevant if you want to use the former for e-mail attachments. The action "Send e-mail" currently supports only the column type File. (The lossless conversion only works if the images are stored in SeaTable. It does not work for images that are embedded via a link).

More convenient selection columns

Options in single and multiple selection columns that contain a longer string are displayed abbreviated in the table view. To display the string in its entirety, SeaTable 3.2 now provides a tooltip. Drag the mouse on the option in the table view and the text of the option appears in full length - an effect that has existed in the rows file view for some time.

The use of single select fields in the page design plugin previously suffered from the static size of the bubble. Consequently, a responsive design required the surrounding text to be adjusted. This limitation is also a thing of the past with the new SeaTable version. With the update of the page design plugin, single-selection options can now be displayed as plain text whose font size, weight and color can be customized as desired.

More powerful automations

SeaTable 3.2 supports pausing an automation

The possibilities for managing automations are extended in SeaTable 3.2 in two places. First, warnings are now also displayed in the automation execution log. For example, a warning is logged if an automation rule applies to a large number of rows and triggers a correspondingly large number of actions. Warnings are thus used to provide indications of problems in the configuration of an automation. The possibility to pause an automation is the second added feature in SeaTable 3.2. A click on the corresponding icon stops the execution of the automation until further notice. A corresponding hint marks paused automations.

Of course, the automatically executed action "Send e-mail" must not be inferior to the action of the same name triggered by a button. Therefore, automatically sent e-mails in SeaTable 3.2 now also support file attachments and column references for the subject line.

Furthermore, the possibility to send messages and e-mails conditionally periodically was eagerly awaited by some users. In this way, for example, specific groups of people can be contacted automatically on a monthly basis. Use cases are the renewal of subscriptions/memberships, reminders of documentation requirements or the assignment of recurring tasks.

And much more

Of course, we cannot present all the new features in detail in these release notes without going into excessive detail. The complete list of changes can be found in the changelog. In this last section, we present other new features very briefly:

This version catches up for sorting and grouping what filters have already allowed for some time: changing their order. More extensive filtering, sorting and grouping rules can thus be effortlessly adapted afterwards to changing requirements.

Shared datasets now also support hourly synchronization. Automatic synchronization was only possible daily up to and including SeaTable 3.1.

A new data processing operation 'Transfer user name' reads a column of the type creator, last editor or employee and copies the name of the referenced user into a text column. If two or more users are named in an employee column, then these are inserted comma-separated in the text column.

When a new column is added to a table, SeaTable checks if there are hidden columns in other views. If this is the case, then the newly created column will be hidden in these views as well.

In addition to the improved display of single-selection fields, the page design gets another improvement: Multiple elements can now be aligned collectively, as known from PowerPoint, for example.
Multiple elements can be aligned in SeaTable 3.2's page design plugin

Last but not least, the Timeline plugin is happy about an improvement: Groupings in a view can now also be displayed in the plugin. Specifically: The entries in a grouping are displayed separated from each other by swimlanes.

SeaTable 3.1: Enhanced Page Design Plugin and New Big Data Backend

We are happy to introduce the latest version of SeaTable! The release is only a "minor" release, but it does not present itself minor at all. The enhanced page design plugin now offers more options to design and manage templates. New features also allow for completely new use cases. The big data backend, which is now ready for production, does the same. The enterprise feature eliminates SeaTable's previous limit of 100,000 rows per base, making SeaTable ready for larger tasks. Larger teams will appreciate the newly added group sorting on the homepage and the view folders within bases. These highlights and a few other new features are presented here. The changelog contains the complete list of changes.

The new features are now available on SeaTable Cloud. The latest build of SeaTable 3.1 was installed this morning. Self-hosters can download SeaTable 3.1 from the well-known Docker repository.

Faster, More Beautiful Lists and Documents

Being packed with new functions, the page design plugin almost merits release notes of its own. What's new? A list print function, new dynamic fields including page header and footer, as well as a version history for every template. Not surprisingly, the sidebar has become considerably more button-rich in the edit mode (see image below) as a result. Last but not least, the templates in the plugin can now also be moved and sorted in the overview. But now everything in order.

List print feature in SeaTable's Page Design plugin

The new list print function puts the contents of a view on paper or in a PDF document in no time with an attractive design. Simply drag the "All records in view" element onto the template, resize the placeholder, format the table according to your preferences, and add the remaining page elements such as document title, logo and date. SeaTable then automatically takes care of the table layout and page breaks. If the rows of the selected view do not fit into the placeholder, SeaTable adds as many pages as necessary.

The dynamic fields introduced in this new release make it super easy to insert contextual information on a page. Specifically, the current date, the template used, the current user, and the page number can be added to a page with them. In terms of usage, dynamic fields are no different from static text fields. Simply drag the field onto the templates, position it correctly, and format it - SeaTable takes care of the rest.

Page header in SeaTable's Page Design plugin

The new page header and footers are an ideal complement for the dynamic elements. Elements placed in either get repeated on every page of the template, of course including the pages that the plugin automatically adds when printing lists. Page headers and footers are not reserved exclusively for dynamic elements. The two fields static text and static image can also be embedded to provide documents with meaningful meta information.

When trying out all these new features, you may happen to mess up your template leaving you wanting to restore the template's previous state. In this case, the page design's new versioning function is there for you. Every time you save the template, the plugin creates a snapshot that you can jump back to. If you don't like the changes made to your template, you can undo them with one click. When restoring a previous version, the current template is replaced by the previous version. Of course, SeaTable retains all other versions when restoring a snapshot, so no changes get lost.

Feel like checking out the new page design plugin? Go for it! The improvements are available in all SeaTable Cloud subscriptions as well as in SeaTable Server Developer and Enterprise Edition.

Goodby row limit (Enterprise subscribers only)

If SeaTable's row limit of 100,000 rows per base has concerned you in the past, you now have one less thing to worry about! The new big data backend enables the storage of millions of rows in a SeaTable base. Not only does this place SeaTable way ahead of its immediate competitors, but it also pushes SeaTable into regions previously reserved for classic SQL databases. If you are looking for a database with REST API, built-in scripting support, automations and/or graphical frontend with real-time collaboration, look no further.

Big data backend in action

The previous size limit was necessary because SeaTable loads a base completely into memory when it is opened. This is a technical precondition for SeaTable's real time, online collaboration. With the activation of SeaTable's big data backend, this is no longer the case. When enabled, a base divides its data into two tiers: Records that are loaded automatically when a base is opened and records that are loaded only when explicitly called. This is the case, for example, when filtering or performing statistical analyses over the entire data set. When using only the automatically loaded data, the base's loading time and memory usage is unaffected even by millions of records in the big data storage.

"Tiering" a base's data entails enormous additional flexibility. Collaborative projects where team members work together in the web interface can be implemented just as much as data-intensive applications with automated data collection. Since the big data storage does not support online collaboration, i.e., changes to data are not pushed to other users but are only visible after they are retrieved again, this storage is particularly suitable for datasets on which there is no active work. This is the reason why, in SeaTable 2.3, the beta of the big data feature was presented as archive function.

Big data view in SeaTable 3.1

The big data backend supports all column types. Rows can be modified and deleted, filtered and grouped. Records can also be moved back and forth between normal and big data storage. On the other hand, the editing options for records in the big data storage lag those in normal storage for technical reasons. Restrictions exist especially for sharing, automations and plugins: Views that include data from the big data backend cannot be shared. Also, only the statistics plugin can handle data sets in the big data storage. All other plugins and also automations can only operate on normal views. Big data records cannot be linked either. If this is required, then they must first be moved back to normal storage.

 Normal viewBig Data View
Collaborative work
Support for all plugins
Support for all column types
Sorting
Filtering
Grouping#
Hide
Conditional formatting
Search
Search and replace
Data processing
Export to Excel
Export to DTABLE

# This function will be available from SeaTable 3.2.

The big data feature must be enabled in a base via its settings. The "Archive view" action moves the rows in the current view from the normal to the big data storage. The new big data views show the contents in the big data storage. In addition to the records in the normal storage, they also load some data from the big data storage. Specifically, when opening a big data view, SeaTable initially loads a mere 1,000 rows from the big data storage. These can be identified in the table editor by the gray triangle in the row number column. Scrolling beyond the end of the table or clicking "Load all" in the status bar prompts SeaTable to load more rows from the big data storage. Using the context menu, big data rows can be moved back to the normal storage.

Better Management of Large Teams

For large teams with many users, the interface can get a bit messy. In bases, many views compete for attention. On the homepage, dozens of groups with just as many bases make it hard to focus.

View folder newly introduced in SeaTable 3.1

In bases, the new version now allows you to group views into folders for greater ease-of-use. A folder is created the same way you create a view. You can then drag and drop views into the newly created folder. When creating the first folder, another folder "More views" is created which is the default folder for all existing views.

For more clarity to the homepage, groups can now be sorted in a custom order. Next to the group name in the navigation on the left, you will see the move icon already known from views. Use it to move important groups to the top and those you rarely use to the bottom. This way you have faster access to the bases that are really important. A function to minimize groups will be added in the future.

And much more

Today's update includes even more improvements and new features, which we will only briefly describe below.

Buttons in the column type of the same name now support the sending of emails with attachments. Also, all required modifications in the backend to send formatted emails have been concluded. The option to send rich text emails will become available in one of the next releases.

Until recently, formatted text was the only column type that could not be filtered (apart from the button column type). With the empty / not-empty filter now introduced, this shortcoming is eliminated.

The calendar plugin now opens in full screen mode - like the other plugins - and thus offers a lot more screen space.

We also took another look at SeaTable's import and export functions with the objective to improve the reliability of SeaTable's Excel import. We have also included external apps in the DTABLE export, eliminating the need for manual rework when migrating bases.

Looking at the changelog, it is also noticeable that a lot of work is being put into the Universal App and the Workflow module. These will be released soon. Stay tuned!

SeaTable 3.0: Data Validation, Office Web Editors and New Storage Backend

SeaTable 3.0 is here! The third major release of SeaTable offers online editing of Office documents, automatic data validation, more functions for shared data sets and a new server component for more efficient storage of bases. As always, the changelog provides information about the many other detailed improvements and bug fixes in the new version. The new functions are available immediately for SeaTable Cloud users. The image for SeaTable 3.0 was made available tonight on Docker Hub.
In addition to the functional improvements in the SeaTable app, there is another new feature for SeaTable Cloud users: A new team management with extended functions and improved design makes the management of small and especially larger teams much easier. You can find out more about the new team management in the article The new team management.

Automatic data validation

Strings of any type and length can be entered in text columns and thus offer great flexibility. Single and multiple selection columns are ideal for structuring data because of their predefined values. The new data validation function allows the advantages of text columns to be combined with those of selection columns.

If data validation is activated, SeaTable checks whether the entered cell value corresponds to the defined target format. If the input does not correspond to the target format, the cell is highlighted in red. In web forms, a non-compliant entry will result in an error message and the form cannot be submitted.

Data validation in SeaTable 3.0

Das Zielformat wird in Form eines regulären Ausdrucks definiert. Ein regulärer Ausdruck für eine Zahlenfolge mit genau 5 Stellen ist beispielsweise [0-9]{5}. Für reguläre Ausdrücke sprechen zwei Argumente: Sie sind eine weit verbreitete Methode und bieten ein Maximum an Flexibilität. Die Art der erlaubten Zeichen, die Länge, und auch die Syntax der Eingabe lässt sich mit regulären Ausdrücken präzise definieren.

Data validation is available in text columns in version 3.0. If a target format is added subsequently, all existing entries are also checked and the non-compliant values are marked as such. So nothing stands in the way of subsequently activating data validation in existing columns.

Online editing of Office documents

SeaTable makes team collaboration interactive. A Base is shared with a few clicks and entries in a shared Base are immediately displayed to other users. Office files in a SeaTable Base are different. To edit the Word document, Excel spreadsheet or PowerPoint presentation, it must be downloaded first. The editing is then done offline. For other users, the changed document version is only available after the manual upload. This was a thorn in our side.

SeaTable 3.0 extends the real-time collaboration known from the table editor to Office documents. Documents can be edited directly in the browser and with several people at the same time. The co-authors' changes are displayed in real time, so you know exactly who is working on the document and where. Manual uploading is also no longer necessary. When the last user leaves the document, the current document status is automatically transferred back to SeaTable and stored in the file column as a new document version.

Editing an Office document from SeaTable could not be easier: A click on the Word, Excel or PowerPoint file opens the document in an editor in a new tab. Users who are currently editing the document are displayed in the upper right corner. Changes made by these users are executed directly in the displayed document and are indicated by a flag. Saving takes place automatically.

The editors used for online editing are from ONLYOFFICE. The editors of the ONLYOFFICE document server are characterised by a modern user interface and very good compatibility with Microsoft file formats. In addition, the document server, like SeaTable, can be self-hosted.

Online editing is available in all SeaTable Cloud subscriptions, including the free subscription. For on-premises operation of SeaTable, the ONLYOFFICE document server must be installed and configured. The setup instructions can be found in the SeaTable Manual.

Improved synchronisation of bases

The Shared Records function allows you to synchronise data from one Base to one or more other Bases. They are particularly useful if you want to make data available to other users for further processing and enrichment, but you cannot give these users access rights to the list you manage ("master list"). Version 3.0 includes several improvements to simplify the creation, synchronisation and duplication of shared records.

Existing common datasets are displayed in the "New common dataset" dialogue box.

From SeaTable 3.0 onwards, common data sets that have already been created are displayed in the "New common data set" dialogue. This avoids the multiple creation of common data sets.

In the new version, columns created by importing a common record are marked with a sync icon. This makes it easy to distinguish the columns that will be overwritten with the common data set during a re-sync from all other columns. The visual marking reduces the risk of unintentional data loss.

Columns imported from CDS marked with sync icon

When duplicating a table with an imported common data set, only the data was duplicated until now. The link to the common data set was not given in the duplicated table, so that no renewed sync was possible. The duplication function has now been extended so that you can either transfer the link to the common data set to the new table to be created or discard it via a switch.

Higher storage efficiency

The new SeaTable Server component dtable-storage-server will significantly reduce the storage requirements for storing bases, snapshots and backups of archived rows . The seaf-server component, which was previously responsible for this, will continue to play an important but reduced role.

Technically, the dtable-storage-server is a simple abstraction layer for different storage backends. As before, local storage and S3 object storage are supported. SeaTable thus offers attractive storage options for small, simple systems as well as for highly scalable setups.

With newly installed SeaTable servers, bases are automatically stored in the dtable-storage-server. Only the storage of images and files is still done by the seaf-server. The situation is different for existing systems. When upgrading a SeaTable Server 2.x, the dtable-storage-server is not automatically installed and configured. This has to be done manually; the procedure is described in the SeaTable manual. A migration of the existing bases into the dtable-storage-server is recommended. For a small number of bases, the export into a DTABLE file and the re-import into a new base is the simplest procedure. With a larger number of bases, this process can also be automated via the API. However, migration is not necessary. SeaTable 3.0 can continue to load bases from the seaf-server.

More improvements

In addition, there are numerous other improvements, the three most important of which we present here very briefly.

The menu structure in the Base header has been expanded and revised. The most obvious change is the avatar, which is now displayed at the top right, analogous to the homepage. In order to make room for the avatar, the three-dot button has been moved down one row . The menu behind this button has been revised. In keeping with their importance, the notification and automation rules, for example, have been removed from this menu. They now have their own icon in the upper right corner.

DTABLE files, export files of bases, now also contain automation rules. The same applies to copying a base to another group. This saves unnecessary manual rework when transferring bases between groups and SeaTable servers.

The title column can now be selected in the Kanban plugin. The value of the title columns is at the top of the Kanban card, regardless of the sequence of the columns in the table.

SeaTable 2.8: More colour, more comfort and more automation

Early builds of SeaTable 2.8 have been available for download from Docker Hub for a few days now. The final build has been available for download since April 1. With today's update to SeaTable 2.8, we are pleased to make its many new features and improvements available in SeaTable Cloud as well. New features include a color-customizable title band and display of all active users in a base, column descriptions, and an improved formatted text editor. In addition, shared records can now be automatically synchronized and renamed. And these are just the highlights, which we present in more detail in these release notes. The complete list of changes can be found - as always - in the changelog.

Coloured title ribbon

The colour and shape of the base icons on the homepage can already be adapted to individual wishes since version 1.2. However, the icon colour had no effect on the colour of the title band in Base. The title band remained orange.

In the new version we have eliminated this functional gap. The colour of the title band is now based on the colour of the base icon. You think the bright blue from the screenshot is chic? Well, go for it!

Base ribbon in custom colour

Transparent collaboration

Every change you make in a SeaTable Base is immediately transmitted to all active users in the Base. As soon as you confirm an entry, your co-editors see the change on the screen. We call this real-time collaboration.

But who are the other users who are active in Base? SeaTable 2.8 provides a clear answer to this question. A click on the user icon at the top right of the table editor opens the list of current users. When a user is added to a table or a colleague stops working, the list is updated immediately. Real-time collaboration!

Active co-editors in table

Simple description of columns

If you work together on tables in a team, then fill-in instructions prevent the incorrect entry of data: What should be entered in a column? In which unit should the data be recorded? How should categories be interpreted? Who can answer queries?

Column descriptions available beginning with SeaTable 2.8

The column descriptions introduced in SeaTable 2.8 are intended for exactly this kind of information. In the table descriptions, additional information can be entered that does not fit into the column heading or should be contained there. If a description is entered for a column, an info icon is displayed in the column header. Moving the mouse over it displays the description in full length.

Formatted help text in web forms

Help texts in web forms have the same motivation as column descriptions: They allow a more precise and frustration-free processing of the forms. In addition, information obligations (keyword DSGVO) can be fulfilled in them.

New in SeaTable 2.8 is the possibility to format the help texts and to insert pictures and tables. This makes it possible to present longer texts more clearly or to replace many words with a few images. The help texts are edited via SeaTable's revised editor for formatted text.

Convenient editor for formatted text

The editor for formatted text is not only used in web forms. It is also used in columns with formatted text and in descriptions for bases. With the version change, the editor has undergone three improvements:

Tables can be inserted in the desired dimensions in no time thanks to a new wizard. This opens with a click on the "Insert table" button. Now drag the table to the desired dimension and click again. The table with the selected proportions is then inserted at the cursor position. Until now, SeaTable always inserted new tables as 2×2 tables, which then required clicks and manual addition of further rowsand columns.
New wizard for new tables of custom dimensions

Navigation in tables is also easier from now on. As of SeaTable 2.8, the editor supports navigation with TAB and SHIFT + TAB. According to the general convention, the cursor jumps to the next cell with TAB; SHIFT + TAB lets the editor jump to the previous cell.

Finally, the editor in SeaTable 2.8 also offers a better image preview. For one thing, you can now scroll through all the images embedded in the formatted text in the preview. Secondly, you can now easily increase and decrease the zoom factor in the preview.

Automatic synchronisation of shared data sets

A shared record is a view of a table that is released for one or more groups with read rights. Authorised groups can import the data set into their own bases. This gives them access to the data in the dataset without the sharing group losing sovereignty over its data.

Automatic sync of common datassets

Until now, the data in an imported common data set could only be updated manually. In the current version, the synchronisation of the data can optionally also take place automatically. If automatic synchronisation is active, the data set is updated every 24 hours after the last sync run. If the data in the source table has changed, then these changes are transferred to the imported table by the synchronisation.

More improvements

There are numerous other improvements that deserve a mention. Here are the most important of them.

The formula column knows two new formulas: Small() and Large() find the x-smallest or x-largest value in a column. (More in the formula reference.)

For columns and groupings, the median can now be calculated in addition to the sum, the average and the extreme values.

In the page design plug-in, the font size in tables for linked rowscan be adjusted. The line break in such tables has also been improved.

In addition to the decimal places and the currency symbol, the position of the latter can now be freely determined in a user-defined currency column.
Custom currency symbol and position

SeaTable 2.7: Conditional cell formatting, flexible column fixing and practical date default value

This morning, SeaTable Cloud was updated to version 2.7. This means that all Cloud users can now also enjoy the new functions and improvements of the new version, which has already been available for download for self-hosters on Docker Hub for a few days. The table editor benefited most from the version change: the conditional cell formatting, the new data processing operation "Calculate Ranking", the extended column fixing and the default value function for date columns offer a lot of new functionality. Outside the table editor, the password-protected bases are an important improvement. All changes can be found - as always - in the SeaTable changelog.

Conditional formatting for columns

Anyone who works regularly with Excel knows the conditional formatting function. With version 2.7, this function is now also available in SeaTable. With conditional formatting, you format or colour cells depending on their value (or the absence of such a value) and can thus carry out visual data structuring and data analysis.

For all columns, SeaTable offers rule-based conditional formatting. A rule is the description of a hypothetical content of a cell (e.g. value > 50 or date after 31.12.2021) and a formatting instruction. If the rule is fulfilled, the cell is formatted according to the instruction. Cleverly chosen rules can, among other things, make statistical outliers or unusual values easily recognisable. Of course, you can also define several rules per column to map demanding requirements.

Conditional cell formatting

If a column has numerical cell values, SeaTable offers formatting by values in addition to rule-based formatting. This conditional formatting colours the cells with a colour gradient. Large values are coloured with the upper end of the gradient, small values with the lower end. This makes the magnitude of a cell value clear at a glance.

Sequence of values

If you not only want to display the order of magnitude of the cell values in a column, but also need the ranking of the values, then the new data processing operation Calculate ranking is exactly what you need! It calculates the ranking and writes the result in a separate column. The largest value gets the ranking 1. If two or more cell values have the same amount, then all cells get the same ranking and one or more subsequent ranking positions are skipped. The operation works for columns with numeric contents, but also for the column types date, duration and rating.

Freezing columns

In tables with many columns, there is often the problem that the first columns disappear from the display when scrolling to the right. Until now, the first column could be fixed and thus permanently displayed even in large tables. This function shows a more flexible side in the new release: Starting with version 2.7, additional columns can be fixed on the left. This way, even when navigating in large tables, you know which entry you are in.

To fix several columns, simply use the mouse: Move the mouse pointer to the vertical line separating the row numbering from the first column. Now drag the mouse to the right to set the number of fixed columns. If you want to remove the column fixation, move the mouse pointer to the frame between the last fixed column and its following column and drag the line all the way back to the left.

Default values for the date column

Default value function for date columns

Repeatedly requested, now fulfilled: After the text, number and single-selection columns, SeaTable 2.7 also gives the date column a standard value function. With it, you automatically add a static or dynamic date value to new entries.

The SeaTable 2.7 release date, 2 February 2022, is an example of a static date value. Dynamic date values establish a relative reference and change over time. In addition to the current date ("Today"), x days before or after the current date is also a dynamic date value. Both can now be mapped in the date column with the standard value function. In combination with the date functions of the formula column, virtually any date values can thus be automatically generated for new entries, which in turn can be used for automations.

Password-protected bases

For bases with confidential data, many customers want advanced access protection. SeaTable 2.7 now offers such a protection with the optional password protection for bases. Only after entering the password the base is accessed and the data is displayed. The password protection can be set up and removed by owners for their own bases as well as by group administrators for bases of the group.

Password-protected bases can be shared with other users. Of course, they must also enter the password when calling up the base. The same applies when copying a password-protected base. The additional access protection does not come at the price of reduced flexibility.

... and much more

Like most new versions, SeaTable 2.7 contains more features worth mentioning than can fit in these release notes. Therefore, here is an overview of further improvements:

When linking entries, the link assistant in SeaTable 2.7 offers a better search function. When entering several search terms separated by spaces, SeaTable searches in all columns of the linked table. Specifically: If you are looking for a certain entry on a certain date, simply enter the date and, separated by spaces, another property of the entry you are looking for. The assistant then only displays the corresponding entries and you are spared a lot of manual search work. Until now, SeaTable searched for the entry as a whole in a column.

Web forms can now be embellished with a cover image or color scheme. Together with a faded-in logo, you can build handsome and customized forms. (This feature is reserved for Enterprise subscribers).

Team administrators can now enforce 2-factor authentication for their team members and also deactivate it individually. The team administrator can thus react individually to increased security requirements and more easily defuse situations in which users have lost their second factor.

Until now, links from deleted and then restored rows remained lost. With version 2.7, links are also created again when a row is restored.

The archive function introduced with version 2.3 has taken further steps towards productive use: entries can now be deleted from the archive and entries can also be edited. (Links, however, cannot yet be created or changed).

SeaTable 2.5: Optimizing archive, data processing, and automations

SeaTable 2.5 is out now! The new Docker image was uploaded to Docker Hub at the end of last week and SeaTable Cloud was updated this morning. The new release makes numerous SeaTable features even better! The maturing archive function lends itself to more and more use cases, the data processing operations become more flexible, the integrated automations and the rating column offer more options. Last but not least, link and link formula columns are now fully supported in external links for views. Read on, if you want to know more. For a complete list of changes, have a look at the SeaTable Changelog.

Upgraded archive function

Introduced in SeaTable 2.3 as a beta function, our developers have been working tirelessly to push the archive function towards production-readiness. Although we are not quite there yet, SeaTable 2.5 makes great strides in this direction!

The archive function now supports all 24 columns, including the three column types formula, link and formula for link. The lack of write access to the archive data remains a limitation in SeaTable 2.5, but these three columns are special cases: Values in the two formula columns are calculated dynamically, depending on the specification of the formula. If a formula is changed, then the values in the archived rows are recalculated. If the user changes the look-up column in a formula for links, the archive data reflects this change. The same applies to the link column. A change in the display column is made equally in the entire dataset, archive included. In this way, the archived data remains comparable with the non-archived data.

The revised archive view of SeaTable

SeaTable 2.5 also adds a print function for archive views and supports hiding columns. A search function as well as an export to Excel function were already implemented in SeaTable 2.4.

Optimized data processing operations

SeaTable's data processing operations are often needed for migrating Excel applications to SeaTable. In SeaTable 2.5 two operations have been improved.

The Compare and Link operation automatically creates links between similar rows in two tables. With it, the conversion of Excel tables into a relational database is done in no time. New in SeaTable 2.5 is the support of all important column types (incl. single selection columns) for the definition of the compare rule. In addition, the operation now also offers more flexibility in the event that the tables are already double-linked. In this case, the user is prompted to select the columns in which the links are to be added via a drop-down menu.

The Calculate Cumulative Values operation calculates totals across rows for columns of numeric data - a standard function in Excel. The operation has been available since the introduction of the data processing function in SeaTable 2.1, but has now been adapted based on user feedback. Specifically, the handling of the very first column was criticised. Now after the revision, the operation sums exclusively via the source column and writes the results to the result column.

New automation actions and triggers

SeaTable now supports four process automation platforms:
Automation has been a key focus over the past weeks and months. We are proud to announce that SeaTable is now available on four integration platforms: In addition to Zapier, on which SeaTable has already been present since the beginning of 2021, sophisticated workflows can now also be built with Integromat, n8n and Locoia.

With all the attention on external integrations, we have not lost sight of SeaTable's own automations. The central innovation is the Run Python Script action. It can be triggered by the triggers "New row", "Entries fulfil a certain condition after the change" and "Execute periodically". The automated execution of Python scripts for a single row or an entire data set using a clear set of rules is almost a superpower!

Python scripts can now be started via automation.

The existing action "lock record" was also upgraded by adding the new trigger condition "Run periodically on records that meet specific conditions". In combination with the other two trigger conditions "Record added" and "Record meets specific conditions after modification", the user now has detailed control over the automated locking of rows.

Finally, because scheduled executions need to be tested, the two scheduled execution events, "Run periodically" and "Run periodically on records that meet specific conditions", obtained a manual execution option "Run now".

More options for the rating column

We all love a wide choice! The new rating column fulfils exactly this longing for "more". In SeaTable, the rating column now offers four styles. In addition to the star as the standard icon, you can now also choose the heart, the thumbs-up or the flag as an icon. Also, the icon no longer has to be orange.

The new rating column in SeaTable 2.5

But the improved rating column is not only about choice, it's also about convenience: SeaTable now automatically calculates summary values at the bottom of the table - min, max, average, and sum. In grouped views, SeaTable computes the summary for each group too.

Using the rating column on mobile devices has become easier and more convenient too. Users can now add rating columns on their mobile phones. In previous versions, SeaTable did not show any reaction when trying to do that. Additionally, the rating icons were enlarged to make their use on small screens more comfortable.

Another improvement of the rating column under development unfortunately didn't make it into this release. So here the announcement: Beginning with SeaTable 2.6, the rating column will have a default value option.

More improvements

The new function countitems counts the elements in column types that can contain multiple values. These include the column types file, image, staff and multiple selection. It is the counterpart to the "countlinks" function for non-linked elements.

The Excel export and import function has been revised in several places. Exporting formula columns now works smoothly with SeaTable 2.5, even if columns used in the formula are hidden. Another new feature is that new data can be imported from both CSV and XLSX files and that new tables can be created from XLSX files. Users transferring data from SeaTable to Excel will be pleased to hear that the export routine now handles multiple selection fields correctly.

The settings of the gallery plugin have been extended by a setting option. The button "Show column names" can be used to show or hide the headings above the column values. Even if this is not necessary in many cases, it prevents confusion in cases where columns of the same type are directly below each other.

SeaTable 2.4: Improved display options for faster work

SeaTable 2.4 has seen the light of day! The latest incarnation of the SeaTable Server was uploaded to Docker Hub at the end of last week and SeaTable Cloud was updated this morning. The new version offers a number of improvements and new features: View navigation is now dockable, the Link to Other Entries column type offers enhanced settings, a new and improved data processing operation make quantitative analysis easier. In addition, a new conditional formatting offers help with large data sets. And these are just the features that stand out from the crowd. SeaTable 2.4 also offers much more. You will find the most important information about the new release in these release notes. You will find the complete list of changes - as always in the changelog.

Dockable view navigation

Views provide unique perspectives on the data in a SeaTable table and are fantastic tools for data analysis. But, according to user feedback, switching between views is unnecessarily complicated.

Pinnable view navigation

With SeaTable 2.4 we introduce dockable view navigation, which makes selecting and switching between views as easy as navigating folders in a file manager à la Windows Explorer or the Finder on the Mac. With the navigation docked, the list of views is expanded across the full left side of the table editor, making the views directly available for selection. To accommodate different needs, the width of the docked navigation can be set individually according to requirements. If you have to switch between views frequently, this innovation will save you a lot of clicking and mouse work.

Linking to other entries much more flexible

The column type Link to other entries is probably SeaTable's most important. SeaTable is not just another online spreadsheet! Like no other column type, this column type stands for that. And in SeaTable 2.4 we have made this column type even better.

More display options for link column

In previous SeaTable versions, the link always showed the value of the first column of the linked entry. From now on you can select which column value of the linked row should be shown. This selection is easily done via a dropdown menu in the link column configuration. What sounds small is of great importance! Imagine that the first column in the linked table is an autonumber column. These values are without relevant information for you, the display without significant meaning. In the new version you now choose a column that contains more meaningful information. This simplifies link creation and makes the table more compact with fewer lookup columns. Finally, the revised link column also makes web forms more powerful for polls and surveys. The selected display column is also the one that a visitor sees and can choose from in the web form. We are confident that you will be as excited about the new feature as we are.

Automatically highlight duplicates

You want to identify all duplicates in your table? With SeaTable 2.4 you now have not one but two ways to do this: you can use the data deduplication plugin or the new conditional formatting option "Highlight duplicates". This formatting option highlights all duplicate rows in the active table. By selecting the comparison columns, you can define exactly what constitutes a duplicate.

New conditional formatting option "Highlight duplicates

The big advantage of conditional formatting compared to the plugin is the fact that you do not leave the table editor. The duplicates are displayed where you can edit rows , delete rows as well as use filters and sorting. (The plugin remains the tool of choice if you want to automatically delete all duplicates).

More data processing operations

Data processing operations were introduced in SeaTable 2.1 and have been continuously improved since then. SeaTable 2.4 is no exception in this respect. SeaTable 2.4 offers a brand new data processing operation, "Calculate Percentage", and improves the existing "Compare and Concatenate" operation.

The operation "Calculate percentage" determines for each row in the active view the proportion of the column value to the column total. If the operation is performed for a grouped view, the percentage value refers to the column total of the group. Of course, once set up, the operation can be saved under a name for later reuse.

The improved operation "Compare and Link" now offers more control over the linking of entries. Previously, SeaTable created links between entries with identical values in a column. Starting with SeaTable 2.4, multiple pairs of columns can now be selected. A link is only created if the rows have identical values in all selected columns.

Countless detail improvements

Finally, a few more improvements that should not go unmentioned in these release notes:

SeaTable 2.4 extended the list of image file formats with preview function by the TIFF format. Now JPG/JGEG, PNG, GIF and TIFF image files can be viewed directly in SeaTable.

Because minimum, maximum, sum and average do not always represent meaningful sum values for columns, SeaTable now also offers an option "No calculation". If selected, SeaTable does not calculate any values, neither for the entire column nor for individual groups.

SeaTable renders the contents of a cell with formatted text directly in the table editor when the row height is set to quad.

Buttons have learned a new trick with version 2.4: With just one mouse click, SeaTable creates a PDF document with the page design plugin and saves it in a column of the type file.

SeaTable 2.2: Automation and Integration

SeaTable knows no summer break! We keep our monthly release cycle and so, beginning today, all SeaTable Cloud users benefit from the advantages of SeaTable 2.2. Automations and external apps are two new features introduced in this version. Other highlights of the new release include nested groups, cascading single select columns, as well as improved table permissions and data processing operations. These release notes describe all these new features. The much more comprehensive, complete list of changes can be found - as always - in the SeaTable changelog. On Docker Hub, SeaTable 2.2 - in both editions of SeaTable Server - will be available tomorrow.

Read more

SeaTable 2.1: table permissions and data processing

Today, 6 July 2021, we updated SeaTable Cloud to SeaTable 2.1 and uploaded the new Docker image to Docker Hub. The highlights of the release are the new table permissions and a new feature called Data Processing. In addition, we have improved the single and multiple selection column types and the checkbox column. In these release notes we present - as always - the key developments and refer to the SeaTable Changelog for the full list of changes.

Table permissions

SeaTable's advanced sharing (e.g. custom sharing permissions, column permissions, row locking) gives base administrators extensive control over who can view, edit and otherwise work with table data. With the new table permissions , administrators have an additional option to fine-tune access to tables.

SeaTable 2.1: Table permissions

table permissions control the access rights of users to a single table in a Base. In the default settings, they do not limit the editing rights of users, i.e. any user with at least write permissions can add rows as well as edit and delete existing rows . If the owner of a Base or an administrator wants to limit these permissions for individual users or groups, they can now do so with SeaTable 2.1. Permissions to add files or delete files can be revoked from all or any non-admin users. Or they can be assigned exclusively to a selection of users. The permission to add and delete can be managed individually and independently.

In future versions, more options will be added for even more granular access control. In SeaTable 2.2, base administrators will be given the option to restrict editing of rows .

Data processing

With the more than 80 formulas that SeaTable offers, a wide range of calculations and operations can be carried out. However, all SeaTable formulas are subject to one limitation: they only ever take into account data from one row. The new Data Processing function provides an answer to this limitation: it offers actions to perform calculations between rows in a table and between columns of different tables.

SeaTable 2.1 offers three data processing operations:

  • Calculate cumulative values sums up the cell values of a column from row 1 to the current row .
  • Calculate changes calculates the difference between the numbers in two consecutive rows.
  • Compare and copy checks entries in two tables for equality and, if a match is found, transfers one or more values from one table to the other.

Other data processing actions, such as calculating the order or automatically linking entries, will be added in future versions to simplify the processing of ever larger data sets. A memory option for recurring data processing actions will also be available.

Extended permissions for single and multiple selection columns

SeaTable 2.1: Advanced permissions for single and multiple select columns

The column permissions, which were introduced in SeaTable 1.2, allow the assignment and control of individual editing rights for individual columns. With SeaTable 2.1, the column authorisation menu of the two column types single selection and multiple selection was extended by a second button. This allows you to control which users may create and edit options in a selection column.

Basically, all users with write permissions can edit options. Owners and admins of bases can now restrict this permission. The editing right can be restricted to nobody, administrators or certain users. In the setting Nobody, not even administrators and owners themselves can create and change new options (but they can change the permission).

Improved checkbox column

The checkbox column type was somewhat unwieldy in daily use. Probably the most obvious convenience killer was the need for two clicks to check or uncheck a box - one to select the cell, another to check or uncheck the box. The new checkbox column is a huge step forward in usability and appearance.

SeaTable 2.1: Improved checkbox column

Numerous detail improvements

In addition to the major improvements presented, we have also taken care of a large number of smaller improvements, thus eliminating functional deficits and increasing user-friendliness. Here are just the most important ones in cursory form:

New print setting: The new scaling option in the print settings is a convenient way to resize the print output while maintaining the relative column widths. It is particularly useful when the screen view is to be scaled to fit a page.

Date widget for filters: A small widget for selecting the date in the filter settings makes date entry mouse-friendly. The widget also ensures that the date is entered in the correct format.

Group management: Group members can now decide themselves to leave a group. In the past, the group owner had to dismiss group members from the group.

Collective form: As for web forms as their classic counterparts, an expiry date can now also be set for collective forms. If this date expires, then the release link of the collective form automatically becomes invalid.

Excel Import: Importing multiple selections from Excel into SeaTable is now much easier in SeaTable 2.1. Cell contents separated by line breaks are interpreted as different options when inserted into SeaTable.

Improved wizard for link columns: If the selection in a link column is restricted to a view, then the wizard only shows the columns that are part of the linked view. Columns that are hidden in the view are also hidden in the wizard.

View locking: Base administrators now have the option to revoke the right to lock/unlock views from other users.

SeaTable 2.0: Three new column types, new and improved plugins and Russian as user language

On July 1, 2020, SeaTable 1.0 saw the light of day. Since then, it has been pulled from Docker Hub over 100.000 times. This overwhelming interest in SeaTable has pushed us ahead, and we are happy to announce a major milestone in the development of SeaTable: We rolled out SeaTable 2.0 on SeaTable Cloud and published it on Docker Hub for private installations.

At first glance, SeaTable 2.0 has a striking resemblance with SeaTable 1.0. In terms of features, user experience, stability, and integration, however, SeaTable 2.0 has come a long way from version 1.0 in July 2020. If you liked SeaTable 1.x, you'll love our latest release.

SeaTable 2.0 boasts an enormous number of feature additions and improvements - all of which you find documented in SeaTable's SeaTable Changelog. Highlights of this release are three new column types, several new column customization options, two entirely new plugins and major improvements to SeaTable's existing plugins. There are also important changes under the hood: SeaTable 2.0 ships with a new environment for running Python scripts, and system admins will appreciate the monitoring capability provided by the external link page.

And there is more good news! Thanks to a fantastic community effort, we could add Russian as a fifth interface language besides English, German, French and Chinese.

Column type #22: Formula for links

New column type Link Formula

The ability to map relationships between entries in different tables is one of SeaTable's key differentiators from classic spreadsheets like Excel and Google Sheets. While the latter only know cell references (e.g. for formulas), SeaTable lets you create 1:1, 1:n and n:m links between tables in a base.

The link formula column is a special column to evaluate existing links and to perform calculations. Five different queries are available: lookup, countlinks, rollup, findmax, and findmin. Where sensible, filter options allow even more detailed calculations (e.g., calculation of an average over records that are not older than 6 months old). Thanks to the graphical wizard, using the link formula column and specifying more complicated queries is effortless even for non-technical users.

More control over linking records

By default, SeaTable does not limit the kind of relationship between records in columns of type 'link other records'. In some use cases, however, a 1:1 or a 1:n relationship should or must be enforced. An asset management system is just one example: A projector can only be in one room at any time. Similarly, a test machine can only be used for one test at a time.

New controls for link to other records columns

With SeaTable 2.0, link columns now offer the configuration option "Allow linking to multiple rows ". Activated by default, deactivating the switch results in an entry in the current table only being able to link to a single entry in the linked table. For the two examples above, this means: SeaTable ensures that one does not have to search for the beamer with several people or in several rooms and it prevents the test machine from not being scheduled for two simultaneous tests.

In addition to the configuration option for limiting the number of linked entries, a second new configuration option allows limiting the type of entries that can be linked. By activating the button "Restrict links to one view" and selecting a view, only those entries in the linked table can be linked that are part of the selected view. If an entry is removed from a view by a filter, then it is not available for linking. When it comes to preventing linking between certain entries, this new option is crucial. Taking the example of the test machine again, if the test machine is undergoing its annual maintenance, then a corresponding flag in the table will ensure that it drops out of the view of available test equipment. As a consequence, it cannot be linked for test use in the test planning.

Column type #23: Rating

SeaTable's web forms are incredibly handy for simple surveys. In just a few moments, a questionnaire is created and ready to be sent out. The answers of the survey participants end up in the underlying base and can be analyzed there quickly and easily with SeaTable's various analysis tools.

New column type Rating

The new rating column is an ideal addition for such surveys: "Were you satisfied with our performance?" or "Would you recommend us to your friends?" Five stars leave no room for doubt; two stars, on the other hand, offer plenty of room for improvement. But the new column type is not only suitable for customer satisfaction surveys. You want to vote in your team on a new product name? New leads require a quick assessment for prioritisation? The rating column helps in all these cases!

The rating field supports ratings from 1 to 10 stars. If you don't like the stars' default orange, one of the other nine colors will certainly do the job. As the need arises to change the rating scale, you can do this on the fly. When extending the rating scale, the existing ratings are not altered, when shortening the scale, the existing ratings are trimmed to the newly set maximum rating.

More flexible forms: Custom logo, linked record support, and prefilled fields

The rating column is not the only change in SeaTable 2.0 boosting the versatility of SeaTable's web forms. The custom logo is the most notable new feature in SeaTable's web forms. You can embed a logo of your choice atop the form.

Less visible than the logo, but all the more important: SeaTable 2.0's web forms can now handle link columns. Link columns are more flexible and dynamic than the alternative single select columns and so allow even more detailed surveys.

Completely invisible in the editor, but all the more powerful in the application, is the default value function for form fields. To prefill a form field with a default value, add '?prefill_COLUMNNAME=PREFILLVALUE' to the form URL. (COLUMNAME is the name of the column whose field is to be prefilled; PREFILLVALUE is the value to be inserted. Spaces in column names are to be written as "%20" and are case sensitive). Of course, several form fields can also be provided with default values. For this purpose, several COLUMNNAME-PREFILLVALUE pairs are connected with the ampersand ("&").

Column type #24: Geolocation

Thanks to the map plugin, visualizing the geographic distribution of a data collection is a matter of seconds in SeaTable. The plugin interprets and plots addresses as well as other location information on a Google Map. In some cases, however, location descriptions are just not precise enough. Worse, location descriptions may not be precise over time. This is why we decided to add the geolocation column as SeaTable's 24th column type.

A geolocation column stores latitude and longitude coordinates as comma-separated values. So whether you are a biologist tracking the sightings of your object of study or a photographer geocoding your shots, the geolocation column does exactly what you need: it captures the precise, inalterable position for your later analyses.

Optional default values for columns

There are these columns in which virtually the same value must always be entered when a new entry is created, e.g. a status column in project management or a text column with a uniform leading string. Wouldn't it save a lot of time if these values could be set automatically for new entries?

Default values for columns

We think so, and this is why, beginning with SeaTable 2.0, text, number, and single-select columns support default values. If a default value is defined, a new cell is automatically filled when a new record is created. If the new record is the odd one out and the default value is not the right one, the default value can be manually overridden at any time.

New plugin: Page design

The new page design plugin generates single and multi-page PDF documents using data saved in a SeaTable base. We at SeaTable generate license certificates with the new plugin. Yet, the use cases go way beyond that: You can just as well create partner certificates for your business associates or membership cards for your tennis club. If you manage your product portfolio in SeaTable, datasheets for all your products are just a few clicks away. If you use SeaTable for recruiting purposes, a PDF job posting does not cost you any extra time.

New plugin Page Design

Every document created by the page design plugin is based on a template. The design of a template takes place in a WYSIWYG editor which the plugin ships with - no external editor required. The page design editor offers a variety of static elements such as texts, tables, and images and supports many editing functions (e.g. crop, rotate, align). If your template does not look nice, it's not the editor's fault! ;-) The editor saves the templates as JSON-files; a straightforward import and export function guarantees template portability.

New plugin: Kanban

A Kanban board is a great tool for visualizing, managing, and supervising projects, lead pipelines and many other business challenges. In fact, Kanban has proven to be so successful in many real-world applications that a great number of programs have been developed with a Kanban board at its core.

New Kanban plugin

With the new release, SeaTable also has a Kanban plugin that can be used to display data in tables on a Kanban board. The categories of a Kanban board are either the options in a single selection column or the users in an employee column. This allows the Kanban view to be used for use cases as diverse as HR management, production, sales, software development, and project management. New categories and new entries can be created directly in the Kanban view without having to leave the plugin. Intensive users will like the drag & drop support.

Improved plugins: Calendar, Timeline, Gallery, and Map

While we have dedicated a lot of time to our two new plugins, we haven't forgotten the existing plugins. All four major plugins have been improved!

The calendar plugin in SeaTable 2.0 now features an agenda, a daily and a weekly view in addition to the existing annual and monthly views. Additionally, the daily, weekly, and monthly views support dragging and dropping, and new events can be created right in the view by clicking and pulling. The agenda view lists off all events in a weekly period and in chronological order. It is great when the content of the calendar needs to be printed. Last but not least, we also added a color option for events. Events can take the color of a single select column.

The new timeline view offers a color and label option for the events shown in the Gantt diagram.

The gallery view is now optimized for mobile devices and the user interface has undergone some changes to improve user experience and data display.

Keeping track with the developments in the column type department, SeaTable 2.0's map plugin now supports the new geolocation column type.

Manual snapshots

Snapshots are a snapshot of a base. They prove their value when a base is to be reset to a previous state after extensive changes.

In the past, SeaTable created a snapshot of a base automatically every 24 hours when it recorded activity in the base. SeaTable 2.0 now also knows manual snapshots: One click and a snapshot of the base as-is is made. As insurance against unintended data loss, this click is highly recommended whenever the structure of the base (especially column and table deletions) is to be changed.

Folders for bases

As you use SeaTable every day for more and more tasks, the number of bases in your base library will start to multiply. In SeaTable 2.0, we introduce folders as an easy way to bring structure to your ever-growing number of bases. You can create new bases inside a folder or you can move existing bases inside a folder by just dragging and dropping.

Data leakage prevention

When a base contains confidential data, it is imperative to prevent the accidental or malicious leakage of data. Similarly, privacy regulations mandate sensible technical measures to protect personal information. Data leakage prevention is certainly one of those measures.

New security settings

In order to meet these high standards, SeaTable 2.0 offers additional security settings to safeguard data in bases. In the new security settings, the base owner can decide whether or not a base can be printed, duplicated, and/or exported. The owner can set these permissions independently for all users and users that have a sharing permission to the base. If a base is group-owned, the group owner and the group administrators have the right to set these settings.

Python script environment

Some part of the appeal of SeaTable for developers is its support for Python in addition to JavaScript (JS) scripts. (Competitive products only support JS scripts.) While JS scripts are executed in the browser, Python scripts run server side. In combination with the ability to execute automatically, Python scripts lend themselves to more complex data processing scenarios.

Python execution environment

This flexibility comes at a price though: The server-side execution of Python scripts raises security concerns. In order to minimize implied risks, we have added two components and isolated the main system from the execution environment of the Python scripts. As a team, the new SeaTable FAAS Scheduler and Python Runner ensure security and scalability. Every time a python script is run, a Docker container spins up and executes the script. The result is returned to SeaTable and the Docker Container is destroyed. By deploying multiple Python Runners, large numbers of scripts can be processed without waiting time. (More details are available in the SeaTable Admin Manual).

External link page

An external link is quickly created to share information with external partners. The option "Automatic expiry" can also be used to limit the lifetime of a link. In reality, however, this does not always happen and so external links can persist even after their use has ended.

So that the team administrator can get an idea of the existing external links, SeaTable now offers an overview page of the external links in the team administration. The existing external links for bases and views are listed in two tabs. The tabular display offers information about the creator and creation date as well as the number of calls. However, the team administrator does not only have read rights. If a link is to be deactivated, he can do this as well.