Baserow 1.26: Scan files with AI, new Application Builder styling options, and more

Today we are launching Baserow 1.26, which includes a new addition to Baserow AI: file field support! Leverage AI capabilities with files and documents to improve data processing and analysis without leaving your workspace.

Additionally, we’ve introduced new styling options for the Application Builder. These enhancements give you more control over the look and user experience of your Baserow applications.

Plus, we released many other exciting new features and developments! Here’s what’s new:

File field support for the AI field

Now, you can use documents, invoices, and other text based file types to leverage AI insights directly in Baserow. This new feature allows you to use files directly within the AI field, enabling more comprehensive and faster data analysis.

AI file support can be used for retrieving information, classifying data, generating text, summarizing content, and other similar tasks.

To leverage files in the AI field, select an AI type and model from the list, and connect a file field in the “File Field” section. Next, click on the “Prompt” field in the context menu, and type how you want the AI to process the connected file. Finally, click the blue “Create field” button. Each line in the table will have a “Generate” button. Click the button where you want the AI to start generating prompts.

New styling options for Application Builder

Customize the appearance of your applications with new theme settings. These styling options allow you to create more personalized interfaces for your data stored in Baserow.

You can now set styling at both the application level and the element level.

Theme settings let you configure Colors, Pages, Typography, Button, Link, and Image styles at the application level. To set the theme settings, click on the three dots next to the application name and choose “Settings”. In the modal that opens, click on the “Theme” section to start configuring the styling options.

To style elements individually, select the element you want to customize. Next, find the settings icon on the right panel, and see a modal with available element styling options open. Various styling options are available depending on the element.

Link to table field limit selection

This feature allows you to limit the selection of linked table rows to a specific view, providing more control over data relationships and ensuring users can only select relevant rows.

To limit selection to a view click on the linked table field you want to configure. In the field settings, scroll to the “Limit selection to a view” option and select the desired view from the dropdown menu.

Visibility roles for Application Builder

This update enhances the “Visibility tab” in the Application Builder. The new feature lets you show or hide elements based on a user’s role. These visibility roles provide greater flexibility and control over who can access specific parts of your application, improving both security and user experience.

To set up visibility roles, first, specify a new “Role Field” in the User Source settings. Then, in the element “Visibility tab”, for logged-in or logged-out users, you can choose: Allow all roles, Allow all roles except, or Disallow.

Choice element for Application Builder

We renamed the Dropdown element to the Choice element to better represent its new functionality, which includes displaying a list of radio buttons or checkboxes.

This new version also allows for the selection of multiple items to fill multi-valued fields.

Additionally, you can now populate the options from an existing list provided by the page’s data sources.

To add a Choice element, go to the Application Builder, click “+ Add Element”, and select “Choice” from the dropdown menu. Configure the options from existing data sources. For multiple selections, you can also choose either radio buttons or checkboxes instead of the dropdown.

Other new features and updates

• Ability to delete rows in the Kanban and Calendar views
• Linked primary fields are now fully shown (not truncated)
• Repeat element support for form elements

Company news

Baserow CEO interview on impact of no-code development

In this interview, Bram Wiepjes, CEO of Baserow, discusses the future of no-code development. Discover how Baserow’s open-source tools are transforming data management and business automation, enabling teams to overcome SaaS constraints. Bram shares the platform’s mission, latest advancements, and his leadership’s impact on Baserow’s growth in the no-code industry.

Check it out!

SureTriggers Integration

Automation platform SureTriggers now integrates with Baserow, enabling you to sync data from Baserow to over 600 apps using triggers and actions within SureTriggers.

Start integrating

Baserow Community’s Brazil chapter

Our ambassador, Luiz Eduardo Oliveira Fonseca, who leads the community’s Brazil chapter, organized the first Baserow meetup for Portuguese speakers.

Watch the recording!

Community tutorials and events

→ Check out how to convert Baserow or Airtable rich fields text to HTML to use in Webstudio CMS from SelfHostCreators | 360Creators.

→ [Spanish] Discover how to create the backend to manage profiles in Baserow. By Maobits LLC.

→ [Portuguese] See how to mass fire on WhatsApp using n8n, Baserow or Sheets, and evolution API from Aurelio Castro.

