v2.38.59 Integrations and more!

Multiple Action Buttons

  • Tables now can have multiple action buttons!

Screen Shot 2019-04-07 at 9.05.25 PM.png

Cassandra Integration

Google Cloud Storage Integration

Vertica Integration

Map Improvements

  • Added an onViewPortChange hook to trigger queries
  • Added an onPointSelected hook to trigger queries
  • Added .selectPoint(...) as as a method on Map components
  • Improved accuracy of the custom marker positioning
  • Made the Map component update its latitude and longitude property when the viewport updates.
  • Added GeoJSON styling. Try this for an example!
{ type: 'line', paint: { 'line-width': 5 } } 

Signature Component

  • Retool now has a Signature Component!
  • It exposes a .signatureImageFile that you can use like the Filepicker's .file property to upload the image to services like S3 or even your own API.

Screen Shot 2019-04-07 at 9.12.23 PM.png

Stripe Checkout Component

  • Retool now has a component for collecting credit card information securely through Stripe's SDK.
  • The component exposes a .stripeToken property that you can use with Stripe's API to create a credit card.

Screen Shot 2019-04-07 at 9.14.35 PM.png

Date Range component

  • Retool also has a date range component for selecting begin / end dates.

Screen Shot 2019-04-07 at 9.17.08 PM.png

Various features and improvements

  • Uploaded Excel files are also now automatically parsed!
  • ListViews now have improved performance!
  • Added support for deleting permission groups
  • Added support for copying invite links directly from the Retool settings interface.
  • Show staging / production toggle in the end user mode
  • Support user-defined expiration timeouts for OAuth resources.
  • Added utils.getCurrentPosition which returns a Promise that resolves to the device's current position
  • Fixed bulk operations on Salesforce
  • Fixed intermittent problems with CSV parsing on Windows machines
  • Added option to render dates in Tables in their original timezone.

v2.38.39 Custom React Components and more

Custom React Components

  • You can now create your own custom components using React and Javascript.
  • We give you full access to the same APIs that our native components have.
  • For example, you can now use whatever charting library you want (Plot.ly / D3 / etc.) as well as use custom React libraries like Material UI.
  • See below for an example of a Plot.ly scatter chart in Retool. Full docs here

Screen Shot 2019-03-16 at 12.34.31 AM.png


Dynamically Hiding / Showing Components

  • Retool now supports dynamically hiding and showing components.
  • Retool automatically relayouts the app to get rid of the empty whitespace.
  • Check it out in action below! Full docs here gif

Undos / Redos

  • Retool now supports undos and redos!
  • On Macs use Cmd+Z to Undo and Cmd+Shift+Z to Redo changes you make while building your apps
  • On Windows / Linux use Ctrl+Z to Undo and Ctrl+Shift+Z to Redo changes you make while building your apps
  • Here it is in action: undo

Improved Calendar

  • Added the option to modify and delete events in the calendar
  • Added the ability to set what kind of interactions in the calendar are allowed (e.g. creating events, modifying events, deleting events, etc.)
  • Added the ability to choose the default view of the calendar
  • Added a preview for events selected

Screen Shot 2019-03-16 at 12.45.01 AM.png


OAuth 2.0 Bugfixes

  • Retool now support sharing OAuth 2.0 credentials between users.
  • Retool also supports specifying an OAuth 2.0 Audience.
  • We've greatly improved the reliability of our OAuth 2.0 integration and extended support to GraphQL as well.

On Premise Response Time and Error Monitoring

  • Retool now ships with support for monitoring software.
  • New Relic example config
NEW_RELIC_LICENSE_KEY=your-new-relic-license-key
NEW_RELIC_APP_NAME=retool-yourcompany-name
NEW_RELIC_NO_CONFIG_FILE=true
  • Sentry example config:
SENTRY_DSN=your-sentry-dsn

Google Sheets

  • We've added support for updating Google sheets.
  • More docs and functionality coming soon!

Misc Features / Bugfixes

  • Added support for triggering queries after a date is selected in the DateTimePicker with the onSelect property
  • Added support for Delimiter in S3's List Objects operation
  • Added support for GraphQL Cursor Based Pagination. Docs here!
  • Added support for ordering in Firebase queries
  • Added support for deleteOne to MongoDB.
  • Added support for dynamic Keys in JSON expressions
  • Improved performance of Retool's Snowflake integration
  • Handle MySQL connections more reliably
  • Added the option to allow dropdowns and multiselects to optionally allow itself to show out-of-range values
  • Added .setImageUrl method to the Image component
  • Whitelisted slack:// and mailto:// URLs for buttons and <a> tags.
  • Added the ability to set a delay before initially running a query on page load.
  • Added a Looker integration into Retool.
  • Added magic constants USER_GOOGLE_ID and USER_PRIMARY_EMAIL that can be used in the REST API integration to pass the currently logged in user's email / google id to the API server.
  • Improved how Retool serializes Firebase refs.
  • Added support for all Redis commands.
  • Added support for choosing a TDS version for Microsoft SQL Server.
  • Fixed several issues with the Map component and it's parsing of GeoJSON
  • Fixed logic for verifying if the user is currently logged into an API.
  • Fixed error handling for GraphQL queries.
  • Fixed a rare yet inexplicable bug where a Retool app will appear to be completely wiped clean.

