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.

v2.32.9 Firestore support, dynamic properties

Firestore support

  • Retool now supports querying against Firestore.
  • For existing Firebase users, you'll need to modify your Firebase connection to also include your projectId
  • Here's a screenshot of what it looks like! Screen Shot 2018-11-09 at 2.49.40 PM.png

Dynamically set toggled properties.

  • Any property on components that was controlled via a Toggle (e.g. turning on / off the required property on a TextInput can also be dynamically set! Screen Shot 2018-11-09 at 2.52.34 PM.png
  • You can also swap back to using a normal checkbox too. Screen Shot 2018-11-09 at 2.53.10 PM.png

v2.32.2 SCIM User Provisioning

SCIM Provisioning

Improved

  • If you were sent a link to Retool you'll be redirected to where you wanted to go even if you were asked to sign in first.

v2.31.27 Misc fixes

Filepicker: Selecting multiple files

  • The Filepicker component now also supports selecting multiple files, and parsing them. You can select multiple files by holding either the Ctrl, Cmd, or Shift modifier keys while choosing your files.
  • The Filepicker component also now supports uploading entire directories.
  • All of this can be enabled or disabled in the settings of the Filepicker.

SQL Server improvements

  • SQL Server queries that comprise of multiple queries now have a more consistent behavior.
  • For example, in the following SQL query, the .data property will contain the result of the first select statement. On the other hand, to get the result of the 2nd select statement, you can use the .dataArray property. (e.g. {{ query1.dataArray[1] }})
select * from SalesLT.Customer;
select * from SalesLT.Address;

Misc.

  • The JSON Schema Form component now supports the ui:widget "date" and "datetime"
  • The Modal component's vertical size can be controlled either in pixels (500px) or percentages (80%).
  • The Rich Text Editor now has more consistent behavior when the initial value of the component is set programatically

v2.31.26 Misc Improvements and fixes

Table Improvements

  • The "pagination" ui on Tables can now be placed on the top of the top instead of the bottom of the Table.Screen Shot 2018-11-01 at 2.23.12 AM.png
  • The "compact" Table mode now shows even more data by using shorter rows.

New and improved

Fixed

  • You can now specify both the "jumphost" (also known as "bastion") host as well as the port to connect. This is helpful when trying to connect a database through an SSH Tunnel with a jumphost that uses a non-standard SSH tunnel port (e.g. 22000).
  • You can use any Retool "parameter" inside table "formatters", and "color" formatters on top of the existing self and currentRow property.
  • Intercom now correctly works for all on-premise users.
  • Long-running queries on MySQL database queries now correctly timeout after the query's "timeout" setting.

v2.31.23 Table, Form improvements

Table improvements

  • For data-dense tables, you can now also enable compact mode. Take a look below for how the tables compare. Screen Shot 2018-10-25 at 10.31.10 AM.png
  • Tables now also formats null, true, and false values! Screen Shot 2018-10-25 at 10.36.06 AM.png

JSON Schema Form Improvements

  • The alignment and look of controls in the JSON Schema Form have been revamped to be consistent with Retool's other components.
  • The Clear after Form Submission option on the Form now waits for the query to finish executing before clearing the form.

Fixed:

  • Percentages in Pie charts now show correctly in all cases.
  • Allow non-ASCII characters when parsing CSVs uploaded by the FilePicker

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