Baserow 1.27: 600% faster formulas, calendar sync, new theme settings, and more

Introducing Baserow 1.27: a wrap-up of all the work the development team has done in the last 2 months. Upgrade to the new version and enjoy:

• Up to 6 times faster formulas
• Theme settings for Table and Input elements in Application Builder
• External calendar synchronization
• Improved row selection modal
• Official Helm chart for self-hosting

Let’s dive into what’s new:

6 times faster formulas

We’ve optimized Baserow’s performance, resulting in loading and importing times up to 6 times faster for tables with formula fields. The improvement reduces some table operations—like row creation, modifying and deletion—from over a minute to under a second. This is most noticeable when formulas reference other formulas. It also speeds up import work for formula-containing tables by 6 times. With Baserow, you can scale your data without compromising speed or performance.

More styling options for Application Builder

Unleash your creativity with the Application Builder’s new styling options. You can now customize Table and Input elements, allowing you to create more personalized interfaces for your Baserow data.

To customize the theme settings, click the three dots next to the application name and select Settings. In the modal that appears, navigate to the Theme section. Choose the appropriate tab to begin configuring the appearance of Table or Input elements.

Sync to an external calendar

You can now sync your Baserow Calendar View with external calendar applications. This feature keeps your data up-to-date across platforms, whether you’re managing project deadlines, scheduling events, or tracking important dates.

To sync to an external calendar, go to the Calendar View, click on Share view, and choose the option Sync to an external calendar. Then, paste the provided link into your calendar application.

Joining data via the API

Baserow now supports joining data via the API, allowing you to retrieve and combine information from multiple tables in a single API call. This feature works with any existing link to table fields, enabling dynamic lookups without creating a lookup field. However, you still need to set up the link to table field that hold the relationships. The query parameter should look like this ?{link_row_field}__join={target_field},{target_field2}. More information can be found in the API docs list_database_table_rows endpoint.

Official Helm chart

Baserow now offers an official Helm chart for simplified Kubernetes deployment. This chart streamlines the installation process, making it easier to set up and manage Baserow in containerized environments. For detailed instructions on how to use the Helm chart, refer to the documentation.

Improved row select modal

The new row select modal improves the user experience by allowing multiple row selection, keyboard navigation, and instant search-as-you-type functionality. These enhancements enable you to quickly select linked rows, boosting productivity and saving your time.

Ability to change the primary field

You can now change the Primary field in your table. Select a different field as the main identifier for your table, adapting to evolving data structure needs.

To change the primary field, go to the field you want to make primary and click on the field options. Select Change primary field, then pick the new field from the dropdown menu.

Filtering for text-based lookup fields

This feature allows you to apply filters to text-based lookup fields, making it easier to find specific information across related tables.

1. Click + Add Filter.
2. Choose a text-based Lookup field from the dropdown.
3. Choose the condition you want to use.

Nested collection elements

You can now create two types of hierarchy using the Repeat element:

• A root-level collection element with a multiple-row data source and no multiple-valued property
• A nested collection element without a data source but with a multiple-valued property

By nesting collection elements, you can display a list of departments, each containing a nested list of employees, or to create an e-commerce store.

To add a Repeat element, first click on Elements in the top bar. Then, select Element + in the lower left corner of the popup. Alternatively, you can add an element by clicking on the plus icon + on the page. From the menu of available options, choose the Repeat element.

New dashboard and sidebar

As part of our overall rebranding, we’ve revamped the dashboard and left sidebar. The new user experience offers a more intuitive layout, featuring:

1. Unique dashboard for each workspace
2. Suggested templates
3. Resources

Enjoy the new, cleaner look and feel of your Baserow home.

Other new features and updates

• Highlighted edited rows
• Clickable URLs in lookup fields
• Automatic creation of reverse relationships when adding rows in the select modal
• Add custom fields during onboarding
• Baserow version in the settings page

Company news

Data modeling 101: How to structure your database

On the 16th of September, join us for a webinar on data modeling to learn how to structure your data and optimize your current databases and tables. You’ll get answers to key questions:

• How to determine what should be tables, fields, and rows
• How to identify and create relationships between tables
• How to select optimal data types

Register now!

Baserow wins Best Database Software by The Netty Awards

We’re excited to share that Baserow has won the Best Database Software award at The Netty Awards!

Check out why Baserow earned the title of an innovative platform that revolutionizes data management here.

Baserow at the No-Code Summit

Mark your calendars! The Baserow team is attending the No-Code Summit 2024 on October 16 & 17 in Paris.

We hope to see you there!

Community video tutorials

• Watch the guide on getting started with Baserow: create your first database and workspace!
• Check out how to unlock the power of Baserow formulas.
• See how to create connections in Baserow and enhance your data with table relationships.
• [Portuguese] Discover the FlutterFlow API integration: listing Baserow data.
• Learn how to install Baserow with Docker and Portainer.
• Discover how to automate your post creation with Baserow AI.
• Check out the Baserow complete review 2024.
• See how faith.tools uses Baserow & Latenode.
• [Spanish] Watch goodbye Airtable! BASEROW: the Database REVOLUTION.
• [Portuguese] See how to create a registration system in FlutterFlow with Baserow API.
• [Portuguese] Watch how to create, configure and integrate a Baserow database into your n8n automations.

What’s next

The next big features on the roadmap include Timeline View, data sync, advanced permissions for Application Builder, and other features suggested by the community.

If you have any questions about the new updates, please leave them in our official community forum. We’re happy to answer them!