💅 Conditional formatting in Table Display cells
Following up on last month's all-new Table Display cell that included column string formatting (for currency, percentages, etc.), this month we're landing Conditional Formatting. You can now color-code tabular data according to multiple rules that can use numerical, string, boolean, and date expressions — no more Pandas style tables! Check out all the options in the docs.
📜 Edit history
We've always had version history in Hex to let you restore previous iterations of your projects, but now we're releasing a rich edit history to let you know what actually has recently changed. You'll now find all edits, versions, and comments for a project in one unified chronological timeline.
We've also changed how you access this history— You'll no longer see it in the top bar, find it instead in the "History & versions" sidebar tab. See the docs for the full story.
🧞♀️ Dataframe columns in Input Parameters
If you've ever created a code cell that just runs input_list = input_df['column_of_interest'].unique() to feed into an Input parameter, you'll be excited about this one. Dynamic Input parameters can now select a dataframe column as the value source, without needing to generate a list!
This is a big time saver and helps keep apps tidy with fewer unnecessary code cells and one-off arrays.
Other improvements
- You can now toggle the legend on/off for encodings in chart cells (color, size, opacity, dash, or detail).
- If you are on slow or spotty wifi, Hex will helpfully notify you that your connection is unstable and work may not be saved.
- Markdown headers in apps now have anchor links, so you can send a link directly to a specific section of a published app.
- When you auto-format code cells with the keyboard shortcut (esc + FS), a toast notification alerts you.
- You can also now auto-format code without using a keyboard shortcut, from the cell menu.
- When creating a new project, instead of assuming you want to begin with a python cell, we now ask whether you want to start with a SQL or Python cell.
Bugs squashed
- Secrets were erroneously highlighted as errors in code cells.
- We fixed an issue that could cause a project to get stuck "Queueing" when in cell-only run mode.
- We've fixed an issue where BigQuery connections were having trouble using the dbt integration.
- Single value cells would error on more exotic data types, but can now accept a broader array of inputs including unknown data types.
- We've fixed a bug that caused the publish dialog to occasionally show up empty