v2.38.11 New integrations & more

New Integrations

  • Redis Integration: GET DEL and SET keys in Redis!
  • Looker Integration: seamlessly embed Looker dashboards inside Retool

New and Fixed

  • Canvas Shortcuts: use arrow keys to move components on the canvas!
  • Partial updates to Firestore collections has been added
  • GraphQL now supports OAuth 2.0 Client Credentials as an auth method.
  • Microsoft SQL Server connections now supports older databases like SQL Server 2000.
  • Maps can be configured to also show the lat-lng coordinate of the mouse position:

Screen Shot 2019-02-14 at 1.19.18 AM.png

v2.38.7 Snowflake Integration

Snowflake Integration

  • We've released a Snowflake Integration with Retool.
  • Use SQL to query your Snowflake Database

v2.38.6 Performance, 2FA, etc.

Managing User Permission Improvements

  • The Permissions dashboard has been optimized to work with cases with large numbers of users and apps
  • Searching for users and apps now works through fuzzy matching.
  • Add an option to set the permissions of a group to "none"

Mandatory 2FA

  • Admins can now require all users to enable 2FA.

JSON Schema Form improvements

  • Fixed: the form will only begins validating once inputs are dirty
  • The form now supports ui:disabled and ui:readonly
  • Added an option to either validate the form as the user types, or only when the form is submitted.

Misc

  • Add .skip parameter to our CouchDB integration
  • Initial page load time for on-premise Retool users can be up to 2-3s faster.

2.37.1 Filter Logs by User + misc improvements

Filter Audit Logs by User

  • The Audit Logs can now be filtered by users as well.

    Screen Shot 2019-02-04 at 12.54.18 AM.png


Firestore References

  • Firestore query by reference / inserting and updating references.
  • Here's an example of how to specify that a string should be a "reference" type:

Screen Shot 2019-02-04 at 12.56.13 AM.png

  • Inspired by the MongoDB Extended JSON syntax, you use $ref to specify that the string should be a ref. In any place where you might be a normal value you can now use the following to refer to a reference.
{ $ref: "collection/documentId" }

Misc

  • The moment-timezone library has been added to Retool. You can now use expressions like {{ moment.tz('2019-10-10 13:43', 'America/New_York').toISOString() }} to convert dates in different timezones

2.36.2 Performance, Permissions Improvements, and more

Performance Improvements

  • We've optimized filtering through the audit logs that Retool collects so that you can now efficiently trawl through all the queries that your users have run in Retool.
  • Apps should now start up between 1-2s faster on average.
  • Tables are more efficient when rendering large amounts of data.

Disabled Controls

  • Every control in Retool now can be dynamically disabled
  • This includes Text Inputs, Dropdowns, MultiSelects, RadioGroups, Checkboxes, Checkbox Groups, Button Groups, Rating components, and more.

Custom Tooltips

  • Every control can now also have a custom tooltip! Screen Shot 2019-01-31 at 8.30.54 PM.png

Git Integration

  • Retool supports version controlling and serializing apps to a git repo
  • Retool also supports reading and recreating apps from a git repo
  • This allows for designing pull-request flows for deploying apps from staging environments to production environments.
  • To learn more, see our docs here: https://docs.tryretool.com/docs/git-syncing

Permissions Redesign

  • The entire UI for interacting with users, groups, and apps have been modified for more clarity.

Screen Shot 2019-01-31 at 8.41.50 PM.png


Fixed and Misc Features

  • Components in modals will render with the correct sizes in Firefox.
  • We've added a Date Time column type to Tables.
  • Deleting components will automatically trigger a save point in Retool.
  • You can now trigger queries when checkboxes are switched on and off.
  • MongoDB validations for field, limit, and skip have been fixed.
  • Retool apps now live on /apps instead of /presentation
  • The Retool autocomplete now triggers in more sensible scenarios
  • Retool folders are now sorted alphabetically

2.33.0 Shiny Database Editor and UX Improvements

Prettify the Database Editor

  • Check out our new interfaces!

