Baserow 1.22: Group by, form upgrades, and more

Baserow 1.22 is our biggest release to date, bringing the most awaited features and improvements. Upgrade to the new version and enjoy:

• Group by
• Created by field type
• Last modified by field type
• Follow or unfollow row comments
• Email notifications for new form submissions
• And tons more

Here’s what’s new:

Group by

The Group by feature can be found in the grid view. Grouping rows lets you sort your data based on one or more fields. You can add many fields to make subgroups within each group of rows. This allows for better sorting. Plus, you can see how many items are in each group.

Created by field type

The Created by field shows the name of the collaborator who added a row to the table. This field is especially helpful for connecting new rows to their creators by identifying the person responsible for creating a specific row.

Last modified by field type

The Last modified by field shows who made the most recent changes to a row in the table. This feature makes it easier for you to keep track of who is responsible for the updates. By knowing who made the changes, you can work together more efficiently and keep all workflows running smoothly.

Follow or unfollow row comments

You can now select to get alerts only when someone mentions you in a comment. Or, you can get alerts for all comments on a row, even if no one mentions you.

If you wish to get alerts for all comments on a certain row, click on the bell icon at the top of the row edit box. This will allow you to follow that row. When you follow a row, you will get alerts every time someone comments on it. This feature helps you keep track of tasks and processes that need your focus.

Email notifications for new form submissions

You can now opt into receiving notifications when someone fills out the form. To turn on these notifications, just switch on the “receive form notifications” button found at the bottom of the form edit page. This feature helps you stay updated about new form entries and allows for fast responses when required.

Duration field type

The Duration field is specifically designed to store time durations measured in hours, minutes, seconds, or milliseconds:

• h:mm - This format is suitable for representing hours and minutes, for example, 1:23.
• h:mm:ss - You can use this format to display hours, minutes, and seconds, like 1:23:40.
• h:mm:ss.s - If you need to include deciseconds, this format allows you to represent hours, minutes, seconds, and deciseconds, such as 1:23:40.0.
• h:mm:ss.ss - This format accommodates centiseconds, enabling you to display hours, minutes, seconds, and centiseconds, for example, 1:23:40.00.
• h:mm:ss.sss - If you require even more precision, this format includes milliseconds, allowing you to show hours, minutes, seconds, and milliseconds, like 1:23:40.000.

You can use this field to easily store information about the duration of projects, tasks, or meetings, and perform further manipulations with this data.

Autonumber field type

The Autonumber field automatically generates unique and incremented numbers for each row. This field is often used as a primary key to uniquely identify each entry in a table.

UUID field type

The UUID field automatically generates a unique identifier for each row. This field is often used as a primary key to uniquely identify each row in a table.

Radio and checkbox components for form view

Now, you can choose a radio button for single selection fields and a checkbox for multiple selection fields in the form view. These new options make forms look better and simpler for people to select their choices while completing them.

Switching between personal and collaborative views

When creating a new view, you have two view permission types:

1. Collaborative view, which is visible and configurable by all workspace members.
2. Personal view, which is only visible to the user creating the view.

Now, you can change the view type from collaborative to personal or vice versa. Simply click on the ellipsis ••• next to the desired view and select the option to change the view type.

Use multiple select in formulas

Baserow’s formula field type now supports multiple select fields. Using a formula with a Multiple select field allows you to display which fields include specific options and perform further manipulations with this data.

New templates

We added new templates and improved existing ones. You can find the most recent updates on the Templates page.

• Beverage Sales Management
• Car Comparison
• ESG Management
• Staff Development

Company news

Recognitions

Thanks to your reviews:

• Baserow is included in Capterra’s 2023 Shortlist for both the no-code and low-code development platform categories!
• Baserow is named a top-rated software solution in Software Advice’s 2023 FrontRunners Report for Top No-Code platform!
• Baserow ranks #4 in GetApp’s list of category leaders in no-code and low-code platform development!

Technology partnership with Make

Baserow and Make are now official technology partners!

We are excited to partner with Make to enhance workflow automation and make it even easier for you! This partnership will help your team get more value from using Baserow alongside Make every day. 🤝

Vote on features for 2024

