Prettify the Database Editor

• Check out our new interfaces!

Empty folders hidden for end-users

• Your users of your apps only see the folders in Retool that have apps that they have access to.
• Developers still see empty folders (so you can add apps to empty folders!)

Noteworthy features and bugfixes

• Retool apps now look nicer by default with better contrast.
• Containers are smaller by default, making them easier to create.
• Fixed: inline <style> tags in Text components behave more consistently
• Fixed: the Audit Logs now renders long context nicely.

UX Improvements

• Reorder columns by dragging on the headers of the Table

• The column option editor is more compact and significantly easier to use

• We've added a new way to scroll through the list of queries you've made

Filter and search through Audit Logs

• Search and filter through the events by page, query, and date in your Audit Logs

• Coming soon: advanced filters by users, query properties, and more.

Free Table refresh and download buttons

• Tables now come with a refresh button for free! Use it to reload the query that the Table it's connected to.
• It also comes with a download button that exports the data as a csv file.

Image component

• To embed images into Retool, just use the Image component
• The button is also clickable; you configure it run queries, open other pages, just like a button!

Autocomplete Dropdowns

• There's now a .searchValue property on dropdowns that allow you to get the currently searched for term.
• This allows you creating autocomplete searchboxes. See below for an example of it in action!

Small, but notable features

• Retool now allows sharing Salesforce credentials between users.
• Tables will now auto-infer data types by default, so dates, numbers, and objects are rendered nicely to start off!
• Reorderable Lists now have a "labels" property, letting users now reorder lists of data with more human-friendly text in the list.
• Allow queries to delaying post-query run triggers. This is useful with datasources like Elasticsearch, or database connections to replicas that might have a small delay in propagation, as the delay lets the datasource catch up with a recent mutation made to the data.
• Retool now supports APIs that make use of the double-cookie submit pattern to protect against CSRF attacks.
• We've made it easier to find the search box for your apps to the home page, or use Ctrl+K or Command+K to open up the search!

Misc new features

• The Modal component can now be optionally configured to close when clicking outside the modal.
• The Timeline component can be configured to render its values as HTML.
• The default timeout on MSSQL queries has been increased to 10 minutes.

Improvements

• Retool can now connect to MongoDB databases through an SSH Tunnel
• Dropdowns now use fuzzy searching when matching results
• Add .reset method to the FilePicker component
• Improved the Date format in Table components to be clearer and more concise
• Improved the Editable Table to use a checkbox when editing boolean columns
• Added the ability to trigger queries after an item is selected in a dropdown

SCIM User Provisioning

• Retool is now generally available on the Okta integration network for both SAML and SCIM User Provisioning.
• Creating, updating, and deactivating users are supported by Retool.
• Syncing Groups and permissions is coming soon!
• Learn more here: https://docs.tryretool.com/docs/scim-user-provisioning

New and Updated Integrations

• CouchDB: We've added support for CouchDB as a database you can connect to. Learn more here: https://docs.tryretool.com/docs/couchdb-integration
• Firestore: We've added the ability to insert and update data in Firestore.
• OracleDB: We've added support for writing SQL to OracleDB.
• Close.io: We've added support for Close.io's API.

Fixed

• The Calendar component displays all events in the local timezone.
• Tables with edited cells now always have "Save changes" button visible.
• The JSON Schema Form component now shows an email input field correctly.
• Improved speed of selecting icons on textinputs
• Added support for OAuth2 to GraphQL datasources
• Fixed bulk updates queries with Redshift datasources
• Fixed various issues with the Denodo integration

Editable Tables

• You can now directly edit values in Tables, just like it is an Excel spreadsheet.
• Learn more about how to configure this over here https://docs.tryretool.com/v2.26.10/reference#section-inline-editing-editable-tables-

Server-side search on dropdowns.

• Search your database as you type with a dropdown.
• Here's a quick example of it in action

GeoJSON on Maps!

• Plot points, lines, and polygons using GeoJSON on Retool's Map component.
• For more info, checkout http://geojson.org/ to learn more about GeoJSON.

Fixed

• Urls do not unnecessarily decode urls in the path.
• Fix importing CSVs in to databases via the Database Editor.

Firestore support

• Retool now supports querying against Firestore.
• For existing Firebase users, you'll need to modify your Firebase connection to also include your projectId
• Here's a screenshot of what it looks like!

Dynamically set toggled properties.

• Any property on components that was controlled via a Toggle (e.g. turning on / off the required property on a TextInput can also be dynamically set!
• You can also swap back to using a normal checkbox too.

SCIM Provisioning

• Retool in on-premise environments now supports SCIM Provisioning!
• To learn more check out our docs here: https://docs.tryretool.com/v2.26.10/docs/scim-user-provisioning

Improved

• If you were sent a link to Retool you'll be redirected to where you wanted to go even if you were asked to sign in first.

Filepicker: Selecting multiple files

• The Filepicker component now also supports selecting multiple files, and parsing them. You can select multiple files by holding either the Ctrl, Cmd, or Shift modifier keys while choosing your files.
• The Filepicker component also now supports uploading entire directories.
• All of this can be enabled or disabled in the settings of the Filepicker.

SQL Server improvements

• SQL Server queries that comprise of multiple queries now have a more consistent behavior.
• For example, in the following SQL query, the .data property will contain the result of the first select statement. On the other hand, to get the result of the 2nd select statement, you can use the .dataArray property. (e.g. {{ query1.dataArray[1] }})

select * from SalesLT.Customer;
select * from SalesLT.Address;

Misc.

• The JSON Schema Form component now supports the ui:widget "date" and "datetime"
• The Modal component's vertical size can be controlled either in pixels (500px) or percentages (80%).
• The Rich Text Editor now has more consistent behavior when the initial value of the component is set programatically

Table Improvements

• The "pagination" ui on Tables can now be placed on the top of the top instead of the bottom of the Table.
• The "compact" Table mode now shows even more data by using shorter rows.

New and improved

• We've added an integration with Basecamp! Check it out over here: https://docs.tryretool.com/docs/basecamp-integration
• The error messages for database connection errors have been fixed to suggest better solutions.

Fixed

• You can now specify both the "jumphost" (also known as "bastion") host as well as the port to connect. This is helpful when trying to connect a database through an SSH Tunnel with a jumphost that uses a non-standard SSH tunnel port (e.g. 22000).
• You can use any Retool "parameter" inside table "formatters", and "color" formatters on top of the existing self and currentRow property.
• Intercom now correctly works for all on-premise users.
• Long-running queries on MySQL database queries now correctly timeout after the query's "timeout" setting.

Table improvements

• For data-dense tables, you can now also enable compact mode. Take a look below for how the tables compare.
• Tables now also formats null, true, and false values!

JSON Schema Form Improvements

• The alignment and look of controls in the JSON Schema Form have been revamped to be consistent with Retool's other components.
• The Clear after Form Submission option on the Form now waits for the query to finish executing before clearing the form.

Fixed:

• Percentages in Pie charts now show correctly in all cases.
• Allow non-ASCII characters when parsing CSVs uploaded by the FilePicker