→ [Portuguese] Learn how to enhance your service: Artificial Intelligence with WhatsApp, Baserow and N8N from Aurelio Castro.

→ Discover how to connect your Baserow Workspaces to ncScale. By ncScale.

→ Check REST API CRUD App & API Best Practices, feat. Baserow. By AppSmith.

→ [Portuguese] Discover perfect approach in Typebot with Baserow — how to check if the lead already exists in the database. By Imperador de Sonhos.

→ See code Screenshot Generator App Feat. OpenAI, Baserow And Showcode.app. By AppSmith.

→ [Portuguese] The end of Google Sheets. See how to install Baserow, step by step, from Imperador de Sonhos.

→ [Portuguese] Check out how to create Rapier App using Niotron and Baserow from Ju Oliveira Apps.

What’s next

The next big features on the roadmap include Timeline View, data sync, advanced permissions for Application Builder, additional styling options for the 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!

All changes, including bug fixes

New features

• Limit selection of link to table row to a view. #1242
• Improved application styling capabilities #2388
• More styles of the builder elements can be customized #2388
• Allow choice element options to be populated from formulas #2489
• Add support for controlling Element visibility via User Roles in the Element’s Visibility Tab. #2498
• Added support for form elements within a repeat element. #2636
• Add ability to delete row in calendar view #2722
• Show full name of relationships #1751
• Add ability to delete row in kanban view #2179
• Add Celery Flower #2255
• Serve files from the backend to authorized users and/or with temporary links. #2474
• improve dropdown element to allow multi selection #2515
• Rename dropdown element to choice element and allow to display element as dropdown/checkbox/radio #2517
• Add responsive behavior configuration for table element #2523
• Allow syncing only a specific subset of templates #2611
• Enable single level nesting of filter groups within existing groups #2646
• Support file field as knowledge base for AI prompt #2649

Bug fixes

• Ensure that Context menus can be opened for input fields that are fully within the viewport. #2013
• Generate file name for files uploaded by url where URL doesn’t contain any path. #2738
• When POST/PATCH operation on a row receives body other than a dict, HTTP 400 will be returned. #2740
• Fix multiple usage of filename contains filter #2746
• Show a notification of a 500 error in the frontend #2754
• Date field now can be cleared when a row is edited as a form. #2764
• Fix a bug causing the ‘not_empty’ view filter showing empty rows for link to table fields. #2777
• Resolved an error where data source filters and sortings wouldn’t work properly when they were targeting a trashed Baserow field. #2790
• Prevent last_login update if the last_login time diff is < 1 minute
• Resolved an issue where moving elements stopped working from the element menu. #2619
• Fix formula migration for elements inside a repeat element #2648
• Resolved an issue where a refresh data source action being executed would cause duplicate entries to appear in a repeat element. #2652
• [Builder] Resolved an issue where deleting a page when a table element in a different page relied on it would trigger an error during application duplication. #2656
• Resolved an issue with duplicating a page containing a table with one or more columns of ‘tags’ type. #2664
• Fix a bug in the formula language causing the filter condition to be ignored when aggregating values. #2666
• Resolved an issue which prevented the Open Page action from accessing the ‘Previous action’ provider. #2707
• Fix page parameter type to make possible to use them in linked row field of update row actions #2708
• fix for UUIDFieldType that fails hard if filtered by ContainsViewFilterType and a non-UUID string #2713
• Restored prior field form behavior: pressing enter when in field form elements won’t spuriously open field description input anymore. #2715
• Fixed bug with incorrect row ordering for editors and lower in views with group bys. #2726
• Fix missing field validation error messages
• Fix periodic field update deadlock problem with tsv column update.
• Markdown content is generated on the server and can be indexed by search engine
• Resolved an issue where duplicating an image element pointing to a file would not work correctly.

Refactors

• Refactor formInput, formTextarea, formGroup components #1918

• [Builder] Make Element tag’s appearance more rounded. Change Publish app’s Open Tab action to use the open-new-window icon. #2705

• Display all elements in the ‘add element’ modal, and instead disable those which are unavailable. #2607

• Remove vim and nano from dependencies #2633

• Update posthog-js library to 1.136.2.