Changelog

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