1.13 release of Baserow

We are excited to announce the release of Baserow 1.13 and introduce two new security features as a part of Baserow Enterprise: role-based access control and single sign-on.

The new enterprise version was built to meet the needs of big organizations, and make Baserow even more secure and flexible. It comes with advanced user management to boost data protection and privacy requirements.

Baserow Enterprise is available to self-hosters and on Baserow.io the Advanced plan now comes with RBAC.

Baserow Enterprise’s key capabilities:

Role-Based Access Control (RBAC): Baserow RBAC helps teams manage complex access protocols, such as vetting who to grant data and resource access to and what they can do with the information. RBAC is also available for self-hosters and on Baserow.io for users who buy the Advanced plan.

Single Sign-On (SSO): Baserow now integrates with any 3rd party SSO provider using SAML to control who can login and let them do so without having to sign-up to your Baserow separately.

Role-Based Access Control (RBAC)

Role-based access control allows restricting access to your data by granting roles to your group members individually. Roles in this initial release are group-wide, but in the coming weeks, we will also allow you to assign roles on specific tables and databases.

For example, if you want to invite someone to your Baserow group but only let them view all of your tables and databases, you can now do so by inviting them to the “Viewer” role.

What can you do with Baserow RBAC?

On the new group Members page, you can assign members one of the following roles for the entire group – Admin, Builder, Editor, Commenter, and Viewer. Here is an overview of what each role grants:

• Viewer: Can only read databases, tables, views, fields, cells, comments, and trash.
• Commenter: Can do everything a Viewer can do including seeing and writing row comments.
• Editor: Can do everything a Commenter can do plus editing cell values, creating and deleting rows in tables.
• Builder: Can do everything an Editor can plus creating, editing fields, tables, views and databases.
• Admin: Can do everything a Builder can plus inviting group members, controlling their permissions and managing licenses, subscriptions and site-wide settings.

For a detailed breakdown on what exactly each role can do see the following Baserow table: https://baserow.io/public/grid/xVJLvN0zjCwXGFBgdgrmQRzt8dMqT0aes5FHSqPip40

How admins can use RBAC

Roles give organizations more flexibility around permissions that can be granted to members. Admins can:

• Invite members: You can invite a new member to the group via email and now also select what role they should have upon joining your group.
• Grant and remove roles: On the new group members page, you can control which role each user in your group has.
• Delete members: You can remove any member from the group by deleting a user from the list of members.
• Create and manage teams (coming soon). Teams will allow you to assign a role to many different users at once without having to manually assign a role per user.
• Roles on database and table level (coming soon). Database and table level permission allow you to grant roles for a database or table only. This will for example make it possible to only give a user the viewer role to a database, but builder to a specific table.
• Create/edit a custom role (coming soon): Custom roles are often important to members who have to wear different hats in an organization and hence need access to various groups and data points. We plan to add this functionality in the next Baserow release.

Single Sign-on

Single Sign On (SSO) allows users to log in just one time with one set of credentials to get access to all corporate apps, websites, and data for which they have permission.

Which SSO protocols are supported in Baserow?

SAML SSO

Security Assertion Markup Language (SAML) is a security standard for managing authentication and access. When using SAML SSO, members log in to their Baserow organization using the organization’s identity provider.

Baserow supports dedicated integrations with the following identity providers:

• Setting up SSO for Okta
• Setting up SSO for OneLogin

OAuth 2 SSO

OAuth2 protocol provides secure delegated access without sharing the credentials. It allows users to give access to their resources hosted by a service provider, such as Facebook, without giving away credentials. It acts as an intermediary on behalf of the end user, providing the service with an access token that authorizes specific account information to be shared.

• Setting up SSO with Google
• Setting up SSO for Facebook
• Setting up SSO for GitHub
• Setting up SSO for GitLab

OpenID Connect SSO

OpenID Connect is an identity layer built on top of the OAuth 2.0 protocol. Its purpose is to give you one login for multiple sites. With the support of OpenID Connect, the Baserow users are now able to use ANY service that supports this exact protocol to login into the tool.

• Setting up SSO for OpenID Connect

New integrations

Our integration with Make is live! Make (formerly Integromat) is an automation platform that integrates with over 1000 apps including Baserow now. It allows you to visually create, build, and automate workflows.

We know this integration was very awaited by our community, so we are extremely happy to announce its launch today. Check it out: https://www.make.com/en/integrations/baserow.

Baserow is now available in Polish

Dzien Dobry!