Help us prioritize what to focus on for Baserow in 2024 by answering a few questions. We read every single response. Thank you in advance!

Take the survey!

Community activities

⚡️ Learn how to build a wishlist app with Baserow, Astro, and Solid. Created by Darko Bozhinovski.

⚡️ Watch this video tutorial on how to add dynamic data to Webstudio using Baserow and n8n by Frederik Duchi.

⚡️ Install Baserow on Linux with this step-by-step tutorial by Jack Wallen.

⚡️ Take a look at the interesting insights about how to use AI to learn, or improve and speed up your work by Brandon Hull.

⚡️ Check this useful Baserow demo prepared by Joshua Tiernan from NoCodeFounders.

⚡️ Read this comparison of Baserow vs Airtable by Mark M.

All changes, including bug fixes

New features

• Add support for multiple select in the formula field. Add has_option formula to check if a multiple select field has a specific option. #1363
• Group rows by field. #143
• Allow switching between personal and collaborative views. #1449
• Added UUID field type. #1463
• Allow choosing a checkbox input option for the multiple select field in the form view. #1899
• Add chips UI component #1918
• Redesign context and select menus #1918
• Restyle input and textarea #1918
• Restyle radio button #1918
• Add Last Modified By field #2042
• Send a notification on form submission to subscribed users. #2054
• Allow to follow/unfollow comments on a specific row. #2086
• Display ‘available in premium version’ message for non-premium users when switching view to Personal #2087
• Add the duration field type. #2088
• Add support for sorting Last Modified By fields #2106
• Add support for search for last modified by field type #2108
• Add is, is not, empty, not empty filters for last modified by field #2109
• Immediate frontend rendering for changing Last modified by field values #2113
• Add the created_by field type. #624
• Add autonumber field #811
• Allow choosing a radio input option for the single select field in the form view. #813
• Introduced BASEROW_FRONTEND_SAME_SITE_COOKIE environment variable to change the cookie sameSite value.
• New templates:
  • Beverage Sales Management
  • Car Comparison
  • ESG Management
  • Staff Development

Bug fixes

• Fixed incorrect font in emails by introducing fallback. #1947
• Fixes the deadlock errors that can occur when updating TSV cells. #1984
• Fix shift arrow selection on grid view when primary key field option is not first #1998
• Make date field responsive in Row dialog. #2048
• Fixed a bug that prevented table duplication when a ‘Link to Table’ field is modified to link to a different table. #2053
• Remove the ‘App pitch planner’ database from the ‘Elementary School Management System’ template. #2060
• Fix a bug causing the ‘Duplicate row’ in the UI not showing values correctly for single and multiple select fields. #2068
• Fix a bug preventing lookup fields to work properly with last modified fields. #2081
• Fixed a bug causing the UI to freeze on clicking the already opened table link in sidebar. #2082
• Fix filename inconsistency for downloaded files #2096
• Disable incompatible filters in public views #2116
• Fix values not being updated in row edit modal if the row is not in the buffer. #2128
• Fix a bug causing comments not syncing in row edit modal on navigation. #2144
• Fix bug causing the notification panel to crash with comment notifications lacking user sender #2157
• Disable session recording in Posthog to prevent ReportingObserver error.
• Fix show paginated response of the APIListingView in the OpenAPI spec.
• Fixed undefined event when copying rows via multiple row context.
• Fix duplicate darker color in palette.
• Fix limit of the multiple selection in the web-frontend
• Resolve the postcss-loader warnings.
• Fix bug where commenters were not able to see row comments and change history.
• Suppress redirect error when selecting the database application.

Refactors

• Alert and toast refactor #1918
• Reduce the amount of data written from automatic field updates when possible. #2021
• Pick a valid view from the available ones if a rowId is provided in the route params. #2095
• Add the workspace_id and the database_id to webhook payload. #2147
• Improved performance of the field dependency updating.
• Improved performance of the field serialized import export, resulting in fast duplication.

What’s next

After this release, we will review all the issues in the backlog and consider community feature requests to create a new roadmap for 2024. Meanwhile, our development team will concentrate on resolving bugs and improving performance for Baserow.

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