Screen Shot 2019-01-18 at 5.12.15 PM.png


Screen Shot 2019-01-18 at 5.12.45 PM.png


Screen Shot 2019-01-18 at 5.13.28 PM.png


Empty folders hidden for end-users

  • Your users of your apps only see the folders in Retool that have apps that they have access to.
  • Developers still see empty folders (so you can add apps to empty folders!)

Noteworthy features and bugfixes

  • Retool apps now look nicer by default with better contrast.
  • Containers are smaller by default, making them easier to create.
  • Fixed: inline <style> tags in Text components behave more consistently
  • Fixed: the Audit Logs now renders long context nicely.

2.32.49 More stuff!

UX Improvements

  • Reorder columns by dragging on the headers of the Table

Screen Recording 2019-01-11 at 09.10 PM.gif

  • The column option editor is more compact and significantly easier to use Screen Recording 2019-01-11 at 09.07 PM.gif

  • We've added a new way to scroll through the list of queries you've made Screen Recording 2019-01-11 at 09.19 PM.gif


Filter and search through Audit Logs

  • Search and filter through the events by page, query, and date in your Audit Logs

Screen Recording 2019-01-11 at 09.25 PM.gif

  • Coming soon: advanced filters by users, query properties, and more.

Free Table refresh and download buttons

  • Tables now come with a refresh button for free! Use it to reload the query that the Table it's connected to.
  • It also comes with a download button that exports the data as a csv file. Screen Recording 2019-01-11 at 09.43 PM.gif

Image component

  • To embed images into Retool, just use the Image component
  • The button is also clickable; you configure it run queries, open other pages, just like a button!

Screen Shot 2019-01-11 at 9.22.33 PM.png


Autocomplete Dropdowns

  • There's now a .searchValue property on dropdowns that allow you to get the currently searched for term.
  • This allows you creating autocomplete searchboxes. See below for an example of it in action!

DropdownSearch (1).gif


Small, but notable features

  • Retool now allows sharing Salesforce credentials between users.
  • Tables will now auto-infer data types by default, so dates, numbers, and objects are rendered nicely to start off!
  • Reorderable Lists now have a "labels" property, letting users now reorder lists of data with more human-friendly text in the list.
  • Allow queries to delaying post-query run triggers. This is useful with datasources like Elasticsearch, or database connections to replicas that might have a small delay in propagation, as the delay lets the datasource catch up with a recent mutation made to the data.
  • Retool now supports APIs that make use of the double-cookie submit pattern to protect against CSRF attacks.
  • We've made it easier to find the search box for your apps to the home page, or use Ctrl+K or Command+K to open up the search!

Misc new features

  • The Modal component can now be optionally configured to close when clicking outside the modal.
  • The Timeline component can be configured to render its values as HTML. Screen Shot 2019-01-11 at 9.32.26 PM.png
  • The default timeout on MSSQL queries has been increased to 10 minutes.

2.32.32 Lots of stuff!

Improvements

  • Retool can now connect to MongoDB databases through an SSH Tunnel
  • Dropdowns now use fuzzy searching when matching results
  • Add .reset method to the FilePicker component
  • Improved the Date format in Table components to be clearer and more concise
  • Improved the Editable Table to use a checkbox when editing boolean columns
  • Added the ability to trigger queries after an item is selected in a dropdown

SCIM User Provisioning

  • Retool is now generally available on the Okta integration network for both SAML and SCIM User Provisioning.
  • Creating, updating, and deactivating users are supported by Retool.
  • Syncing Groups and permissions is coming soon!
  • Learn more here: https://docs.tryretool.com/docs/scim-user-provisioning

New and Updated Integrations

  • CouchDB: We've added support for CouchDB as a database you can connect to. Learn more here: https://docs.tryretool.com/docs/couchdb-integration
  • Firestore: We've added the ability to insert and update data in Firestore.
  • OracleDB: We've added support for writing SQL to OracleDB.
  • Close.io: We've added support for Close.io's API.

Fixed

  • The Calendar component displays all events in the local timezone.
  • Tables with edited cells now always have "Save changes" button visible.
  • The JSON Schema Form component now shows an email input field correctly.
  • Improved speed of selecting icons on textinputs
  • Added support for OAuth2 to GraphQL datasources
  • Fixed bulk updates queries with Redshift datasources
  • Fixed various issues with the Denodo integration

No published changelogs yet.

Surely retool will start publishing changelogs very soon.

Check out our other public changelogs: Buffer, Mention, Respond by Buffer, JSFiddle, Olark, Droplr, Piwik Pro, Prott, Ustream, ViralSweep, StartupThreads, Userlike, Unixstickers, Survicate, Envoy, Gmelius, CodeTree