Changelog

Event handlers: run script​

You can now run JavaScript with side effects directly inside of an event handler without having to create and manage a separate JavaScript Query.

Previously, if you wanted to run JavaScript with side effects—like triggering a query query1.trigger() or downloading data utils.downloadFile(…)—you had to create a new JavaScript query, write your code, save your query, and wire up a “Trigger query” event handler.

To streamline this common workflow, you can now write custom JavaScript code directly in your event handler with the new “Run script” action. You can utilize Retool’s full JavaScript API that allows you to control components (e.g. modal.open(), table.selectRow(index), input.setValue(…)), show notifications utils.showNotification(…), set temporary state state.setValue(…), set key/value pairs in local storage localStorage.setValue(…), and more. Check out this guide to learn more about what you can do with JavaScript in Retool.

Additional API methods you’d like to see us add? Any other feedback while working with “Run script” or JavaScript queries? Drop us a note at support@retool.com.

Fixes and improvements​

• Added a Divider component to create a horizontal rule
• Fixed the keyboard shortcut ⌘+C (CTRL+C) to copy text from an input component while in editor mode
• Added support for Snowflake OAuth at the user level
• Added new tooltips for components that render error messages in context, replacing the generic “has an error in property” warning
• Fixed the "run query automatically when inputs change" setting so that it’s not overwritten for imported queries
• Added the ability to automatically paginate Stripe queries
• Fixed a flash of content rendering issue in the inspector when selecting multiple components
• Fixed a rendering issue with the user menu for embedded apps
• Removed redundant fields in the app YAML serialization
• Added 5+ different design polish improvements to the Resources page

Protected apps (Enterprise only)

• Improved publishing and unpublishing releases
• Fixed an edge case when protecting an already protected app

Check out this guide to see the on-prem versions and their release notes. These features will be rolling out to on-prem customers in the next few weeks.

New canvas frames and a Navigation component​

We’ve removed the Retool header from end user mode, giving you full control over your app’s presentation. User-specific actions have moved to a new location, and we’ve introduced a new sticky header frame, along with a Navigation component for building your own custom headers.

Editor mode

Floating user menu​

In end user mode, Retool-specific actions have been moved to the floating menu in the lower left corner of your apps. Here your users can navigate to different Retool apps, edit their user settings, logout, and more.

If you are viewing an app where you have edit permissions, you’ll still see a Retool header above your app with editor-specific actions. End users will not see this.

Header frame​

The canvas area is now split into two frames: Header and Main. Put any component into the Header — including the new Navigation component — and your app will have a sticky header.

Navigation component​

The new Navigation component allows you to configure a list of menu items and submenus. Each item can open another app, link to a URL, run a query, and more. You can also add a logo, control alignment of the menu items, and style it all via the Style Editor. With modules, you can even reuse your Navigation across multiple apps.

Configuring the Navigation component

The Header frame and Navigation component will be rolling out in one of the next stable releases for on-prem customers, but is available today for all cloud customers.

Fixes and improvements​

• Improved performance of component interactions by 2x for applications with a large number of components
• Fixed arrow keys to use the new row height when moving a component up or down
• Fixed the order of menu items in the Navigation component after using the inspector
• Polished design in various places in the editor
• Improved initial render time for apps with many input components
• Added the ability to change your first and last name in Account Settings
• Fixed event handlers for generated Forms
• Fixed S3 file downloads of non-binary type files
• Added the ability to input Redis commands in raw format, similar to redis-cli
• Fixed editor keyboard shortcuts when certain input components have focus
• Added the ability for editors to set a description for module inputs
• Fixed Form's "clear after submission" option with new input components
• Fixed spacing around components inside of a ListView
• Added additional user metadata to the Releases and History modal
• Added a warning when additional configuration is needed to connect a Google Sheets resource

Check out this guide to see the on-prem versions and their release notes.

New input components​

We’re rolling out 15+ input components, redesigned and rebuilt from the ground up. These include a full overhaul of components like Text Input and Checkbox, along with completely new inputs like Segmented Control and Range Slider.

Each component offers brand new configuration options, built-in and custom validation rules, and expanded style editor support. We’ve also built these components with accessibility in mind, with features like focus states, full keyboard and screen reader support, and automatic text color selection.

Along with these new components, the grid is also getting major upgrade: we’ve introduced a significantly reduced row height that allows for greater data density and more fine-grained layout control. The height of all new components is automatic and dynamic: growing as you add options to a Radio Group or type in a Text Area, and enabling validation errors to be rendered inline.

These components support their original functionality along with new features like:

• Text Input

  • Simplified inspector with many options split out into separate components
  • Configurable prefix and suffix text or icons, autofill behavior, and more

• **Text Area **(formerly part of Text Input)

  • Controls for number of lines and auto-grow as the user types
  • Optional character count display along with min/max validation

• **Number Input **(formerly part of Text Input)

  • Automatic formatting based on the locale in your browser settings
  • Support for any 3-letter currency code, with the ability to override default display
  • Optional increment/decrement steppers, alignment options, and more

• Inputs preconfigured to get you started more quickly

  • Email and URL configurations of Text Input
  • Currency and Percent configurations of Number Input

• Select inputs

  • Segmented Control
  • Radio Group
  • Checkbox and Checkbox Group
  • Switch (formerly Toggle) and Switch Group

• Password Input

  • Optional show/hide password toggle
  • Regex validation and autofill types

• Sliders

  • Slider for selecting single value
  • Range Slider for selecting a start and end value
  • Rating, with support for 3 different icon sets — stars, hearts, and smileys

