New Integrations

• Redis Integration: GET DEL and SET keys in Redis!
• Looker Integration: seamlessly embed Looker dashboards inside Retool

New and Fixed

• Canvas Shortcuts: use arrow keys to move components on the canvas!
• Partial updates to Firestore collections has been added
• GraphQL now supports OAuth 2.0 Client Credentials as an auth method.
• Microsoft SQL Server connections now supports older databases like SQL Server 2000.
• Maps can be configured to also show the lat-lng coordinate of the mouse position:

Snowflake Integration

• We've released a Snowflake Integration with Retool.
• Use SQL to query your Snowflake Database

Managing User Permission Improvements

• The Permissions dashboard has been optimized to work with cases with large numbers of users and apps
• Searching for users and apps now works through fuzzy matching.
• Add an option to set the permissions of a group to "none"

Mandatory 2FA

• Admins can now require all users to enable 2FA.

JSON Schema Form improvements

• Fixed: the form will only begins validating once inputs are dirty
• The form now supports ui:disabled and ui:readonly
• Added an option to either validate the form as the user types, or only when the form is submitted.

Misc

• Add .skip parameter to our CouchDB integration
• Initial page load time for on-premise Retool users can be up to 2-3s faster.

Filter Audit Logs by User

• The Audit Logs can now be filtered by users as well.

  

Firestore References

• Firestore query by reference / inserting and updating references.
• Here's an example of how to specify that a string should be a "reference" type:

• Inspired by the MongoDB Extended JSON syntax, you use $ref to specify that the string should be a ref. In any place where you might be a normal value you can now use the following to refer to a reference.

{ $ref: "collection/documentId" }

Misc

• The moment-timezone library has been added to Retool. You can now use expressions like {{ moment.tz('2019-10-10 13:43', 'America/New_York').toISOString() }} to convert dates in different timezones

Performance Improvements

• We've optimized filtering through the audit logs that Retool collects so that you can now efficiently trawl through all the queries that your users have run in Retool.
• Apps should now start up between 1-2s faster on average.
• Tables are more efficient when rendering large amounts of data.

Disabled Controls

• Every control in Retool now can be dynamically disabled
• This includes Text Inputs, Dropdowns, MultiSelects, RadioGroups, Checkboxes, Checkbox Groups, Button Groups, Rating components, and more.

Custom Tooltips

• Every control can now also have a custom tooltip!

Git Integration

• Retool supports version controlling and serializing apps to a git repo
• Retool also supports reading and recreating apps from a git repo
• This allows for designing pull-request flows for deploying apps from staging environments to production environments.
• To learn more, see our docs here: https://docs.tryretool.com/docs/git-syncing

Permissions Redesign

• The entire UI for interacting with users, groups, and apps have been modified for more clarity.

Fixed and Misc Features

• Components in modals will render with the correct sizes in Firefox.
• We've added a Date Time column type to Tables.
• Deleting components will automatically trigger a save point in Retool.
• You can now trigger queries when checkboxes are switched on and off.
• MongoDB validations for field, limit, and skip have been fixed.
• Retool apps now live on /apps instead of /presentation
• The Retool autocomplete now triggers in more sensible scenarios
• Retool folders are now sorted alphabetically

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.