⚠️ This release of Budibase will trigger a migration process for each app when first accessed. This is to move to a new search subsystem for any internal tables. Apps will be inaccessible during the migration, and we expect the migration to take a few minutes (longer if you have a lot of rows in your internal tables, e.g. tens of thousands).

What's Changed

• Extend available labels for feature branch deployments.
• Fix all or property.
• Allow sorting by calculation fields.
• Allow BB_REFERNCE_SINGLE to have default values.
• Fix searching by bindings when those bindings have been stored in the view.query field.
• Fixing issue with base permissions of tables.
• Add on click events for grid layout containers.
• Support default values on multi-user columns.
• Fixing inconsistent column schemas.
• View joins with any and all not working correctly.
• Release SQS for self-host users (single image, docker compose, Kubernetes).
• Move conditionals to env section.
• Write Redis data to the persistent data dir in single image.

Introducing an easier way to build interfaces with Budibase with the new Grid layout. The Grid layout offers dynamic drag-and-drop functionality, letting you move and resize components across your screen with ease. Creating powerful and visually appealing applications in minutes has never been easier.

To get started, simply select the new Grid layout option in your screen or container settings to try it for yourself. All new applications will use the Grid layout by default.

Note: The biggest limitation of drag-and-drop layout systems (especially compared to Budibase's normal layout system) is the lack of responsiveness - i.e., they don't automatically work on mobile.

To solve this, the new grid layout system "remembers" the position and size of your components for both large (desktop/tablet) and small (mobile) previews. So to design a screen for mobile, just swap to the mobile preview and move your components around to design the screen as you want on mobile.

This release improves Automations by enabling file attachments, further pushing the limits of what's possible with Budibase.

Key updates include:

• Downloading Files from APIs: Seamlessly import files from various APIs into your workflows, integrating external data and documents effortlessly.
• Attaching Files to Emails: Boost your communication by sending automated emails with attached reports, images, and documents.
• Saving Files to Budibase DB: Securely store and organize documents and images directly in the Budibase DB.

We have created a comprehensive guide that showcases two exciting workflows that have been unlocked with this release. Check it out to learn more!

Note: The attachment feature is currently exclusive to Budibase's internal DB.

This update introduces powerful new features to the table functionality, including multi-cell selection, copying, pasting, deletion, and row duplication. These enhancements aim to provide a more intuitive, spreadsheet-like experience for data manipulation within Budibase.

New Features:

• Multi-cell Selection: Select multiple cells using click-and-drag, shift+click, or arrow keys with shift.
• Multi-cell Copy & Paste: Copy and paste multiple cells (max 50 rows, unlimited columns) using ctrl+c/cmd+c/v or by right-clicking “copy/paste” in the context menu.
• Multi-cell Deletion: Delete multiple cells at once (max 50 rows, unlimited columns) using delete, backspace, or by choosing the right-click menu option.
• Multi-row Duplication: If you have multiple rows selected (which you can now do by holding shift and selecting another row), then you'll get a new option in the context menu to duplicate all those rows.

Enhancements:

• Progress Indicators: Real-time bar for all multi-cell operations, offering insight into the expected duration of the process.
• Error Handling: Graceful error handling on a per-row basis, with detailed notifications on successes and failures.
• Code Refactoring: Improved performance, reduced redundant updates, and enhanced column handling logic.
• Visual Improvements: Fixed pixel inconsistencies and gaps and improved the handling of long field names and text overflow in settings popovers.

Fixes:

• Resolved issues with long field names in settings popovers.
• Addressed text overflow problems in settings popovers.

With conditional formatting, you can now create rules that dynamically change the format of your cells. For example, when the value of a cell is set to “Done,” you could set up a rule so the cell's background turns green, improving the “at a glance” experience of your data.

Conditional formatting rules are set at the column level, while the formatting is set at the row and cell levels. These rules allow you to change the cell's background color or text color based on the values set in the rule.

To try conditional formatting for yourself, upgrade to the latest version of Budibase today.

A new Generate button has been added to the table menu in the Data section in Budibase.

Clicking the button presents two options:

• Automation: when row is created - will create a new Row created trigger automation with the current table preselected
• Automation: when row is updated - will create a new Row updated trigger automation with the current table preselected

The "Update Row" automation has been refined for a cleaner and more intuitive user experience. Previously, all fields in the table were displayed by default, leading to a cluttered interface. With this update, you now have the option to manually select the fields you wish to update, reducing unnecessary complexity and improving usability.

To learn more, and to see screenshots of this functionality, click here.

We are excited to introduce the new Modal component in Budibase. This feature enables a pop-up modal to appear on your screen when triggered by an action, such as a button click. It functions similarly to the existing Side Panel component but is designed for different use cases, such as confirmation dialogs, notifications, form inputs, and more.

Key features:

• The modal will be centered on your screen by default for optimal visibility.
• Choose from four different size options to suit your needs:
  • Large: 800px * 600px
  • Medium: 600px * 400px
  • Small: 400px * 200px
  • Full screen: 100% * 100%

You can find the new Modal component under Layout in-app.

Please note that modals block interaction with the rest of the app until users perform an action to dismiss them, so we recommend using them sparingly.

View filters will now have access to bindings. This release allows you to create dynamic views. For example, you could tailor a view to the current user or a specific time frame.

You can use the following bindings in your filter to achieve this:

• {{ Current User }}: Represents the currently logged-in user. This provides access to the full user object.
• {{ Date }}: Represents the current date.

The bindings aren't limited to just these use cases, so hop in-app to explore them for yourself.

Previously, when updating the visibility of a column in a View, you only had two options - Show and Hide. The main concern here was that if you could view a column, you could also edit it, and that might not always be the desired behavior.

To tackle this, we're updating Views to have three visibility options:

Hidden: The user has no access to this column.

Read Only: - The user can view the data, but does not have permission to edit the data in any way.

Writable: - The user has full permissions and can both view and edit the data.

🔒 Please note that this is a premium-tier feature. Please visit our pricing page for information on how to upgrade.