Event handlers for queries
When your query succeeds or fails, you can now trigger other queries, control components, call additional APIs, and more–all using event handlers!
For most Retool apps you've built in the past, you've probably set up the "After this query runs" triggers. For example, let's say you have a query, selectUsers, populating a Table component; if you insert a new record to the users table, you probably want to re-run that selectUsers query so that your Table is up to date:
However, anything more complex–showing a notification, controlling components (e.g. opening a modal)–previously required creating and wiring up a JavaScript query, and writing custom code.
A few months ago, we rolled out new event handlers to all of your components. We're now replacing the old query triggers, and bringing those powerful event handlers to your queries! You can configure any number of event handlers to run when your query succeeds or fails (e.g. on success, show a notification to your end user and open a modal to prompt a new workflow).
Anything you can do with Retool’s JS API (e.g. query1.trigger(), modal.open(), utils.showNotification(...)) you can do with event handlers. If you do have a need to write some custom JavaScript, it's even easier than before. You can just use the "run script" event handler and write your code, without creating and wiring up a new query.
As you build with these new event handlers on your queries, we want to hear from you! Are there more kinds of event handlers you'd like to see us add? Any feedback? Drop us a note at support@retool.com.
Fixes and improvements
- Updated default component IDs to use camelCase (e.g., checkboxGroup1)
- Added advanced editor features to the Text Area component, including autocomplete, autocapitalization, and spell check
- Added support for exploring queries and transformers in the model browser (left-hand panel) while actively editing a different query or transformer
- Added a change event handler to BoundingBox component
- Added a Front integration
- Fixed Folders and Apps so that they're sorted consistently
- Fixed an edge case with query trigger migrations for the new query event handlers
- Fixed an edge case where the "Go to app" event handler wouldn't successfully navigate
Check out this guide to see the on-prem versions and their release notes. These features will be rolling out to on-prem customers in the next few weeks.