Thanks to our community member — Piotr, Baserow is now available in Polish. Piotr, thank you so much for the efforts you have made to do the translation.

To set up your language: go to Settings → Interface Language.

New in Templates

We added many new templates, and did some upgrades to existing ones. See up-to-date updates on the Templates page.

• Meeting Minutes
• Meeting Room Booking
• Office Guest Log
• Legal Case Tracker
• Podcast Content Manager
• Job Interviews
• Interview Questions

New roadmap

Let’s make Baserow work for you!

We are always working to make Baserow exactly what you need for organizing your data. Your feedback will help us to decide which features to build in the next milestones as we are currently setting a new product roadmap.

To help us make Baserow the best it can be, we need your feedback today. Take 2 minutes to fill out our survey: https://baserow.io/form/am1xpHj-_nsv1dnhrl1kV_CCzcha-mvZLbhE4Gm7HVo.

Community updates

Code contributions

Today we want to thank Abdalla Mahmoud for contributing ’Switched click outside handling in modals and contexts to mousedown rather than click event’ and fixing ‘Slug rotation for GalleryView’. Abdalla, your enthusiasm is highly appreciated 💙

Another thank you we want to address to Abin Joseph who discovered an open redirect bug on the login page which we have already fixed. Abin thank you for discovering and pointing our attention to this bug.

Tutorials

We are amazed by all the tutorials Claudio Balbino (Vamos Automatizar) created! Portuguese-speaking users, here are new videos on how Baserow can be used to automate some work in a bundle with n8n. Enjoy watching!

• How to create chatbot with WhatsApp Cloud, official api of Meta, n8n and Baserow.
• How to integrate Facebook Lead Ads with other services using n8n and Baserow.
• How to post to Instagram page using Graph API with n8n and Baserow.

Claudio, thank you for your big support!

Tips & Tricks

We are happy to see more and more engagement in the Tips&Tricks section in the community forum. Especially we want to acknowledge bfranklink for actively posting his insights and discoverings.

Sharing is caring, and we do care about each other here. Do not hold onto your tips, lifehacks, techniques, or workarounds — share, and help each other grow.

Made with Baserow

Language translation

Luc W, our community member, created an amazing plugin on top of Baserow — this plugin introduces very powerful language translation capabilities.

“My goal was to develop a collaborative spreadsheet specialized on language learning. Building from scratch would have been fun. But using Baserow allowed me to put together a prototype in weeks. The documentation is outstanding. You can build your business logic on top of baserow and not be worried about being limited somehow due to its open source nature. I’ve got everything working exactly how I wanted it, with very little code, and almost no front-end code. Really happy with baserow and the plugin system.”, Luc W.

More details on the plugin can be found here: https://community.baserow.io/t/language-translation-using-baserow/1345.

A lightweight spreadsheet

We also want to share another great project Data Blaze Beta! that was built on top of Baserow by the company Blaze. Just have a look at how far you can go while using an open-source project that is built with extensibility at its core: https://community.blaze.today/t/request-for-feedback-data-blaze-beta/22784.

All changes including the bug fixes!

• Background pending tasks like duplication and template_install are restored in a new frontend session if unfinished.
• Added Zapier integration code.
• Made it possible to filter on the created_on and updated_on columns, even though they’re not exposed via fields.
• Expose read_only in the list fields endpoint.
• Made it possible to add additional signup steps via plugins.
• Added an option to remove the Baserow logo from your public view.
• Always allow the cover image of a gallery view to be accessible by a public view.
• Added the ability to double click a grid field name so that quick edits can be made.
• Upgraded docker containers base images from debian:buster-slim to the latest stable debian:bullseye-slim.
• Upgraded python version from python-3.7.16 to python-3.9.2.
• Added SAML protocol implementation for Single Sign On as an enterprise feature.
• Added OAuth2 support for Single Sign On with Google, Facebook, GitHub, and GitLab as preconfigured providers. Added general support for OpenID Connect.
• Fixed bug where it was not possible to select text in a selected and editing cell in Chrome.
• Fixed bug where the row metadata was not updated when receiving a realtime event.
• Duplicating a table with a removed single select option value no longer results in an error.
• Selecting text in models, contexts, form fields and grid view cells no longer unselects when releasing the mouse outside.
• Fixed slug rotation for GalleryView.

What’s next?

Release 1.13 is almost the last milestone in the current Baserow roadmap! While the product team will be mapping the next steps for the development of the features, our devs will be polishing issues and bugs from the backlog. Complete this survey to help us to collect some product insights from you and make the next roadmap based on your wishes.

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!