Baserow 1.31: Periodic data sync, shared view export, and new Application Builder styling

We’re excited to announce the release of Baserow 1.31, bringing significant improvements to data synchronization, export capabilities, filtering options, and Application Builder features.

Let’s dive into the key features and improvements in this release.

Periodic data sync

We’ve improved our data sync capabilities to give you more control over synchronization timing. With periodic data sync, you can now schedule automatic synchronization at regular intervals:

• Daily synchronization
• Hourly updates
• Manual sync

You can also select specific views when setting up Baserow table synchronization, allowing precise control over which data syncs between workspaces.

Learn more about data sync.

New filter capabilities for Lookup and Formula fields

We expanded our filtering capabilities, with a focus on lookup and formula fields. These improvements give you more flexibility in filtering and analyzing data.

The new filtering support includes:

• Support for filtering lookup fields linked to date fields
• Support for filtering lookup fields linked to multiple select fields
• Support for filtering lookup fields linked to number fields

For formula fields, we’ve added:

• Support for collaborator field
• Filter support for formula referencing multiple collaborator fields

Learn more about filtering in Baserow.

Export publicly shared view

You can now export Baserow data directly from publicly shared views. Each view can be configured to allow or restrict data exports. This feature is available for Premium users.

Learn more about public sharing.

Distribution aggregation for Field Summaries

The new Distribution aggregation type, a collaborative community contribution by Jose Mando Alvarado and Abdalla, enhances Field Summaries by displaying the top ten most frequent values in a field.

This feature displays both the count and percentage distribution of values, making it easier to identify the most common field values and understand data patterns or trends.

Learn more about Field Summaries.

Application Builder new styling options

The Application Builder has several new options in the theme section:

→ Font weight control: You can now adjust text elements with different font weights, including light, regular, medium, and bold options.

→ Custom colors: Define custom colors in theme settings to better match your brand guidelines or create unique visual designs.

→ Border radius customization: Adjust the roundness of element corners to match your design preferences.

→ Spacing control for the Repeat element: Fine-tune the layout of repeated elements with new horizontal and vertical gap settings.

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.

Query parameters for pages

The Application Builder now supports optional query parameters in URLs, enabling pages to load dynamic content.

For example, when displaying order details, you can use query parameters like ?status=pending to filter e-commerce orders. You can combine these with path parameters for more sophisticated data filtering and display options.

Learn more about the page settings.

Enhanced security for Application Builder

We’ve improved Application Builder security by limiting API responses to only return Data Source fields used on specific pages. While the backend can still return Data Source Context fields, this ensures users only receive data they have permission to view.

These security enhancements ensure that your application’s data remains protected while maintaining the flexibility needed for collaborative work.

Company news

Boost your manufacturing performance!

🏭 Join us next Thursday, February 13th at 4 PM CET for a hands-on webinar on digital excellence in manufacturing. Learn to implement SQCDP, Andon, and Gemba Walk processes through smart digital solutions. Ideal for plant managers, operations leaders, and continuous improvement teams.

Register now to secure your spot!

Baserow Academy

📚 We’re excited to announce that our Advanced Academy Course is now live!

Master formulas, explore API integration capabilities, harness AI tools, and learn pro tips to optimize your workflows.

Perfect for:

• Power users ready to unlock advanced features
• Teams looking to optimize their workflows
• Anyone wanting to take their Baserow skills to the next level

Ready to become an advanced Baserow expert? Level up your Baserow skills!

Intellyx award

We’re thrilled to announce that Baserow has received the prestigious Digital Innovator Award from Intellyx! 🎉

Competing against dozens of companies focused on innovative technology solutions and digital transformation, Baserow earned recognition as a Digital Innovator. 🏆

Get the details!

What’s next

The next big features on the roadmap include an analytics dashboard, field level permissions, Airtable import improvements, 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!