Custom keyboard shortcuts​

You can now add custom keyboard shortcuts to your apps! If you find yourself clicking the same button over and over again, or if you want to run a mini JS query on keystroke, you can now automate those actions with shortcuts.

Default table shortcuts​

While you can define custom shortcuts for any component, we also added some default hotkeys for the table. When you click on a table, you can use the keyboard to travel between rows in that table — to go up and down, you can use:

• Up/Down arrow keys
• J/K for our Vim experts
• Ctrl-P/Ctrl-N for our Emacs fans

Expand and minimize the query editor​

We’ve all wanted a little more room to write our longer queries. You can now expand the query editor to (almost!) fill your screen.

A long tail of other improvements​

Components​

• Added a focus() method for Text Input components in Javascript queries
• Added the ability to disable Button components for a specified time time after click
• Added the ability to set times using the local time zone on the Date Time Picker and the Date Range Picker components. For example, with local timezones enabled in EST, the component interprets choosing 5PM as 5PM EST, as opposed to 5PM in UTC converted to 1PM EST.
• Added class names to input validation icons to allow overriding with custom CSS
• Added the ability to search users in the Settings → Users page
• Added toggle to allow popups to escape the sandbox for custom components
• Added the ability to right align table columns
• Fixed a bug where passing JSON to column settings in tables would crash the table

Resources​

• Added the ability to configure instance names for MSSQL resources
• Added the ability to set application intent to “read only” for MSSQL resources

Performance​

• Significant performance improvements when loading apps and using apps when queries are running
• Performance improvements for navigating the user permissions page

Bug fixes​

• Fixed a bug where text inputs did not expand to their full height when labels were positioned to the left
• Fixed a bug where tabbing between component settings did not work as expected
• Fixed a bug where Text Input components did not blur properly on ESC
• Fixed a bug where you could not leave the staging environment in Presentation mode
• Fixed an issue where edits to resource settings were not being saved
• Fixed an issue where placeholders for Parent Window queries were not set correctly
• Fixed an issue where searching for actions in Firebase queries did not show the right results
• Fixed an issue where clicking Rich Text Editor components didn’t save correctly on blur
• Fixed a bug where you could not select the time on the Date Picker component if min or max values were set
• Fixed a few overflow bugs on user access control settings
• Fixed a bug where not all pages were fetched from DynamoDB tables when there were more than 100

Styled text components​

We’ve added options to set the text alignment, text color, and background color for Text components. This should help the simple but hard working component stand out, as it organizes your apps and calls out important information.

Add your logo and brand color​

Custom theming has arrived! Enterprise customers can now upload a logo file and customize the navbar color. This improves the presentation quality when end users log in to use your Retool apps.

Workspaces​

Customize the default homepage for your end users with workspaces. You can build a Retool app and declare this page as the workspace any of your user groups.

Component improvements​

• Added toggles to allow microphone and camera access for the IFrame component
• Added the ability to test a connection while adding a resource
• Added the option to use UTC instead of local timezone in the Date picker component
• Added the ability to run queries on blur for the Rich Text Editor component
• Fixed a bug where ui:emptyValue was not interpreted correctly in the JSON Schema Form component
• Fixed a bug where text colors were not applying correctly when using Markdown
• Fixed a bug to allow negative currency values in the Text input component
• Fixed a bug to correctly validate currency in Text input components
• Fixed an overflow issue for Table component action buttons and columns

Resource improvements​

• Added the ability to create a GraphQL query without creating a resource
• Added the option to disable prepared statements for BigQuery resources
• Fixed a bug where MongoDB insertOne and deleteOne queries were triggered by input changes
• Fixed a bug to enable uploading raw strings to S3

Bug fixes​

• Fixed an issue causing unreliable sending of user invites
• Fixed a bug causing child components to clear state when nested in List View containers
• Added a modal to view user permissions (back) to the app list on the home page
• Fixed a bug where the app would scroll to the top when a component was deleted
• Fixed a bug where DateTimePicker and TimePicker values were incorrectly formatted
• Hidden widgets no longer flash on page load
• Folders have been added back to the home screen alongside apps

Along with improvements to forms, we’ve continued our series of visual tweaks. __We’ll be tweaking these designs over the next few months. We’d love to hear your feedback!

Powerful validation options​

We’ve added a number of validation options to validate your inputs. For example, you can check that a value in a Text Input is now a valid email address in 2 clicks. You can also customize the error message you show to your users.

Duplicate apps from the editor​

A little easier on the eyes​

A new set of colors to make Retool more accessible​

