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 the community forum 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.

• 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 the documentation to learn more.

Google Cloud Storage Integration​

• Retool now supports all the same configurations in S3 with Google Cloud Storage
• See the documentation to learn more.

Vertica Integration​

• Retool also supports Vertica as a database!
• Reading and Updating are both supported.
• See the documentation to learn more.

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.