Changelog

Table improvements​

• For data-dense tables, you can now also enable compact mode. Take a look below for how the tables compare.
• Tables now also formats null, true, and false values!

JSON Schema Form Improvements​

• The alignment and look of controls in the JSON Schema Form have been revamped to be consistent with Retool's other components.
• The Clear after Form Submission option on the Form now waits for the query to finish executing before clearing the form.

Fixed:​

• Percentages in Pie charts now show correctly in all cases.
• Allow non-ASCII characters when parsing CSVs uploaded by the FilePicker

Auto Generate Forms​

• Create forms for any of your database tables with just one click with the JSONSchemaForm component.
• Retool can parse your database schema to create forms for your tables. See the documentation to learn more.

Improved​

• Added support for uploading binary data to S3. This makes it possible to use the normal FilePicker component to upload files to `S3.
• Added the TabbedContainer's selectedTab as an option for deep linking.
• Added support for exporting arrays of arrays to CSV files. See below for an example [['Name', 'Hobby'], ['Fred', 'Tennis'], ['Marry', 'Badminton']]
  • Added support for connecting to dynamically choosing the database to connect to at query run time. This makes it possible to connect Retool with sharded databases.

Editor Improvements​

• We've optimized the sizing of everything in the Retool Editor.
• It's now friendlier on computers with smaller screens and makes sure that you can see everything you need to without having to scroll or zoom out.

Improved​

• Microsoft SQL Server queries now support returning multiple recordsets. For example the below will now return both results in the same SQL query -- Find all the rogers select from dbo.Users where name = 'Roger'; -- Find all the sarahs select from dbo.Users where name = 'Sarah';
  • Tables can be server-paginated without specifying the total size of the dataset being paged through.
  • In case you've forgotten how Retool works, or if you want to show a friend the basics, you can now restart the tutorial from the home screen by clicking on Do Tutorial
  • A link to our docs has been added to the sidebar.

  Fixed​

  • Fixed: switching between production and staging now also auto-refetches the schema of your datasources

New PDF Exports​

• Write markdown, and get a PDF.
• Great for creating tools to generate PDF documents (invoices, contracts, etc.)
• Use this by using the new PDF Exporter query:
• To generate PDFs that look like this:

Improved Javascript Queries​

• Javascript Queries lets you script Retool to do pretty much anything.
• This works by invoking methods on Retool primitives (components, queries, etc.).
• All of these operations are asynchronous - they don't immediately take effect (e.g. triggering a REST API query).
• To help make this easier, Retool now supports promise based syntax and async-await syntax on newer browsers

Improved Tables​

• The column of buttons can be moved to the leftmost column of the Table.
• The header of the column of buttons can be customized.
• Server side paginated tables no longer requires the total number of records in the dataset to page correctly.

Misc Improvements​

• Added .setValue to checkboxes

• Added percents to pie charts

• Added the HTML class ._retool- to containers

• Fixed: GraphQL errors have been improved

• Fixed: Allow underscores in odbc based connections

• Fixed: SAML login cast to lower case for consistency

New component: Reorderable Lists​

• Need to allow your users to reorder a collection of items?
• The Reorderable List is a component that allows your users to drag and drop cards to reorder an array of strings into any order they want.

Bulk Upserts​

• Retool supports bulk upserts into SQL databases (Postgres, MySQL, and SQL Server).
• Choose which table, which key to treat as a primary key, and an array of data to update / insert data into Retool.

Improved​

• Retool's resizing handle's hitbox has been increased to make it easier to click and drag.