Changelog

Fixes and improvements​

• Added new behavior where URL parameters will persist when switching from edit to preview mode

• Fixed resetValue for the DateRange component

• Fixed a bug causing MongoDB fields to not appear in the schema editor

• Removed keyboard shortcuts modal when viewing a Retool app in preview mode

• Fixed an issue where table action buttons expand incorrectly in dense and compact tables

• Clicking away from renaming a query in the code section of the editor will now commit the new name

• Improved query editor UX when there are no queries to run

• Improved discoverability of popout code editor keyboard shortcut ( Cmd + \ )

• Fixed 'Show Selection' toggle for Listbox and MultiSelect Listbox

• Added autocomplete docs for {{self.X}}

Fixes and improvements​

• Improved code editor preview experience by updating component name
• Fixed text alignment for links that wrap to multiple lines
• Improved searching for queries in folders by automatically expand folders
• Changed 'Enable autocomplete' control to 'Enable browser autofill' for Text Input
• Fixed bug which caused single-letter domains in URLs to be incorrectly shown as invalid
• Improved the design of the query context menu
• Added support for OAuth 2.0 client credentials for OpenAPI
• Made the "Scripts and styles" modal resizable
• Changed the default timeout for mysql, presto and vertica resources from 10,000ms to 120,000ms
• Added support for AWS v4 authentication via headers

We’re excited to announce a revamped cut/copy/paste experience that’s available to all cloud customers and will soon be available to on-premise customers. Component cut, copy, and paste are core to Retool’s editor ergonomics, allowing you to rapidly iterate on existing applications. Previously when copying and pasting, components would occasionally overlap or shift their layouts in unexpected ways. Pasting components within containers was especially difficult. The revamped experience remedies these bugs, including the following:

Previously, when pasting with a Container selected, the components would paste below. Now, pasting with a Container selected pastes the content inside. This makes it easier to create layouts with nested contexts without drag and drop.

Previously, pasting components into a container would resize them to be much narrower or wider than expected. Now, we auto-adjust pasted components’ widths so that they are correctly sized in the new context.

Previously, copy/paste shortcuts did nothing with an input-based component (i.e. Text Input) if the input element is focused. Now, copy/paste shortcuts correctly copy the component or paste components from the clipboard.

We shipped 10+ major bug fixes and improvements to our copy/paste experience, like:

• Fixed overlapping of pasted auto-height components
• Fixed unexpected vertical gaps between components copied from below auto-height components
• Fixed overlapping of pasted components if a frame is selected
• Pasted components now scroll into view
• Fixed unexpected vertical gaps between components inside pasted containers
• Fixed overlapping of pasted components in a container’s header if the container is nested in another container’s header
• Fixed pasting inside containers nested in a List View component
• Disabled being able to paste List View components to achieve nesting depth greater than 3
• Copy/paste shortcuts now correctly copy and paste Table components if no cells are selected

Introducing a new Context Menu​

In addition, we’re introducing a new context menu for Retool’s editor that enables rapid access to common component operations, such as deleting components, switching components to other similar components, and of course, copying and pasting components. In an effort to improve usability, the structure and ordering of the context menu has been improved and now includes submenu options too.

The context menu can be activated by right-clicking on components on the canvas or on the component Explorer in the left panel. Right-clicking on canvas frames will instead bring up an abridged version of the widget context menu with more general editor operations.

Fixes and improvements​

• Deprecated Single Tag and Multiple Tags custom columns. To add a custom Tag column, use a Transformer to add an extra column to the Table’s dataset and configure it to be a Tag column. Existing custom tag columns will maintain their functionality.
• Added auto-selection of the new temporary state when duplicating
• Fixed temporary state duplication from opening the inspector panel
• Fixed JS query auto-indexing when used in a module
• Fixed a bug where server-side paginated scrolling tables failed to fetch subsequent pages
• Updated JavaScript transformers to show linting suggestions just like JavaScript queries
• Added a Duplicate action within the context menu for temporary states
• Fixed a bug where Test Connection would fail for GraphQL resources passing current_user in the header
• Updated the eval popover text in the null and undefined cases
• Fixed an issue where viewers without edit permissions would see an unnecessary blank space on the top of their apps
• Unified query sidebar design between the bottom panel and the bottom half of the Explorer
• Fixed an issue with Table action buttons overflowing and covering adjacent columns
• Removed the checkbox for assuming IAM roles on the Athena resource
• Added support for {{current_user}} scope to the Presto resource configuration

Fixes and improvements​

• Added support for SSH for MySQL Resources with Dynamic Overrides
• Improved styling of the editor
• Fixed a bug where HTML cells in Table with overflow would not properly wrap
• Improved hover states on the Retool org homepage
• Fixed renaming in the code sidebar to prevent collisions
• Added automatic opening of code folders whose children become selected
• Added functionality to import from connection strings for PostgreSQL
• Fixed a few issues with Table's selectedCell property: selectedCell is now correct when rows are sorted, selectedCell will no longer double-update, only one selected cell will be displayed at a time
• Fixed panel resizeability when left and bottom panels are closed
• Added component icons to the right-panel inspector header
• Fixed a bug causing number string form data keys to generate array form data
• Updated the default option order for a control component for a modal
• Fixed default folder name from 'untitledfolder#' to 'folder_#'
• Fixed an issue where components may have been visually omitted from the Explorer
• Fixed a bug where Table's empty message would break Table when set to an object
• Removed the number of errors from Debug Tools in the status bar
• Added ability to use certain editor/presentation shortcuts while an input field is active
• Fixed a bug where apps using a BigQuery resource configured with Service Account authentication would prompt users to authenticate

