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

v2.32.15 Editable Tables, Server search on dropdowns

Editable Tables

Gif2.gif

Server-side search on dropdowns.

  • Search your database as you type with a dropdown.
  • Here's a quick example of it in action

DropdownSearch.gif

v2.32.12 GeoJSON Support

GeoJSON on Maps!

  • Plot points, lines, and polygons using GeoJSON on Retool's Map component.maps.png
  • For more info, checkout http://geojson.org/ to learn more about GeoJSON.

Fixed

  • Urls do not unnecessarily decode urls in the path.
  • Fix importing CSVs in to databases via the Database Editor.

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