Multiple Action Buttons

• Tables now can have multiple action buttons!

Cassandra Integration

• Retool now supports Cassandra v3+!
• We support using CQL - a SQL-like query language for Cassandra.
• See our docs here: https://docs.tryretool.com/docs/cassandra-integration

Google Cloud Storage Integration

• Retool now supports all the same configurations in S3 with Google Cloud Storage
• See our docs here: https://docs.tryretool.com/docs/google-cloud-storage-integration

Vertica Integration

• Retool also supports Vertica as a database!
• Reading and Updating are both supported.
• See our docs here: https://docs.tryretool.com/docs/vertica-integration

Map Improvements

• Added an onViewPortChange hook to trigger queries
• Added an onPointSelected hook to trigger queries
• Added .selectPoint(...) as as a method on Map components
• Improved accuracy of the custom marker positioning
• Made the Map component update its latitude and longitude property when the viewport updates.
• Added GeoJSON styling. Try this for an example!

{ type: 'line', paint: { 'line-width': 5 } } 

Signature Component

• Retool now has a Signature Component!
• It exposes a .signatureImageFile that you can use like the Filepicker's .file property to upload the image to services like S3 or even your own API.

Stripe Checkout Component

• Retool now has a component for collecting credit card information securely through Stripe's SDK.
• The component exposes a .stripeToken property that you can use with Stripe's API to create a credit card.

Date Range component

• Retool also has a date range component for selecting begin / end dates.

Various features and improvements

• Uploaded Excel files are also now automatically parsed!
• ListViews now have improved performance!
• Added support for deleting permission groups
• Added support for copying invite links directly from the Retool settings interface.
• Show staging / production toggle in the end user mode
• Support user-defined expiration timeouts for OAuth resources.
• Added utils.getCurrentPosition which returns a Promise that resolves to the device's current position
• Fixed bulk operations on Salesforce
• Fixed intermittent problems with CSV parsing on Windows machines
• Added option to render dates in Tables in their original timezone.

Custom React Components

• You can now create your own custom components using React and Javascript.
• We give you full access to the same APIs that our native components have.
• For example, you can now use whatever charting library you want (Plot.ly / D3 / etc.) as well as use custom React libraries like Material UI.
• See below for an example of a Plot.ly scatter chart in Retool. Full docs here

Dynamically Hiding / Showing Components

• Retool now supports dynamically hiding and showing components.
• Retool automatically relayouts the app to get rid of the empty whitespace.
• Check it out in action below! Full docs here

Undos / Redos

• Retool now supports undos and redos!
• On Macs use Cmd+Z to Undo and Cmd+Shift+Z to Redo changes you make while building your apps
• On Windows / Linux use Ctrl+Z to Undo and Ctrl+Shift+Z to Redo changes you make while building your apps
• Here it is in action:

Improved Calendar

• Added the option to modify and delete events in the calendar
• Added the ability to set what kind of interactions in the calendar are allowed (e.g. creating events, modifying events, deleting events, etc.)
• Added the ability to choose the default view of the calendar
• Added a preview for events selected

OAuth 2.0 Bugfixes

• Retool now support sharing OAuth 2.0 credentials between users.
• Retool also supports specifying an OAuth 2.0 Audience.
• We've greatly improved the reliability of our OAuth 2.0 integration and extended support to GraphQL as well.

On Premise Response Time and Error Monitoring

• Retool now ships with support for monitoring software.
• New Relic example config

NEW_RELIC_LICENSE_KEY=your-new-relic-license-key
NEW_RELIC_APP_NAME=retool-yourcompany-name
NEW_RELIC_NO_CONFIG_FILE=true

• Sentry example config:

SENTRY_DSN=your-sentry-dsn

Google Sheets

• We've added support for updating Google sheets.
• More docs and functionality coming soon!

Misc Features / Bugfixes

• Added support for triggering queries after a date is selected in the DateTimePicker with the onSelect property
• Added support for Delimiter in S3's List Objects operation
• Added support for GraphQL Cursor Based Pagination. Docs here!
• Added support for ordering in Firebase queries
• Added support for deleteOne to MongoDB.
• Added support for dynamic Keys in JSON expressions
• Improved performance of Retool's Snowflake integration
• Handle MySQL connections more reliably
• Added the option to allow dropdowns and multiselects to optionally allow itself to show out-of-range values
• Added .setImageUrl method to the Image component
• Whitelisted slack:// and mailto:// URLs for buttons and <a> tags.
• Added the ability to set a delay before initially running a query on page load.
• Added a Looker integration into Retool.
• Added magic constants USER_GOOGLE_ID and USER_PRIMARY_EMAIL that can be used in the REST API integration to pass the currently logged in user's email / google id to the API server.
• Improved how Retool serializes Firebase refs.
• Added support for all Redis commands.
• Added support for choosing a TDS version for Microsoft SQL Server.
• Fixed several issues with the Map component and it's parsing of GeoJSON
• Fixed logic for verifying if the user is currently logged into an API.
• Fixed error handling for GraphQL queries.
• Fixed a rare yet inexplicable bug where a Retool app will appear to be completely wiped clean.

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