Updates, changes, and improvements at Retool.
You can use the same query in multiple apps with Reusable Queries. Often, you want the same functionality across apps, but don’t want to copy paste a query over and over again. Reusable queries help you avoid code duplication, version control queries, and share queries with your team.
If you’ve ever thought, “I wish I could just write a quick note about this user, but don’t want to create a table or add a column for it,” you should try the Note component. The component lets you comment on any row your database. For example, you can write a note (e.g. “duplicate user!”), attach it to userid_42, and retrieve it later. This is still in beta, so we’d love your feedback!
You can now share your Playground queries with the rest of the team! Once a query has been shared, all the editors in your team will be able to see, run, and edit the query.
Also new: variables in queries. Use double curly braces {{ }} in your playground queries to define parameters to your queries. To run parameterized queries in the playground, pass in values to variables on the right hand side.
Coming soon — import queries from the playground into your apps, so you can stay DRY and avoid copy/pasting queries 🙂
Ever wished you had Javascript in Excel? Now you have Retool! The Table component now lets you add columns populated by calculations (such as ones that reference other values in the table). And, of course, you get the power of JS with the {{ }}.
We’ve added three new resources:
You can now directly revert to an older release in the app editor, without searching through your entire history. (If your end users are not on the latest release, reverting to an older version will not revert their published version.)
utils.copyToClipboard to let you copy text in Javascript queriesDateTimePicker, and authentication for REST QueriesQueries now have built-in transformers, which let you write JS to “transform” the result of any query. For example, if your API returns data in a column-based format, but you want to “transform” the data into an array of objects, you can write a transformer directly in the query. Then, when you use {{ query1.data }} elsewhere, it’ll be transformed, so you won’t have to write the same JS in multiple places.
data in the Query Transformer to access the query results.data property inside {{ }}, for example with {{ query1.data }}.{{ queryName.rawData }}.Note: you can disable the query transformer by clicking the “disable” button.
Retool now supports copying the content from an “evaluation preview” textbox.
For example, in the GIF below, we’re copying the actual live results of a query into a JSON Explorer, so we can inspect it.
Copying the green “evaluation preview” text to inspect the data in a JSON explorer component.
You can now copy and paste Containers with of their children.
⌘ + C on Mac (or CTRL + C on Windows / Linux).⌘ + V on Mac (or CTRL + V on Windows / Linux).Copy and paste containers with their children!
Also, you can also now paste components directly into Container or Tabbed Container components.
⌘ + C on Mac (or CTRL + C on Windows / Linux).⌘ + V on Mac (or CTRL + V on Windows / Linux).
Last week, we spent a lot of time working on making Retool faster; now some of that work has been released. Edit mode and Presentation mode are faster, more complex apps should feel snappier, and even tables with custom cell colors & mapped values will load quicker too!
sms:// and facetime:// to our list of allowed protocols in HTML links.audience parameter in OAuth 2.0 authentication for HTTP and GraphQL APIs..clear().clear button in Select components (aka Dropdown components).scroll on the Modal component.upsert action for querying Snowflake databases.
triggeredby``Id attribute to manually-triggered queries so you know what triggered itonchange query trigger for Radio Group componentssetValue function to Editable Text component
