Baserow 1.10: Undo-redo, row coloring, cell paste, and more

What’s new in Baserow 1.10?

Baserow 1.10 is here! We’re excited to wrap up another productive few months. In this update, we’ve added some great new features like multiple cell paste, batch API endpoints, undo-redo functionality, row coloring, and Zapier integration. We’ve also made some updates and fixed minor bugs.

![Watch video][4]

What’s new and improved in Baserow:

Multiple cell paste

You can now paste multiple cells in Baserow! Simply use the CMD/CTRL + V command to insert data quickly and efficiently.

https://baserow-backend-production20240528124524339000000001.s3.amazonaws.com/pagedown-uploads/1.webp

Undo-redo functionality

The long-awaited undo-redo feature is finally here! Use the shortcuts CMD/CTRL + Z for Undo and CMD/CTRL + Shift + Z for Redo. Alternatively, you can click the new undo/redo buttons in the bottom left corner.

https://baserow-backend-production20240528124524339000000001.s3.amazonaws.com/pagedown-uploads/2.webp

Row coloring

Row coloring is now available as a Premium feature in Baserow. You can color records to make them stand out by matching the color of a single select field or using conditions to automatically color records. Colors can appear as flags on the left side of the primary field or as a background color.

Zapier integration

Connect Baserow with your other applications effortlessly using Zapier. You can now perform actions such as creating rows, updating rows, deleting rows, getting single rows, and searching rows. Get started with Baserow workflows on Zapier here.

Community-contributions

We want to express our gratitude to Scott Fortmann-Roe for contributing a fix to percentage aggregation for boolean fields. We appreciate the involvement of our community members! 💙

Largest update to templates to date

This release includes the largest update to templates yet, with over 80 changes across the board. We’ve added new fields, views, tables, and structures to existing templates, as well as introduced some brand new templates.

New templates:

  • Brand Assets Manager
  • Business Conference
  • Car Hunt
  • Company Blog Management
  • Event Staffing
  • Hotel Bookings
  • Nonprofit Grant Tracker
  • Performance Reviews
  • Product Roadmap
  • Public Library Inventory
  • Remote Team Hub
  • Product Roadmap
  • Hotel Bookings

Baserow is now available in Spanish and Italian

To support the growth of local Baserow communities, we’re excited to announce that Baserow is now available in Spanish and Italian. Set up your language preference by going to Settings → Interface Language.

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

Made with Baserow: discover community projects

We’ve created a space where everyone can showcase their projects built with Baserow. Feel free to promote your projects, receive feedback, and inspire others. Check it out here.

All changes and bug fixes

  • Added batch create/update/delete rows endpoints.
  • Fixed translations in emails sent by Baserow.
  • Fixed invalid first_name validation in the account form modal.
  • Shared public forms now don’t allow creating new options for single and multiple select fields.
  • Fixed bug where the arrow keys of a selected cell didn’t work when they were not rendered.
  • Added select new view immediately after creation.
  • Added workspace context menu to sidebar.
  • Fixed Airtable import bug where the import would fail if a row is empty.
  • Fixed occasional UnpicklingError error when getting a value from the model cache.
  • Fixed a problem where a form view with link row fields sends duplicate lookup requests.
  • Pinned backend python dependencies using pip-tools.
  • Fixed the reactivity of the row values of newly created fields in some cases.
  • Made it possible to impersonate another user as premium admin.
  • Added is days ago filter to date field.
  • Fixed a bug that made it possible to delete created on/modified by fields on the web frontend.
  • Allowed the setting of max request page size via environment variable.
  • Added select option suggestions when converting to a select field.
  • Introduced read only lookup of foreign row by clicking on a link row relationship in the grid view row modal.
  • Boolean field converts the word checked to True value.
  • Fixed a bug where the backend would fail hard updating token permissions for deleted tables.
  • Fixed the unchecked percent aggregation calculation.
  • Raised Airtable import task error and fixed a couple of minor import bugs.
  • Added loading bar when syncing templates to make it obvious Baserow is still loading.
  • Fixed bug where old values are missing in the update trigger of the webhook.
  • Scroll to the first error message if the form submission fail.
  • Improved backup_baserow spltting multiselect through tables in separate batches.
  • Fixed a bug that truncated characters for email in the sidebar.
  • The API endpoint /api/database/formula/<field_id>/type/ now requires table_id instead of field_id, and also name in the request body.
  • Added support in dev.sh for KDE’s Konsole terminal emulator.
  • Fixed a bug that would sometimes cancel multi-cell selection.
  • Upgraded node runtime to v16.14.0.
  • Cached aggregation values to improve performances.
  • Added new endpoint to get all configured aggregations for a grid view.
  • Fixed DONT_UPDATE_FORMULAS_AFTER_MIGRATION env var not working correctly.
  • Stopped the generated model cache clear operation also deleting all other redis keys.
  • Fixed bug where the link row field link_row_relation_id could fail when two simultaneous requests are made.
  • Added password protection for publicly shared grids and forms.
  • Made views trashable.
  • Fixed bug where a cell value was not reverted when the request to the backend fails.
  • Fixed row coloring bug when the table doesn’t have any single select field.
  • Dropdown can now be focused with tab key.
  • Added 0.0.0.0 and 127.0.0.1 as ALLOWED_HOSTS for connecting to the Baserow backend.
  • Added a new BASEROW_EXTRA_ALLOWED_HOSTS optional comma separated environment variable for configuring ALLOWED_HOSTS.
  • Fixed a bug for some number filters that causes all rows to be returned when text is entered.
  • Fixed webhook test call failing when request body is empty.
  • Fixed a bug where making a multiple cell selection starting from an empty link_row or formula field was not possible in Firefox.

What’s next?

We’re already working on some exciting new features, including additional importing capabilities, snapshots, form conditions, and duplication. As always, we’ll continue to listen to the community’s suggestions and address any bugs that arise. If you have any questions about the new updates or anything else, feel free to ask in our official community forum. We’re here to help!