Changelog

Writing to Google Sheets​

• Retool supports writing data back to Google Sheets
• Supported operations
  • Create spreadsheets programmatically
  • Append new rows to spreadsheets
  • Read data from spreadsheets
• Coming soon:
  • Updating ranges in spreadsheets
  • Listing available spreadsheets
• For more information, see the documentation.

Fixed​

• Various edge cases in our SAML login has been fixed
• Retool supports mapping attributes from the SAMLResponse to the firstName and lastName fields Retool uses.

HTTP / GraphQL Authentication​

• Now supports arbitrary OAuth2 steps
• If the OAuth2 identity provider returns an id_token, that is now also usable in following steps

Improved​

• Added optional labels to the Filepicker
• Added .setValue method to the Text Editor and JSON Editor components
• Our SAML integration now supports identity providers that do not specify the X509 certificate used to sign assertions.

Fixed​

• Mobile layouts are now correctly full width when in present mode
• Staging mode now enabled when JS Queries and Query JSON with SQL queries are in use

HTTP / GraphQL Authentication​

• Retool supports forwarding arbitrary number of authentication cookies
• Retool supports custom multi-step authentication flows
  • Google OAuth Step - login via Google and obtain an access token
  • API Request step - make an API request (e.g. exchange an Google access token for an authorization token)
  • More coming soon.
• Example: First sign in via Google, pass the access token to a login endpoint which sets an authorization cookie that should be present in all future requests

Improved​

• Multi-selection on the canvas auto-terminates once the mouse leaves the canvas
• The screen where the list of supported datasources has been refactored to support searching
• Rename "Run" -> "Preview" in the Query Editor to make it clearer that it's still necessary to save the query to have it's changes appear in the app.
• Add an option to choose the default column to sort a Table by
• Added documentation on how to use
• JSON Request payload logging: Retool now also logs the final request generated by an HTTP query in the audit logs. Fields like the Authorization header and fields with the name password are automatically sanitized, and blacklisted parameters are also respected.

Fixed​

• When a dependency cycle exists between a query and a component exists, Retool will now notify you that a dependency cycle exists and ask you to correct it. Retool apps should no longer break when a dependency cycle is accidentally added.
• Error previews in editors now no longer truncate the error if it's too long.
• Previewing SQL queries with long column names correctly render in the table preview

Images in rich text editors​

• The TextEditor component now supports images
• Images uploaded are base64 encoded and embedded inline in the HTML output

Misc​

• The ElasticSearch configuration screen now asks you to whitelist the IP address we make outbound connections from.
• We've been busy with a bunch of housekeeping - stay tuned for bigger changes soon.

JSON Editor​

• New component: a component for editing arbitrary JSON blobs of data
• Auto-formats your JSON as you edit it
• Auto-validates your JSON

Improved​

• Added more documentation to make connecting Retool to Salesforce easy.
• The buttons for creating transformers and temporary state have been reorganized.
• SQL queries automatically switch between running whenever parameters to change to being manually triggered depending on whether the query is a read only query or not.
• HTML links in Retool (<a> elements) can now open links in a new tab
  • <a> tags now support the target attribute.
  • <a href="https://google.com" target="_blank"> Google </a> will render a link that opens Google in a new page
  • Retool will also automatically add the rel="noopener noreferer attribute to protect your privacy and security to all links that open pages in new tabs.

Fixed​

• The top edge of the Component Properties popup is now also draggable.
• The free plan now correctly allows up to ten queries per page
• Components inside of ListViews should behave more predictably