Baserow 1.30: number formatting, HubSpot sync, Excel export & more

We’re excited to announce the release of Baserow 1.30, packed with powerful new features and improvements. This update introduces improved number formatting, HubSpot integration, Excel export, Form View select options, multi-page container, page visibility and several UI enhancements that make Baserow even more user-friendly.

Let’s dive into the key features that make this release special:

Advanced number formatting

Advanced number formatting gives you more control over how numbers are displayed in your tables. You can now customize the appearance of numeric fields with options for decimal places and new display formats.

Key formatting options include:

• Thousands and decimal separator customization
• Prefix and suffix options

To configure number formatting:

1. Click the field menu for any number field
2. Select ‘Edit field’
3. Set up your preferred number format

HubSpot Contacts data sync

The HubSpot data sync feature automatically synchronizes information between Baserow and HubSpot CRM, letting you view and manage HubSpot contacts directly in Baserow.

To set up HubSpot contact sync:

1. In your database sidebar, click ‘+ Create table’.
2. Select ‘HubSpot’ from the options.
3. Name your table and enter the necessary details for synchronization.
4. Click ‘Next’.
5. Choose the fields you want to sync.
6. Click ‘Create and sync table’.

Additionally, you can update existing data sync integrations by modifying the sync configurations, including visible fields and sync settings.

Excel export

The Excel export feature lets you export your Baserow data to Excel format. This provides a simple way to convert your data into a spreadsheet for use in other tools. You can export either an entire table or a specific view.

To export your data to Excel:

• In the right sidebar, click the ⋮ icon next to a table/view.
• Select 'Export table/view’.
• Choose 'Export to Excel’ to download the data in .XLSX format.

Form View select options

This new feature gives you control over which options are displayed in single and multiple select fields when using the Form View. You can customize the available choices to show only specific options, giving you better control over form organization.

To configure select options in Form View:

1. Open a Form View
2. Find the single or multiple select field you want to customize
3. Choose which options should be available in the form

Row select modal improvements

We’ve revamped the row select modal interface to make linking rows in Baserow more efficient. This update gives you better control and a clearer view when working with related records.

Key improvements include:

• Adjust fields width
• Hide fields
• Customize fields order in the “Hide fields” menu

Multi-page header and footer elements

Multi-page header and footer elements allow you to create a single container that can be reused across multiple pages.

This feature streamlines your workflow by letting you define a container structure once and apply it consistently throughout your application. It not only saves time but also maintains design consistency. You can choose to display the container:

• On all pages
• Only on selected pages
• Exclude selected pages

To add this element, access the elements panel and select ‘Multi-page header’ and/or ‘Multi-page footer’.

Page visibility

The page visibility feature lets you control which user groups can see specific pages in your Baserow applications. This provides more detailed control over page-level permissions, complementing the existing element-level visibility settings.

To set page visibility, navigate to ‘Page Settings’ in the top menu and select the ‘Visibility’ tab. Here you can specify who can view this page:

• All visitors
• Logged-in users (define roles if needed)

You can now configure a “Login Page” for your application. When a visitor tries to access a page that requires authentication, they will be redirected to your configured login page.

Date time picker element

The date time picker element offers a user-friendly way to input dates and times in your application. Rather than typing dates manually as text strings, users can select dates from a calendar interface. You can configure the element to show or hide the time field and set the date and time format.

To add this element, access the elements panel and select ‘Date time picker’.

Other new features:

• OpenRouter AI integration
• Support for grouping by link-to-table fields
• Support for filtering lookup fields linked to single-select fields
• Support for filtering lookup fields linked to multiple-select fields
• Support for filtering formula fields linked to single-select fields
• Support for filtering formula fields linked to multiple-select fields
• Support for filtering formula fields linked to duration fields
• Ability to collapse a sidebar
• Moved instance admin user and workspace management from premium to open source

Korean translation

Thanks to a community contribution, Korean language support is now available across the Baserow interface, making the platform more accessible to Korean-speaking users.

New templates

We’ve made significant improvements to existing templates and added new ones to our library.

• Santa Logistics
• Task Management
• Business Goal Tracker
• City Tours
• Commercial Property Management
• Competitor Analysis
• Electronic Health Record
• ESG Management
• Event Planning
• Incident Management
• Lightweight CRM
• Online Freelancer Management
• Order Kiosk
• Policy Management
• Risk Assessment and Management

Company news

Baserow Academy

Baserow Academy is here! Start your journey toward becoming a Baserow expert. Our Fundamentals course, covering all the basics, is available to everyone!

Become a certified Baserow expert!

Baserow Community Discord Server

Great news! Our Baserow Ambassador Jo from Portugal is now leading a community-driven Discord server for Baserow users.

Join Baserow Community on Discord!

Baserow Cloud vs. Baserow Self-Hosted

Our Ambassadors are collaborating to host an online Baserow Community gathering! Mark Godfrey (UK chapter), Sascha Koenig (German chapter), and Ronald van der Weijden (Netherlands chapter) are organizing a meetup to explore a crucial topic: Cloud vs. Self-Hosted. They’ll be exploring the pros and cons of each approach.

Sign up to receive event notifications!

What’s next

The next big features on the roadmap include an analytics dashboard, more AI features, menu element, SSO 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!