2.66.14 Improved tools for managing authentication, performance improvements, and fixes
New
- Added support for Docker secrets in Retool's on-prem deployment
- Added support for parsing group claims in the Custom OAuth2 SSO integration.
- Added support for Google SSO in the Custom OAuth2 SSO integration.
- Official Helm 3 chart for Retool available. Helm 2 charts are available here.
Added tools to debug the authentication flow for resources configured using Custom Auth
Redesigned the database schema browser
Changed REST API resources to allow for empty base URLs
Performance improvements
- Transition speed between different apps greatly improved
- Cleaned up some unnecessary libraries and code
Bugfixes
- Fixed issue where single-container on-prem deployments no longer supported SSH connections
Fixed issue where text would overflow in Button components when the label was too long
Fixed issue where the SAP Hana integration would unexpectedly hang
Fixed visual issue with Table headers when using themes
Fixed issue where the ReorderableList would not work with duplicate values
Fixed visual bugs of the Settings page on wider screens
Fixed custom dimensions support in our Google Analytics integration
Fixed visual bug when inviting additional users
Fixed issue where the staging / production toggle would still appear even when you had set the `HIDE_PROD_AND_STAGING_TOGGLES` environment variable to `true`
Folders and property tooltips
This update is available in version 2.64.83 or higher.
Query editor folders
You can now organize your queries and transformers inside folders! We’ve also re-structured the query editor so that queries and transformers are in the same list and can be organized together.
Property tooltips
When you’re exploring the left panel (⌘B) in the editor, you’ll find tooltips as you hover over certain properties that surface helpful tips and documentation.
Editor improvements
- You can now search for imported queries in the Query editor menu
- String type values in the green evaluation preview are now wrapped in quotes
- Component drag-and-drop no longer interferes with selecting text in an input
- You can now configure the resolution on utils.downloadPDF()
- You can now omit elements when downloading a pdf of your Retool app with utils.downloadPage()
- Query "on success" notifications are no longer configurable when they won't be displayed
Component improvements
- All Select components can now be set to allow app users to enter custom values
- Enables option to search for and select custom values in Dropdowns. Clarifies difference between allowing a custom value and displaying an invalid value by renaming "Allow out of range values" to "Display invalid values"
- Form components now also consider input components (Text Inputs, Selects, etc.) nested inside containers
- Plotly chart components now omit numeric columns formatted as strings from parsed x-axis value options. Data returned from Postgres and Google Sheets datasets will now render correctly when graphed with Plotly component
- DateTimePicker components now support "required" validation for forms
- Fixed an issue where the Rich Text Editor would not always display the correct value after model updates
Resource improvements
- Cassandra resources now support read-only AWS Keyspaces
- Fix Google Cloud DataStore ordering bug where clearing the ordering setting broke the query.
- Fix for OpenAPI custom query parameters
- Specifying a None for the Body field in REST queries will now send nothing instead of an empty object {}
- Fixed an issue where certain Custom Auth steps for REST and GraphQL resources were skipped if they followed an OAuth2 step
Alert component
This update is available in version 2.64.72 or higher.
We’ve added an “Alert” component to Retool! Alert components let you provide and highlight feedback to your users. You might hide and show this component based on the response of a query. You can dynamically set the type of alert you show to your users (ex: display a success or error based on the return value of a query). You can also include a button in this component that can take any action a Button component can, such as running a query, or exporting data.
Google sheets improvements, App releases, and Query failure conditions
These updates are included in v2.64.71 or higher.
Google sheets
- New action type Bulk Update: allows you to update many cells in a sheet at once, where previously you had to configure a custom JS query
- New action type Delete: allows you to delete a row in a given sheet, which was previously not possible in Retool
- Typed values: Retool can now read column types from your spreadsheet (e.g. Numbers, Booleans, and Strings). Tables now detect column formats and sort columns with those new formats. Typed values also makes it easier to join across different resources without type conversions.
- Updated docs: improvements include a new tutorial for building an app
- Small bug fixes: Retool no longer throws errors when querying empty spreadsheets. Additionally, we improved the stability of connecting your Google account.
Releases and history
You can now better manage versions of your applications with our release and history modals.
New features include:
- App releases have been reworked to clarify who took what action
- You can now compare changes between any two releases side-by-side
- First releases for an app are no longer forced to use v0.1.0
- The redesigned history tab shows 10 items per page and includes tags on saves that are live and/or released
Query failure conditions
Before, Retool would display a default raw error message from a failing query to users using your Retool apps. You can now override that default message by setting a message on failure conditions.
You can use “failure conditions” in queries to:
1. Display custom error messages to your users 2. Mark successful queries as failure (ex: for GraphQL queries)
Check out the docs for more info. Note that this feature replaces “Error transformers.”
New editor functionality
- You can now download an image of your Retool app as a PDF with utils.downloadPage()
- You can now logout programmatically by redirecting to /logout in your apps
Table improvements
- You can now set dropdown labels dynamically with {{ }} in dropdown columns
- When adding a new row to an empty table, your column settings (e.g. dropdown values like {{ query1.data }}, dropdown labels, background color, etc.) will now apply to the new row
Component improvements
- Text Inputs components now include an option to show commas for numerical types
- Queries can now be cached per user instead of across your organization. You can toggle this setting on the Settings → Advanced page.
- Added the option to scroll vertically in Tabbed Container components
- Cleaned up styles for Toggle components
- Plotly components that use Group by now generate the correct JSON
- Keys in Key Value components are now reorderable even when they don't contain data
- Key Value components now display falsy values correctly
- You can no longer move components off the page when moving them with arrow keys
Resource improvements
- You can now search for resources on your Resources page
- In REST and GraphQL resources, you can now use an OAUTH2_ID_TOKEN (in addition to the OAUTH2_TOKEN) to substitute for the OAuth ID token when sharing OAuth credentials between users is disabled.
- MSSQL resources now support Trusted Authentication
- MongoDB queries now let you specify the options field to support inputs like allowDiskUse
- Firebase resources now correctly let you specify the database URL
- MySQL resources correctly support dynamic name overrides for Bulk insert, update, and upsert queries
- Retool no longer incorrectly passes an audience to the /token endpoint for OAuth2 auth flows
- Fixed an issue where Postgres resources that connected via SSH occasionally timed out
- PostgreSQL auto-incrementing primary keys now don’t need to be passed in for Bulk upsert queries
Bug fixes
- Large apps with Text inputs (read: most apps!) are now more performant and don't slow down when you type
- Keyboard shortcuts now work correctly on Chromebooks
- CSV exports no longer prepend apostrophes to negative values
- Query library gRPC queries now import metadata correctly
- Previewing an OpenAPI query no longer crashes the query editor
- Container components no longer show duplicate property editors
Debugging in browser developer tools, Barcode scanner
These updates are included in v2.64.40 or higher.
Debug queries in browser DevTools
No longer do you have to console.log everything you can to debug queries. You can now use your browser’s developer tools debugger with Javascript Queries and Transformers! Check out the docs for more details.
For example, to do this in Chrome:
1. Run the query 2. Open the Sources tab in Chrome DevTools and navigate to a file (Cmd/Ctrl-P) with the same name as the query 3. You should now be able to inspect variables, set breakpoints, etc.
Barcode scanner
You can now scan barcodes in Retool using the Barcode scanner component. The component uses the camera of the device to scan the barcode and returns the code number.
Cascading query deletion
Often deleting a query left your app in a broken state. To fix this, we've changed query deletion to cascade: deleting a query will delete all the references to it. We've added a confirmation modal that explicitly describes what will happen. One note: it's tricky to delete query references in JS expressions, so we leave those as-is and provide references in the confirmation modal.
Preview specific app versions
You can now jump from the editor to previewing the latest or the live version of the app, without having to open the Releases modal.
More powerful components
- Added support for LIKE operations in the Query builder component
- You can now allow popups in the iFrame component
- You can now reload the iFrame component from a JS query
- The Form generator now allows for fields to be drag-and-dropped reordered. You can also specify dropdowns as an input type.
- Fixed an issue where opening another Retool app via the Button component sent you to the home page instead
- Added a lastSubmittedAt field to Text Input components
- Added option to not clear the Dropdown component when clicked
- Added the ability to remove borders in the ListView component
- MultiSelect components no longer expand past the allotted space when full
- Added a button to clear Text Input components
- Chart components with duplicate x-axis values now display correctly
Table improvements
- Long strings in cells no longer crash the table
- Dropdown type columns now map a value of 0 correctly to its label
- Numeric columns now align right by default
- Queries triggered by Button type columns can now access the triggeredById and index fields to see which table and row triggered them
Editor power and quality of life
- The releases modal now shows email addresses
- Query editor now scrolls correctly to the bottom of the query list when a query is created
- Deleting a query now also deletes other properties that reference that query
- Queries now have a queryRunTime field that contains how long the query took to run
- Added toggle to always show a hidden component in editor mode
- Query success toasts now display the query name in editor mode
You can now add metadata to gRPC resource requests
Bug fixes
- The Releases modal now displays the correct page (was off by 1)
- Accessing currentRow in Button type columns now works as expected
- List View components using row keys no longer crash
- New queries no longer incorrectly display "Cannot find property 'get' of undefined"
- Forms no longer crash when optional fields require validation
- Text Input components now validate numbers with regex correctly
- Text Input components now invalidate floats when an integer was required
- Fixed a bug where connecting a Google sheets resource would occasionally fail
- Added clarifications to GCS resources that failed silently on upload
- Creating a folder named "root" no longer breaks your home page
- The Resend invite button after inviting a user now works as expected
- Fixed a bug that stopped you publishing the latest version of an app
- The errors field is now correctly cleared after a query succeeds
- Custom auth steps when setting up a REST/GraphQL resource now accurately show what variables you have access to
- Queries no longer have isFetching set to true after completion
- Fixed a bug where switching apps didn't stop queries on the previous page from running
- Renaming a page now displays a reason if it failed
- Copy pasting a Container component now also correctly copies its children
- Marking a Text Input component as not required in a Form component now works as expected
- Mappers in Chart components are now recalculated correctly when datasets are toggled
v2.64.5 — Form generator, diffing between releases, and full screen code editing
Form Generator
You can now generate a form directly from a database table! Drag out a Form component, click on the “Generate fields from a database” button, choose your table, and we’ll add a query and all the components you need to insert a row. You’ll be able to edit the query and each component just as if you’d created the whole form manually.
Release diffs
We’ve added the ability to view the diff between two different releases. If you want to know which lines in a SQL query are different, or which exact property you tweaked last week on that button, this is your feature.
Full screen editing
Need more room to write code? You can now press F11 to view code editors in full screen. This feature works anywhere you can use {{ }}.
SSO with OAuth providers
For on-premise deployments, you can now implement SSO with any provider that implements OpenID, such as Auth0 and Azure AD. Check out the docs here.
Table improvements
- Table component now handles non-array data correctly
- Selecting a row in Table components now correctly updates the selected page
- Table components using GraphQL server side pagination no longer infinitely loop
- Table component pagination arrows now display correctly in Firefox
- Table components columns with names that conflict with Table component properties now work correctly
- Fixed Table components with inline editable columns that occasionally crashed
More improvements
- Code completion for Table component column mapper settings is now based on the selected table row
- Faster List View component rendering time
- Faster load time for the Audit log page
- Personal queries are now first in the Query Library
Bug fixes
Text Input components no longer default to an invalid regex check
- Fixed an issue where pressing Tab would hide a Tabbed Container component’s tabs
- Fixed certain cases where Text Input components inside containers and List views crashed
- The JSON Schema Form component now lists all compatible SQL resources
- Selecting a user in the Settings page no longer selects the wrong user
- Fixed an issue where the query editor crashed with certain resources selected
- Transformers no longer crashed the display when previewed
- 0 is now considered a valid Text Input component value
- Checkboxes inside Form components now clear when a form is cleared
- App names with non-letter characters like !, #, or ? now display correctly in the editor
- You can now dynamically add a key to a URL param for REST/GraphQL queries
- Using /users/scheduled_sends in the Sendgrid resource no longer crashes the Query Editor
- The visibleContainers field in the Container component now updates correctly on scroll
- Changing the URL now triggers queries dependent on urlparams
- Formatting SQL queries with && now works correctly