• In addition, all new inputs support:

  • APIs to set, clear, and validate an input's value via an Event Handler or JS query

  • Tooltips with GitHub Flavored Markdown and styles based on the app theme

  • Control over label position, alignment, and wrapping

  • Validation rules including custom logic and inline error messages

You can find all of these components in our new compact and reorganized component list that features improved search. Old versions of these inputs have been deprecated, but existing instances will not be affected. If you want to continue using them, turn on the "Deprecated components" switch on the Beta settings page to see the “Deprecated” section in the components list.

Drop us a note with any feedback (or requests for new components!) at support@retool.com.

Utilities​

Whether you’re prototyping a new idea or just want to get a CRUD app up and running, we now have 20+ developer utilities to help you build faster. Starting just with a CSV, you can generate a REST API on top of your data, write your data back to PostgresSQL or MySQL, or even autogenerate a CRUD app. We also have plenty of public data sets to get you started.

Check out the full set of utilities and start building today. Any others you’d like to see? Drop us a note at support@retool.com!

Fixes and improvements​

• Added a 'Submit feedback' option to the help menu to send product feedback directly to the Retool engineering team
• Added a keyboard shortcut ⌘+J (CTRL+J) to show/hide the query editor (bottom panel)
• Fixed the style editor for Modal components
• Fixed Date/Time components min and max to use UTC time when 'display in local timezone' is not selected
• Added back the ability to delete and duplicate transformers and analytics from the query editor sidebar
• Fixed loading spinners that weren’t visible for some components
• Fixed styling for URL parameters in REST queries
• Fixed self-hosted trials that were expiring at the incorrect date
• Added a OneSignal integration
• Added support for current_user.metadata when using custom HTTP Auth with REST
• Improved search in the components list

Enterprise plan

• Added an environment variable–DISABLE_INTERCOM–to swap email support for default chat support
• Added a button in the Advanced settings tab to refresh your license key
• Protected apps
  • Fixed the 'protect page' modal to properly dismiss on branches other than 'main’
  • Improved autogenerated PR descriptions
  • Added entries in the History modal for resetting branches and merging pull requests

Check out this guide to see the on-prem versions and their release notes.

Undo/redo​

We’ve completely overhauled the undo/redo system in the Retool editor. You can now reliably undo and redo nearly any action, including:

• Creating, renaming, or deleting components and queries
• Editing queries or component properties
• Any layout operation (including copy and paste)

History​

The History modal lets you view changes and revert apps to a prior state. Until now, the list included many entries (e.g. “minor changes”) that made it difficult to pinpoint exactly what had changed. We’ve added human-readable descriptions for every action and consolidated entries, making it easier than ever to identify your changes and jump back to the right moment.

Fixes and improvements​

• Improved load times for our components
• Fixed S3 download queries that would fail for certain file types
• Fixed an inconsistent default sticky header setting
• Fixed the utils.downloadPage API
• Fixed Snowflake queries to correctly estimate their size
• Improved error messages for bulk user invites
• Added the ability to ⌘+click (CTRL+click) on a query, component, or state name inside {{ }} to see its value in the model browser
• Improved permissions for resource creation
• Fixed queries triggered by a Navigation component in a Module

Enterprise plan

• Added a configuration option to disable public pages
• Added a new page–Environment Variables–in Settings for debugging (Beta)
• Protected apps
  • Added the ability to protect and unprotect apps from the actions menu
  • Fixed the commit changes modal to display changes since the last commit, instead of against the main branch
  • Improved autogenerated PR descriptions

Check out this guide to see the on-prem versions and their release notes.

Performance​

We recently fixed a long term issue that was negatively impacting Retool performance, caused by inefficient transmission of data between our parent application window and our JavaScript evaluation sandbox. We’re now seeing up to 10x faster query result speeds for many Retool apps, especially those with significant data fetching and {{}} usage.

To complement this improvement, we’ve also started to expose some performance metadata directly in the query editor. Hover over query’s runtime in the left panel of the query editor and you’ll now see a performance breakdown for that query. You can inspect each step from when a query is triggered to when the data is processed on the client—making it much easier to debug slow queries.

The performance tooltip will be rolling out to users over the next week. Drop a note to support@retool.com and let us know how it’s working for you.

Self-hosted Retool​

If you’re working with sensitive data or in a highly regulated industry, your internal tools almost certainly need to run on your own infra. For developers in this camp, we’ve just introduced much easier paths to spin up self-hosted Retool: 1-click deployment to AWS, a k8s install script, and deployment as a Docker container to any service (Heroku, Render, etc.). Get started now and build Retool apps on your own infrastructure in less than 10 minutes.

Fixes and improvements​

• Fixed the app “Preview” button to wait for all changes to save before switching to preview mode
• Fixed the “allowed inputs” validation for certain types of the TextInput component (e.g. percentage, number, currency)
• Added a toggle on custom components to enable the allow-modals sandbox option
• Fixed the Scanner component's image preview on mobile
• Fixed failure conditions in a query's “Response” tab so that they’re no longer shown when the setting is toggled off
• Upgraded the Presto integration JDBC driver to v350
• Added support to the Presto integration for the source connection parameter
• Removed license key checking for airgapped deployments
• Added support for audit log entries when Resources get created, updated, or deleted (Pro plan and above)

Enterprise Plan​

We’ve been shipping improvements to Protected Apps over the past few weeks and all of those changes are now live on the latest stable build, 2.69.17–check out this guide to upgrade your Retool instance.