Changelog

Complex Table Cells​

Tables now support much more than just text. Columns can now be a Checkbox, TextInput, DatePicker, Button or Dropdown. This feature also completely integrates with bulk updates, making editing your data as simple as editing a table.

Refreshed Query Library​

We’ve added a series of features along with a brand new look!

• A View History button to look through query history and revert to an earlier version
• A usage view to see which apps are using this query
• Use imported javascript libraries inside {{ }}
• A search field to find specific queries
• Permission toggle to show/hide the library to different user groups

Dropzone​

A Filepicker widget when expanded will become a dropzone.

Chart v2​

We’ve added a new Chart component that lets you use all three charts in one.

Improvements​

• Switching resources no longer clears out your query
• Memory leak fixes for on-premise customers
• MongoDB resources now support SSL and self signed certificates
• MongoDB resources now support updateMany
• Snowflake resources let you specify a DB schema
• Table mappers now work correctly with filters
• Apps with a large number of queries have better performance

As always please reach out to feedback@retool.com with comments and requests!

Auto-generate Apps​

You can now generate a simple app automatically for Postgres and MySQL. Pick a table and a field to filter on, and we’ll build it for you 🙂

BETA — Table filters​

You can now filter for values on the Table Component, no config necessary. Let us know what you think!

Improvements​

• Added option to return raw date strings in MySQL instead of JS objects
• Fixed a bug where Cassandra, BigQuery, Denodo, Vertica, Snowflake resources could not write
• Fixed a bug where users couldn’t be invited and added to a group at the same time
• Fixed a bug where GraphQL resources crashed if they had invalid schemas

Tabs!​

You can now reorder query tabs! Sometimes, it’s the little things 🙂

Cascader Component​

When you need a dropdown with nested options, you can use our new Cascader component

Tables​

• Table cells have a new type: Modal — Clicking on a cell of this type will open a modal. You can use selectedRow.data to customize your components inside.
• You can show and hide columns using {{ }} in the Column Settings section

Query Library​

• You can now delete your own queries in the Query Library
• Query runs are now tracked in the audit log
• REST resources are now displayed correctly with the base URL

Improvements​

• Query preview now shows the data after transformation
• Forms now validate text inputs of type email correctly
• On-premise users now have git-syncing for resources
• The MSSQL resource now lets you dynamically override username and password

Notes v2​

We’ve heard your feedback and built out a version 2 of the Notes component. You can now leave multiple comments, and also see who commented and when!

Schemas​

We spiced up the schema viewer for SQL based resources. You can search by table, field, and collapse and expand columns. We’ve also made scrolling through more responsive.

Braintree component​

We added a Braintree component to accept payments — and to keep our Stripe component company 🙂

Query Library!?​

The Query Playground is now the Query Library. We want the name to reflect the core functionality we’ve added to to the Library, like reusable queries. We hope this doesn’t stop you from playing around and experimenting though!

You can now pass along links to specific queries in the playground. This should make sharing queries much easier.

Improvements​

• Table columns are now sorted by the unmapped value. Now, using a mapper on a column won’t affect your sorting.
• The Create button on the home page is now disabled for users who can’t create apps
• Fixed SSL connections for legacy versions of Aurora

GraphQL queries now correctly return errors!

• Download your query results in the Query Playground as CSV or JSON
• Fixed a bug where MSSQL resources needed SSL to write back
• Fixed a bug with how Retool processes and returns large Salesforce SOQL queries
• Made the Query editor more responsive

If your team is trying to build apps around processes that require approval — budget increases, large purchases, or anything that requires approval from another specific user — please reach out to yogi@retool.com! We’re working on making these flows easier to build and have something that might make your life easier.