Our new colors and their improved accessibility ratings

More consistent tables, typography, and containers​

A new navigation bar

… to give you a little more horizontal space

New styles for all resource forms​

… as part of our quest to make adding a resource as easy as possible

An easier way to create apps

A new Share button

...for sharing links for editors, viewers, and for embedding public apps

__

Other improvements​

• Added a keyboard shortcut Ctrl+b / Cmd+b to open and close the Model browser
• Added support for newer AWS regions (eu-north-1, me-south-1, us-gov-east-1, and us-gov-west-1) for DynamoDB and Athena.

Fixes​

• Fixed a bug where background colors for modals and file pickers weren’t configurable
• Fixes a bug where Table mappers that refer to something outside of the Table's data scope would not update properly.
• Performance improvements for Retool apps with many components
• Fixed a bug where Select and TextInput components inside ListView components might crash
• Handle raw SQL statements on Oracle DB correctly
• Fix issue with SQL Server resource connections

Better resources​

GraphQL resources now have a schema explorer!​

• You can now specify a database index/number for Redis resources
• Our Lambda integration now supports Invocation type

Improvements​

• Support restoring signatures from images in the Signature component
• Add “isOpen” property to Modals
• Better currency support for TextInput components

Bug Fixes​

• Fix issues with on-premise deployments on Ubuntu 16
• Fix issue where callbacks in custom components were not being called correctly
• Fix issue where empty strings instead of nulls were inserted into tables
• Fix issue where JSON values from MultiSelect components weren’t parsed correctly
• Fix syntax highlighting for dropdown values
• Display Dropdown cells in Tables correctly in compact mode
• Stop converting dates to strings during Git syncing
• Bulk updates now work correctly in filtered tables
• Remove extra scroll bars in the Query library

Add New Row​

You can now add new rows to your data directly from your table. Useful when you don’t want to build a form :)

Better Omnibox​

The new Omnibox (Cmd/Ctrl+K) now can take you to Resources, Folders, the Query library, and Settings in addition to the usual Retool apps

Improvements

• Added image/png as a type in GCS resources
• Added better instructions to Container, Tabbed Container, and List View
• Added option to enable batch querying for MSSQL queries
• Accept multiple variable definitions in REST and GraphQL resources using custom auth
• Fixed bug where {{ }} in URLs in REST and GraphQL resources were not being processed correctly
• Fixed an issue where mappers were not working correctly with filters
• Fixed a bug where Retool resources (REST, Run JS Code, etc.) did not work correctly in staging
• Performance and reliability improvements

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

Retool managed notes — beta​

If you’ve ever thought, “I wish I could just write a quick note about this user, but don’t want to create a table or add a column for it,” you should try the Note component. The component lets you comment on any row your database. For example, you can write a note (e.g. “duplicate user!”), attach it to userid_42, and retrieve it later. This is still in beta, so we’d love your feedback!

Playground updates: shared queries and variables​

You can now share your Playground queries with the rest of the team! Once a query has been shared, all the editors in your team will be able to see, run, and edit the query.

Also new: variables in queries. Use double curly braces {{ }} in your playground queries to define parameters to your queries. To run parameterized queries in the playground, pass in values to variables on the right hand side.

Coming soon — import queries from the playground into your apps, so you can stay DRY and avoid copy/pasting queries 🙂

Calculated table columns​

Ever wished you had Javascript in Excel? Now you have Retool! The Table component now lets you add columns populated by calculations (such as ones that reference other values in the table). And, of course, you get the power of JS with the {{ }}.

New resources: OpenAPI + CosmosDB + S3-compatible storage providers​

We’ve added three new resources:

1. API that has an OpenAPI specification (e.g. certain Google Cloud Endpoints)
2. Azure CosmosDB
3. You can now pass in a different base URL to the S3 resource to connect to any S3 compatible storage provider (ex: DigitalOcean Spaces or Wasabi)

Revert to an older release​

You can now directly revert to an older release in the app editor, without searching through your entire history. (If your end users are not on the latest release, reverting to an older version will not revert their published version.)

Other improvements​

• SAML JIT user provisioning for Okta (if you know, you know)
• You can now pass in SSL certificates to connect to RethinkDB
• We added utils.copyToClipboard to let you copy text in Javascript queries
• We now support various eastern european characters in our font, such as ľščťžřňěůôä for our Czech friends
• Our MySQL and Postgres resources now accept self signed certificates — this is useful if you’re on GCP
• Small fixes for containers in mobile mode, the DateTimePicker, and authentication for REST Queries
• Various performance fixes