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
v2.63.5 — Wizard, gRPC, Plotly charts, and revamped SQL resource creation
We’ve been silent for a while but fret not, we’ve been hard at work. We’ve deployed some larger features over the last month and a half, not to mention a whole lot of smaller bug fixes and improvements. As usual, please reach out if you have feedback or comments!
Wizard component (BETA)
We've released a beta version of the Wizard component, an exciting new addition to Retool's component library. The Wizard allows you to visually create multi-step workflows with branching logic, ideal for when you need to guide users through a specific sequence. This is an entirely new component in Retool, so we’d love to hear more about how it can better fit your workflows.
Plotly Chart component (BETA)
We’ve released a beta version of our new Chart component, powered by Plotly. This new component gives you the option of quickly generating a chart from a query or transformer. For more advanced charting needs you can toggle to directly edit Plotly JSON.
New out of the box features:
- Combine bar and line graphs in the same chart
- Dynamically group and aggregate data
- Use the chart’s selectedPoints property to dynamically update other parts of your app
Preview, Save, and Run Queries
The query editor now has improved clarity around previewing, saving and running queries. We've heard a lot of questions like: “Why does query1 run when I save, but query2 doesn’t?” and “Wait, the play button doesn’t actually run the query?” To help clear up this behavior, we've made the following changes:
- The preview button now has a clearer label to prevent confusion with actually triggering a query.
- The save button now has two states: “Save” and “Save & Run”. The state shown is tied to whether the query is set to run “automatically when inputs change” (Save & Run) or “only when manually triggered” (Save). In Retool, “read” queries default to always run when inputs change, while “write” queries will only run when manually triggered (e.g. by clicking on a button).
- Once a query has been saved, you’ll see a newly added run button. This will trigger the query to run once. (Helpful for debugging—no more having to add a button to your app just to test trigger a query!)
- Last but not least, we’ve moved the run query when setting to the top of the query editor, so it’s easier to predict the behavior of a query at a glance.
gRPC Connector
Retool now connects to gRPC based resources for on premise deployments. The connection supports unary requests for reading and writing (including with variables) with gRPC today. To setup your proto files and start making gRPC request start with the docs here.
SQL resource creation changes
Retool previously required you to set up two resources for SQL: one for reading and one for writing. We’ve simplified this so that one resource that can perform both reads and writes! This has been enabled for all SQL resources over the last few weeks. Check out the docs for a more detailed overview of the changes.
Configurable table button
You can now add a button to the table that can fire off any query of your choice. Often we’ve wanted a button that’s very table related but doesn’t quite fit into the existing toolkit, so we’ve added this button as a catch-all.
Improvements
- App search on the homepage now also shows apps inside folders
- Added toggle to hide the submit button from Form containers
- Added name of editors in the History and Releases modals
- The search omnibox now de-prioritizes archived apps
- Added support for specifying ?_releaseVersion as a URL parameter
- Added the ability to customize the duration of query success/error notifications
- Added (back!) the ability to bulk invite users
Components
- ListView components now support dynamic row heights and hiding components
- Add ability to delete notes in the Notes component
- Improved fuzzy search functionality for select components
- Added back Regex filter on TextInput components that stopped users from typing invalid characters
- Added the ability to set a start time for the Timer component and the ability to customize the value
- Added the ability to style the Toggle component as a caret
- Added a .select() method to Text Input components to select text from Run JS Code queries
- Added the ability to use allow-downloads with IFrame components
- Added the ability to group events by day in the Timeline component
- Added the ability to allow geolocation in the Custom Component's IFrame
- Added the ability to enable allow-same-origin in the Custom Component
- Added the ability render custom HTML inside the Select component
Table improvements
- CSV downloads now include the correct column names for renamed columns
- Added the ability to disable the save changes button
- Added the ability to view columns as radio buttons
- Added the ability to disable checkbox and radio style columns
- Fixed an issue where CSV exports now include all columns (instead of just those in the first row)
- Fixed an issue where manually triggered queries were not run when clicking the refresh button
- Fixed an issue where certain column names like “Disabled” broke the component
- Fixed issues where currentRow and self displayed the wrong value
- Fixed an issue where the “Server side paginated” field did not work as expected
Resources
- You can now access returned errors in the Error transformer. You can now return an object from the Error transformer
- Added the ability to specify user role for Snowflake connections
- Added the ability to query collection groups for Firestore connections
- Added in and array-contains-any queries to Firestore
- Added the ability to use BigQuery’s legacy SQL dialect
- Added KEYS, MGET, and HMGET to the available Redis commands
- Added the ability to use IAM roles for Athena and DynamoDB
- Added the ability to get, set and delete tags on S3 files
Auth improvements for REST/GraphQL
- Added the ability to verify a custom auth connection via a request
- Added the ability to create a custom flow for refreshing authentication
- Added the ability to automatically submit an OAuth form for REST/GraphQL queries
Bug Fixes
- Fixed a bug where paginated GraphQL queries were called repeatedly if they returned no results
- Fixed a bug where the HTML renderer in Select components didn’t work if values were objects
- Fixed an issue where Firebase queries didn’t allow selecting a collection ID
- Fixed an issue where Firestore queries did not work when using $ref in the request
- Fixed an issue where you could not call methods on components nested inside ListView components
- Fixed an issue where the Rich Text Editor component called the “On Blur” query on every keystroke if the component contained a URL
- Fixed issues where Select and Text Input components didn’t render correctly inside ListViews
- Fixed an issue where Containers inside ListView components didn’t render in the right order
- Fixed an issue where rejected promises returned from JS queries were not interpreted as errors
- Fixed an issue where ui:emptyValue in JSONSchemaForm components wasn’t being set correctly
v2.60.1 — A little UX sugar
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