Baserow 1.18: Count, Rollup, free Advanced trials, and more

If you frequently build relationships between your data in Baserow, you’re in luck! Baserow 1.18 introduces Count and Rollup field types, which make it easy to perform calculations on data from related tables.

Even though counting and rolling up were already possible using functions in the Formula field, we decided to surface them into their own field types to make it even easier to work with your data.

Additionally, we’re now offering a 30-day trial, so you can test out Baserow’s advanced features for free.

Let’s dive into the details of everything that’s new in Baserow.

Count field type

A count field allows you to determine the number of linked rows in a link-to-table field. To add a count field, click on the + button just after the last visible field at the end of the table. Next, select “Count” from the available field types and click Create.

To configure the count field, select the linked table on which you want to perform the count.

Rollup field type

The rollup field in Baserow allows you to aggregate data from related tables. It performs calculations on rows from a linked table. While a count field returns the number of linked rows, a rollup field also performs calculations with those values. For example, it can sum together all the values from the linked rows or return only the maximum value.

To add a rollup field, click on the + button just after the last visible field at the end of the table and then select “Rollup” from the available field types. Next, choose the following fields:

• “Select a link to table field”: The linked table you want to roll up.

• “Select a field to rollup”: The field of that linked table you want to roll up.

• “Rollup function”: The calculation you want to perform on those values.

There are different calculations that you can apply as a rollup. Here are all of them: any, every, max, min, count, avg, sum, stddev_pop, stddev_sample, variance_pop, variance_sample.

Try Baserow’s Advanced plan for free!

To try out Baserow’s advanced features, select “Get free trial” in your dashboard. Alternatively, you can enable the free trial by clicking on the locked features. A free trial can only be activated once per workspace.

Once your trial expires, subscribe to a Baserow paid plan, or reach out to our sales team if you need more time to experiment with advanced features.

By enabling the free trial, you’ll gain access to:

• Row coloring
• Kanban view
• Calendar view
• JSON and XML import
• Survey form
• Public logo removal
• Personal views

View Advanced plan details here.

Automatically create rows when pasting more rows than available

If you want to paste 10 rows of data into a table that only has 6 rows, the additional 4 rows will be created automatically.

Company news

Baserow + AI: what value does it bring to YOU?

To ensure that Baserow delivers real value with AI, we would like to hear from you directly: How do you envision AI working in Baserow? Where do you see it being most useful?

Please fill out this 2-question form to help us determine how we could maximize using AI within Baserow.

Podcast with Baserow co-founder and CRO

Listen to a podcast with our co-founder and CRO, Olivier Maes, about Baserow leveraging open source for creating scalable no-code database. (Note: the podcast is in French 🇫🇷)

Community activities

Code contributions

Today we want to thank Shohan Dutta Roy for contributing a very useful feature — adding new date filters is before or equal and is after or equal. Shohan, many thanks for your time! Your enthusiasm is highly appreciated 💙

Tips & Tricks

• Check out the demo of React CRUD App with Baserow database integration.
• Test out the Baserow and LoneScale integration via n8n.
• Discover how to increase your Baserow’s performance using SQL caching.

What’s next?

The next big features on the roadmap are search performance improvements, collaborator mentions, advanced filtering, and other features suggested by the community.

Do you have questions regarding the new updates or anything else? Leave your questions in our official community forum — we’re always happy to answer them!

All changes, including bug fixes

• When copy-pasting, automatically create missing number of rows. #1252

• Added 2 date filters: before or same date and after or same date. #1344

• Wrap migrate command in some sort of lock to prevent buggy concurrent migration runs in deployments with many Baserow backend services. #1654

• Added ability to copy and paste between different multi select option fields based on matching. #1750

• Introduced rollup field. #222

• Introduced count field. #224

• Fixed redirect param being propagated. #1043

• Duplicating field with select options results in two fields sharing same underlying options. #1735

• Fixed drag and drop problem in Kanban view regarding inconsistent stack counts. #1738

• Fixed browser freeze in older browsers when copying single cell. #1741

• Hide login buttons and login actions when afterSignupStepComponents are being displayed. #1747

• Fixed issue where cachalot doesn’t invalidate correctly database_multipleselect_* m2m tables. #1772

• Made Airtable import compatible with signed files.

• Added datetime formats to be able to parse different datetimes (with momentjs strict mode enabled). #1648