baserow

New features

• [Database] Improve websocket management when the connection is lost #1924
• [Database] Drag and drop ordering of sortings and group bys. #2355
• [Database] Add clear button to the view search #2753
• [Builder] Add burger variant to menu element #3579
• [Builder] clear single-select record selector #3719
• [Database] Show cell editing in real-time in the grid view #3794
• [Core] Add to_json() and from_json() expressions. #3879
• [Database] Add support for importing Excel files into database tables
• [Database] Adds options to leave out the row ID and primary field columns when exporting data #4680
• [Database] Show matching restricted view filters and allow setting default values #4926
• [Core] Added new runtime formulas: number_format(), abs(), null(), to_duration(), and to_datetime(). #4974
• [Builder] Improve drag and drop UX #5143
• [Database] Import into an existing table is now available from the table context menu in the sidebar. #5284
• [Database] Adds option to keep synced rows when they are deleted or hidden in the source table. #5327
• [Core] Added the duration_format() advanced formula, arithmetic support for durations, and an optional duration format argument for the to_duration() function. #5420
• [Integration] Add code service to execute arbitrary JavaScript code in workflow/builder #5424
• [Core] Show the 2FA status in the admin user list and allow instance admins to remove a user's two-factor authentication. #5492
• [Integration] Add batch operations for create/update/delete rows #5543
• [Core] Added the range() runtime formula. #5559
• [Integration] Add a Start workflow action to builder and automations #5561
• [Integration] Add manual trigger to automations #5561
• [Database] Changes to linked tables, formulas and lookups now appear without refreshing #595
• [Database] Add sort to kanban view #764
• [Database] Accept object with ID property as valid value for single/multiple select and link row fields
• [Integration] Add CSV reader service for builder and automations
• [Core] Add members management to builder applications, automations and dashboards
• [Core] Add WebSocket connection and disconnect metrics
• [Integration] Add XLS[X] reader service for builder and automation
• [Automation] Added a new workflow trigger which only executes when specific fields' values change in a table.
• [Database] Adds a "starts with" filter for text fields #1943
• [Builder] Adds Column element layout presets
• [Builder] Allow to click on checkbox label to check them for more browsers
• [Builder] Allow to test actions in preview mode to capture the output
• [Database] Collapse and expand groups in the grid view when grouping by one or more fields. #2257
• [Core] Enables caching by default for improved performance
• [Core] Hardened workspace invitation emails and user name validation to prevent phishing abuse
• [Database] Introduced drop_tsv_columns management command that can drop the tsv_field_* columns that are not used anymore.
• [Builder] Introduced undo/redo and trashing in Application Builder for pages and elements.
• [Automation] Added methods, hooks, and model to track automation usage. #5263

Bug fixes

