Baserow 1.21: Row history, advanced filters, and more

October 25, 2023 • Bram Wiepjes

In version 1.21, we took collaboration to the next level in Baserow. Workspaces now include row change history, advanced filtering, and the ability to link to multiple link to table entries in the form view. You can also edit values in the row edit modal of a relationship now!

Here’s what’s new:

Row change history

Row change history provides a summary of changes made to each row over time, giving you more control over your data.

To access a row’s history, expand the row and go to the “History” tab located next to the comment panel. In the history, you can see who authored the changes, details of what was changed, and the date and time the changes were made.

Baserow Cloud

Free plan: 14 days of revisions.
Premium plan: 90 days of revisions.
Advanced plan: 180 days of revisions.

Baserow Self-Hosted

Free plan: Unlimited.
Premium plan: Unlimited.
Enterprise plan: Unlimited.

By default, there is a limit of 365 days of revisions for self-hosters, and you have the flexibility to change this limit to any other number.

Advanced filtering

With advanced filtering, you can create and combine condition groups using AND and OR logic. These groups allow you to show only the rows that meet your specific criteria. By using these conjunctions, you can make your filters even more complex and display only the rows that match your exact requirements.

You can create condition groups within the filtering, row coloring, and conditional form fields features.

screenshot edit row values in relationship

You can now directly edit the values of linked rows from the row edit modal. Any changes you make to the row will be reflected in the original table. No need to switch between tables just to modify or add information to a linked row.

Enable linking to multiple link to table entries in the form view

screenshot linking to multiple link to table entries

This feature allows you to link to multiple table entries in the form view. You can choose between “Single” and “Multiple” options for displaying the field. The “Multiple” option includes a “Plus” button that allows you to add another dropdown to select a value from.

Last visited view

In the past, when you switched between tables, the default view would resort to whichever the first view in that table was.

Now, the last visited view for each table will be saved and automatically opened on your next visit. This allows you to easily pick up where you left off while working with different tables simultaneously!

Support for file fields in the lookup field type

The lookup field now supports the file field type. This means you can link your files or images and see them displayed in linked tables.

If a cell is active, you can now press the space bar to open an enlarged version of the row.

Company news

Become a Baserow Ambassador

If you’re a fan of Baserow and want to go beyond just using the product, we invite you to join our ambassador program! As a Baserow Ambassador, you’ll not only get exclusive behind-the-scenes access to our development process but also enjoy special perks. These perks include the opportunity to connect with other Baserow enthusiasts, attend invite-only events where you can learn more about our vision and future plans, and much more.

New logo

We are excited to announce our sleek new logo! This logo is part of a larger product redesign that we will be shipping soon. Check out this preview of a section from the new Baserow homepage. The original logo and product design was created by one of our co-founders when Baserow was just getting started. We’ve come a long way since our original branding, but now we’re refreshing to make sure everything moves cohesively with the evolution of the platform.

Baserow at NoСode Summit 2023

Last week, the Baserow team attended NoCode Summit 2023 in Paris.

During the two-day event, we had the opportunity to discuss, share, and connect with 2,500 no-coders. We also had two speaking slots where we talked about the power of open-source and no-code, and demonstrated how to build scalable apps without code.

Community activities

→ Check out a new set of videos showcasing the entire process of building a responsive web application for reporting a nest of Asian hornets in an area. It’s built using Appsmith as the frontend and Baserow as the backend.

→ Test out this amazing community-built Baserow charts plugin by importing your data.

→ Discover a new Python client for Baserow, designed to focus on the basic Baserow API, specifically for tables, fields, rows, values, and filters.

→ Learn how to build a habit using Baserow, n8n, and Telegram.

All changes, including bug fixes

New features

Added file field support to formula and lookup fields. #1012
Made it possible to edit values in the row edit modal of a relationship. #1117
Added condition groups for advanced row filtering using ‘And’ & ‘Or’ conjunctions. #1271
Added a new view filter for selecting rows whose file columns have less files than a given number. #1771
Replaced icons. #1918
Restyled tabs component. #1918
Added ability to subscribe to multiple pages via websockets. #2019
Added row edit history. #2030
Prevented CSV injection when exporting view to CSV format. #2043
Invalidated authentication tokens on password change. #2044
Expires the refresh token on log out. #2045
Enabled linking to multiple link to table entries in form view. #810
Introduced endpoint to create a new user as admin.
Reduced the number of queries when listing rows in a table that has many single/multiple select fields.
Introduced space bar keyboard shortcut to open row edit modal in grid view. #2030

Bug fixes

Baserow round formula causing sql errors. #1595
Date interval addtion bug. #1742
Prevent filters to be applied when the user open the row edit modal. #1765
The second formula function applied on a date field fails hard. #1812
Fixed when_empty must be the same type error when working with url and email fields. #1880
Fixed rounded corners in edit row modal. #1950
Fixed webhook url validation not being disabled when baserow_webhooks_allow_private_address true #1959
Fixed a not working ctrl/cmd+f keyboard shortcut on pages that don’t have a search box. #1968
Fixed bug where the navigation history was wrong after last view. #2006
Fixed a bug not clearing the notification store when the user logs out. #2016
Fixed an issue with running Baserow in production mode. #2035
Removed duplicate field options and fix remaining race in update_field_options. #725
Fixed batch file request missing validation.
Fixed performance bug when N number empty_count view aggregation were added.
Fixed import serialized with missing select options error.
Fixed bug in the gallery view which resulted in the row edit modal not always having an update to do row.
Reduced the number of get_model calls in the row endpoints.