After a string of performance updates to help your tables load and calculate more quickly (while also optimizing column data to decrease doc size), we dug-in to improve some of the most common table and formula experiences based on your feedback. Here’s what’s new!
Better enumeration of copied objects
When you copy a table or control and choose to duplicate data instead of creating a view, we append the number 2 to your copy. However, if you continued to copy, Coda would continue appending a number 2, so it was not uncommon to have a table named something like “Table 2 2 2.” We’ve updated this behavior so that the number increments by 1 each time, so you can have “Table 2,” “Table 3,” “Table 4,” and so on.
Discover hidden table names more easily
Hiding a table name is a great way to avoid redundancy or clean-up the visual appearance of a doc. But sometimes you need to reference that name in a formula or quickly confirm the table title to disambiguate from other data. Doing so has historically meant accessing the table options menu or unhiding the table, but now you can simply hover over the 3-dot ‘kebab’ menu next to the top of a table to see its name.
Live in the Now that you choose
The Now() formula has always returned values down to the second; starting today, you can select whether the output rounds to seconds, minutes, hours, or days.
Create button, scale, slider & control columns from the Explore panel
In our first step of making the Explore panel a bit more universal, you can create button columns or scales and controls simply by dragging your item into the column you wish to update. Now, instead of clicking through a few menu options on your table, you can drag a “modify row” or “add row” or any other type of button directly into your table.
Reduce data-entry errors by disabling auto-complete
We’ve toggled auto-complete to “off” in text columns, since we’ve heard that it interfered with typing in them. Do you prefer to auto-complete text in your cells? No sweat — just toggle the "Suggestions” setting back on in your Text column settings.
Easier ‘blank’ selection for People columns
Previously, you had to do some cursor gymnastics to delete a value from a cell in a people column in Coda. Starting today, you can search for “ blank ” to reset a people value just as you’d search for any other name.
Color scale maximum and minimum values
We’ve loved hearing about the ways you’re using color scales since we launched the feature a few months ago. One point of feedback we’ve heard a few times is that filtered views can make the results feel less intuitive—so, starting today, we’re giving you the power to customize the max and min bounds for your color scales.
To fix that, whenever you open the color scale option for your conditional formats, you can now set a minimum and maximum value for your scale. Any value below the minimum will receive the same color treatment as the minimum value, and any value above the maximum will receive the same treatment as the indicated maximum value.
Thanks for your incredible feedback, and helping us make tables even better for our amazing Community! Be on the lookout for more updates, and some exciting previews at our Block Party event on October 6th.
!!!
I attempt to input 6 minutes of duration for each of 4 rows
Tip: You can optimize doc performance by using the level of precision for Now() that you need.