• [Database] Replace placeholder example data in the JSON and XML import dialogs with clearer contact records so users can see a typical table import format #2953
• [Builder] Show a loading overlay on application builder table elements while ad hoc filters, sorting, or search results are loading. #3510
• [Database] Shows the circular field dependency error in the lookup field form. #3637
• [Core] Fixed a bug where backslash chars couldn't be entered into the formula field. #3720
• [Integration] Set a timeout for the SMTP email service. #3867
• [Integration] Ensure control characters are allowed in the JSON payload of an HTTP request. #3879
• [Database] Fixed flaky formula tests caused by randomly generated field names containing apostrophes #4217
• [Database] Formulas and lookups through a link to the same table now update when the linked row changes #4541
• [Builder] Ignore hidden form field when validation form container submit #5203
• [Core] Prevent expected websocket keepalive timeout logs from being reported to Sentry. #5224
• [Builder] Ensure user roles use locale-aware sorting. #5268
• [Database] Fixed count() returning an array instead of a number for link row fields whose linked primary field is an array formula or lookup. #5276
• [Core] Use the real client IP address in OpenTelemetry request traces when proxy headers are present. #5277
• [Database] Fixed a bug where changing the primary field to a hidden field could keep it hidden in the grid view. #5288
• [Database] Skip invalid formula fields in the periodic field update task. #5298
• [Database] Detect Jira deployment type #5306
• [Builder] Fix custom code editors when deleting the first line #5310
• [Database] Fixed index(), first() and last() formulas crashing on partial arguments. #5320
• [Database] Fixes inserting rows above or below in restricted views #5344
• [Database] Fixed periodic recalculation of formulas that depend on now() across linked tables. #5370
• [Database] Fix periodic field update crash after deleting a field referenced by a formula chain #5371
• [Core] Fixes a server error when submitting an invalid email verification token #5374
• [Core] Hide workspace import/export options for Builder and lower roles. #5440
• [Database] Fix duplicated rows scaling comma-decimal formatted number values #5445
• [Database] Fix airtable import when CDN omits Content-Length #5472
• [Core] Fixed the application icon when duplication an application. #5483
• [Database] Fix MCP create_rows failing when table has rich text fields with @mentions #5493
• [Database] Fix undo/redo failing with PermissionDenied for editors on restricted views #5506
• [Database] Allow invited editors to drag and drop cards in a restricted Kanban view #5568
• [Core] Fixed formula function help tooltips appearing below the data explorer. #5593
• [Core] Accepting a workspace invitation no longer changes the role of an existing member
• [Builder] Add proper error when an InvalidFormulaError is raised
• [Database] Added permission check to unique field values endpoint.
• [Builder] Check permission on the element provided during a collection element data source dispatch
• [Builder] Custom CSS and JS in published applications no longer require !important to override styles
• [Core] Fix backend memory leak by updating Python to 3.14.6
• [Automation] Fix broken workflow after node replacement
• [Dashboard] Fix error when summarizing any array shaped field
• [Automation] Fix export workflow with periodic triggers
• [Integration] Fix importing applications with an SMTP integration that has blank credentials
• [Database] Close the BZPOPMIN client when an MCP server connection is closed.
• [Builder] Fix missing data during dispatch because of previous page visibility
• [Builder] Fix missing data source content in collection element in page headers or footers
• [Database] Fix multiple select field no value in row edit modal.
• [Core] Fix spurious internal error logged when an MCP connection closes
• [Core] Fixes a 403 error that could appear when impersonating a user from the admin area
• [Integration] Fixes a crash when opening user source settings in the application builder
• [Core] Fixes a crash when typing into inputs that unmount during an event
• [Builder] Fixes a file upload error when updating a row that keeps an existing file
• [Core] Fixes a guided tour crash when the highlighted element is not on the page #5377
• [Database] Fixes a server error when adding a sort or grouping to certain views
• [Database] Fixes a server error when creating or importing a table with malformed data #3950
• [Database] Fixes an empty option showing at the top of link-to-table dropdowns in forms #5549
• [Automation] Fixes automation runs not recording the real error when a node hits a database problem
• [Core] Fixes background tasks being stopped early by the default time limit
• [Database] Fixes link row Add new modal showing premature errors and crashing on URL formula fields #3940
• [Database] Fixes multiple select filter options not showing as selected
• [Database] Fixes periodic field updates being stopped before they finish
• [Database] Fixes search index updates failing for tables with date-only formula fields #5363
• [Database] Fixes the link to table field not showing the view it is limited to when editing
• [Builder] Improve column element and data picker style for small screens
• [Database] Improve permissions endpoint query performance by using union instead of OR.
• [Database] Improves escaping of URLs and user input in database views
• [Database] Lets you type negative numbers when filtering by rollup field #3925
• [Database] Moving a row no longer modifies the updated_on value #3054
• [Core] Only delete a workspace on account deletion when a deleted user was its last admin
• [Core] Prevents a malicious display name from running scripts in rich text mentions
• [Database] Prevents spreadsheet formula injection in CSV and Excel table exports
• [Core] Real-time updates now recover when the window is refocused and keep retrying after repeated failures, instead of getting stuck asking to refresh
• [Builder] Resolved a bug in application builder where deleting a row would display an error message.
• [Builder] Resolved a bug which caused invalid expressions to not be styled as invalid.
• [Builder] Resolved a bug which prevented custom favicons from appearing in previewed and published applications.
• [Integration] Resolved a bug which prevented workspace exports from Baserow cloud to be imported into self-hosted environments if a specific generative AI model was chosen.
• [Core] Resolved a sporadic 'querySelector' error which appeared after a dependency was upgraded.
• [Core] Restores real-time updates when returning to an idle tab instead of asking to refresh
• [Database] Search updates now retry automatically after a temporary database connection error
• [Database] Shared and restricted views now update formula, lookup and link cells when related rows change #5657
• [Database] Show the required-field error for an untouched, empty duration field when submitting a form #5422
• [Database] Show unnamed row label for empty linked rows in form dropdowns #5422
• [Database] Show unnamed row label in row history instead of empty boxes #3674
• [Core] Stops invalid MCP requests from being logged as server errors
• [Core] Upgrades backend dependencies to fix known security vulnerabilities

Refactors

• [Database] Speed up loading rows for tables with many single or multiple select fields.
• [Core] Bump to Nuxt4 #5162
• [Automation] Remove Node ID in dispatch errors since the error is scoped to the node history. #4800
• [Core] Refactored the Core HTTP Request service type to return a status code for timeouts. #4973
• [Builder] Removed the unique constraint on Builder page names. #5042
• [Automation] Make AutomationWorkflowHistory.original_workflow non-nullable. #5236
• [Automation] Improved the performance of the Automation Workflow and Node history. #5239
• [Automation] Introduce min retention days for history to keep more entries for recent workflow runs. #5249
• [Automation] Allow to customize history entries from plugins #5616
• [Automation] Added the Slack icon to Node History entries.
• [Database] Field type column conversion in Postgres function instead of pg_temp.
• [Core] Improve error handling in frontend
• [Database] Improve list views endpoint performance when there are many views and fields.
• [Core] Improved the frontend error message to be more specific.
• [Database] Optimize pending search update scheduling for large imports and syncs.
• [Core] Replace custom moveToBody mixin with Vue 3 built-in Teleport component.

Breaking API changes

• [Database] Moving a row no longer updates the row's updated_on field. Last modified fields tied to updated_on (and formulas depending on them) are no longer recomputed when reordering rows. #3054