Concurrent developer warnings

• Added a notification to the header that shows who else is modifying the same Retool app.
• You can use this to avoid overwriting changes that your team mates are making to the Retool app.

Deleting apps

• Added ability for admins to permanently delete apps that are in the archive folder.

New

• Added the option to specify the ACL for files uploaded to Google Cloud Storage
• Added option to allow users to define custom values in Multiselects. Enable this by using the "Allow user defined values" option in Multiselects.

Resource access levels

• Extended the access control levels in Retool to allow admins to restrict access to Resources connected in Retool.
• You can use this feature to do things like:
  • Only allow analysts to use readonly database connections.
  • Only allow developers to use apis / databases that they manage.

Here, the group lets the "Awesome Intern" use the onboarding_db (readonly) and onboarding_api resources to create / modify apps

Query playground

• Added the Query Playground which lets developers write queries quickly without having to create an app.

• Coming soon: reusing queries you write in the playground within your Retool apps.

Tile homepage view

• Added a new tile-based home screen for Retool apps
• You can customize the image you use for each tile.
• You can also "favorite" your most frequently used apps so that always appear at the top of the page.

New

• Added support for deleting S3 files.
• Added support for S3 bucket URLs in APIs that use the AWSv4 authentication method.
• Increased maximum timeout for queries to 10 minutes.

Fixed

• Fixed how custom redirect flows in "Custom Auth" APIs work in "staging" environments.
• Fixed POST/PUT/DELETE requests in the Stripe integration that have an empty body.

Query Caching

• Added query caching as a way to optimize the performance of Retool apps.
• Queries can have its results cached for up to one day (the cache TTL)
  • The first time you run a cacheable query, it will run the query normally and then remember the query result.
  • Anytime anybody runs the query again the remembered result gets returned instantly.
  • The remembered result is deleted after the cache TTL expires.
• You can configure this option in the "Advanced options" section of the query editor.

Retool community!

• Visit https://tryretool.com/community to join the community 🙂

New and Improved

• Added lastUploadedFileName to the S3 Uploader component. Works similarly to the lastUploadedFileUrl.
• Added live warnings to make it easier to write Javascript scripts.
• Added a utils.downloadFile function to Javascript scripts. Use this to with API queries that return pdfs / docx / xlsx / etc. to download the files returned. Docs here.

Fixed

• Changed the MongoDB insertOne queries to also return the created object, including the MongoDB _id.
• Fixed deadlink on the Permissions dashboard.

RethinkDB Integration

• Added RethinkDB as a Retool integration.
• Run get, insert, update, delete, and find queries on your database.
• Let us know what else we can add.

Lambda Integration

• Added AWS Lambda as a Retool integration.
• Invoke lambda functions with whatever payload you need.
• See more info in our docs here.

Improved

• Added support for sharded Microsoft SQL Server databases.
• Improved the user management screen in Retool. Disabled users are greyed out, and we show accurate last active dates for each user.

Fixed

• Fixed how Custom Auth API integrations work in staging environments
• Fixed how non-string values are passed in FormData API requests.
• Fixed error that Slack webhooks would return in on premise Retool.
• Disabled overly aggressive cache headers in on premise Retool.
• Fixed editing JSON columns in editable tables.

Drag and drop

• We've enabled zooming to the drag and drop interface to make it easier to make big changes to your app.
• We've made it easier to re-arrange components on crowded applications.
• We've made it easier to drop components into existing containers.
• We've added resize handlers to all four corners of every component.
• We've made it easier to select multiple components.
• Here's a preview of some of these new features in a gif!

Better navigation

• We've changed our sorting algorithm for the Quick Switcher (use Cmd+K or Ctrl+K to bring it up!) to rank more relevant applications.
• We've added an interface to switch between apps to the End User mode.

Fun confetti!

• We've added a fun easter egg: make your queries fire off some confetti when it successfully runs!

Component changelog

Date Pickers and Date Range Pickers

• We've added restricting dates your users can select.
• You can define a minimum and a maximum date for both date pickers and date range pickers.

PDF Viewer

• We've added the PDF Viewer component. Use this to render PDFs for your users.
• You can either use a URL or a PDF file that's been encoded as base64.
• You can get a base64 encoded version of a PDF by using the Retool's REST Query.
• Here's an end-to-end example of how you might render a PDF from the IRS.

Checkbox Tree

• We've added a checkbox tree that makes it easy to select categories and subcategories.

Statistics

• We've added a statistic component to make it easy to render numbers like KPIs, etc.

Integrations changelog

Cassandra improvements

• We've added writing back to your Cassandra database.
• We've added support to connect to Cassandra using custom SSL CA Certificates.
• This feature works in the same way as other SQL Databases like Postgres, MySQL, etc.
• You'll need to create a new resource with a Cassandra user that has edit permissions.
• You can learn more about how that works here.

Snowflake improvements

• We've also added writing back to your Snowflake database.
• This feature works in the same way as other SQL Databases like Postgres, MySQL, etc.
• You'll need to create a new resource with a Snowflake user that has edit permissions.
• You can learn more about how that works here.

REST API Authentication

• We've added a "Form" step to the Custom Auth method.
• Use this to ask for credentials like usernames and passwords to pass to your API.
• Learn more by reading the docs here!

Uncategorized features

Fixed

• RadioGroup components now overflow correctly.
• Tables and other components in ListViews now render correctly.
• JSON Schema Form components with input:range (sliders) now work correctly.
• JSON Schema Form components that use the required now validate it's inputs correctly.
• Retool now correctly release and re-use database connections.
• GraphQL Queries now support Auth0 as an authentication method.
• MongoDB distinct queries now correctly validate inputs.
• BigQuery queries now format dates and timestamps correctly.
• New components created through copy paste now appear on the row below.

Improved

• We've improved the syntax highlighting for Custom Component editor.
• We've it easier to switch between mobile and desktop layouts in the drag and drop interface.
• We've released starter templates that make it easier to build apps in Retool.
• We've improved how Google Sheet queries.
• We've added support for connecting to Redis via SSL.
• We've added support for dynamic MongDB collection names.
• We've added a currency type to TextInput components.

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.