Fixes and improvements​

• Added functionality to import from connection strings for MySQL and MSSQL

• Added a hidden mapper and automatically convert base 64 encoded images in Image Grid

• Fixed a bug with mapped Table values that return moment instances

• Updated the Bulk Upsert command to support null and undefined primary key values for MSSQL queries

• Updated the Bulk Upsert command to support null and undefined primary key values for MySQL queries

• Added clearValue() to clear scanner data

• Fixed an issue where renaming queries and transformers would erase unsaved edits

• Fixed a bug where the query to populate schema browser for Presto resources would timeout. The schema browser now shows the first 1000 tables.

• Updated the Bulk Upsert command to support null primary key values for Postgres queries

• Added the ability to select icons for Avatar components

• Fixed height of the query search bar

• Added IAM Auth as an option for connection to MySQL resources

• Updated Table data cell icons

• Fixed missing dataset editor styles in Chart

Fixes and improvements​

• Fixed a bug where GCM encryption required resource passwords to being less than 8 characters

• Improved default dark theme colors and display tag colors in the Theme Preview when editing a Theme

• Fixed a small visual bug with the hidden icon in the Explorer

• Fixed a bug where "onRowSelect" event handlers were fired when cell selection changed

• Improved clarity and style of auth verification buttons in the custom auth configuration flow

• Made styling and icon changes in the editor interface

• Fixed whitespace escape characters in Multiline Text data cells

Retool continually works on stability and security improvements for our customers. We are updating our infrastructure that will result in a change to the IP addresses that Retool uses. This change will not affect most customers but impacts those who must allow connections to Retool IP addresses through a firewall. This includes:

• Retool Cloud customers who have inbound firewall rules for resources on the network (e.g., databases)
• Self-hosted Retool customers who have outbound firewall rules on the network (air-gapped deployments are not affected)

**If you explicitly allow connections from or to Retool’s IP addresses, you must include additional IP addresses before December 1st, 2022. If you have difficulty updating this information, please reach out to us by emailing ip-changes@retool.com. **

Retool Cloud customers​

Retool must be allowed to connect to your resources using the following IP addresses. Update your inbound firewall rules to ensure Retool has continued access to your data:

• 52.177.12.28/32
• 52.175.251.223/32
• 35.90.103.132/30
• 44.208.168.68/30

Failure to update this information in time can prevent Retool from accessing your data and result in failed queries.

Self-hosted Retool customers​

Self-hosted Retool deployments must be allowed to connect to Retool’s license check, email, and usage reporting services using the following IP addresses. Update your outbound firewall rules to ensure Retool has continued access:

• 13.66.159.82/32
• 13.66.251.59/32
• 35.92.202.168/29
• 44.211.178.248/29

Failure to update this information in time can result in failed license checks and user invites.

Reachability test​

You can test your changes within Retool to make sure your deployment can reach the new IP addresses:

1. Sign in to Retool and navigate to the Query Library.
2. Click + New to create a new query.
3. Select the **REST **resource and GET action type.
4. Set the URL to https://reachability-test.retool.com.
5. Click Save to save the query, then click ▶ to run the query.

If the query returns a 200 status and OK status text, your deployment can successfully reach the new IP addresses.

New features​

• Form generation from a table: Generate a form and all of its corresponding inputs from an existing table component on the canvas. Inputs will correspond to each column in the table, and values in the form will correspond to the selected table row by default.

Fixes and improvements​

• Added required field validation for saving and testing resource connections

• Improved the in-app resource configuration form to provide full-width inputs for better legibility

• Improved usability of REST resource URL prefixes by allowing them to be selectable and scrollable if long

• Fixed a bug where "Ctrl+C" would not copy table cell contents on Windows

• Improved Help Bubble by making the version and build number selectable and copyable

• Added clickable icons to slider component which increment and decrement the slider

New features​

• Calendar Input component: Select a specific date, with support to select a month and year using the header.

• Resize to fit: Added a "Resize to fit" action to fixed height containers that will adjust the container's height to fit its content. This action can be taken from the right-click context menu, by double clicking on the bottom rail of the component bounding box, or with the keyboard shortcut "Cmd+Option+Shift+r" (Mac) or "Ctrl+Option+Shift+r" (Windows and Linux).

Fixes and improvements​

• Fixed issue for Single Tag columns in Tables where option label would not render when option value was also set
• Fixed an issue where Browse Apps wouldn't appear in the Retool pill
• Fixed the Postgres resource to support providing a CA certificate without setting a client key
• Fixed the docs link in OAuth 2.0 helper text on resource configuration page
• Fixed a bug where the onboarding CTA was showing up after the tutorial is completed
• Removed requirement for a resource to be in edited in order to test connection on configuration page
• Improved the editor canvas to be a consistent color when zoomed out
• Improved default custom component logic
• Added the ability to copy parts of the text within Table cells instead of the entire cell