One of my favorite things about Coda is the power in the Coda formula language. Wielded correctly, column formulas in Coda can do everything from finding needles in haystacks of data, to building a custom doc-based app to manage your team’s workflows. But one error in a formula run across a large table can have serious implications for your overall doc performance.
As our favorite web-slinger’s uncle once said: “With great power comes great responsibility.” Which is why we made it our responsibility to help reduce such errors.
Now, when writing column formulas, we’ll provide more specific warnings for some of the most common errors—like comparing arrays to scalar values—and even offer to auto fix some common errors right in the formula builder. If you see something underlined in yellow, now it’s a good idea to click that item to see what Coda recommends before you commit and try to run that formula.
For now, our detection will center around mis-matched data types, and we hope to further expand our ability to provide guidance for more types of formulas directly in the formula builder down the road.
In the mean time, please don’t forget the following resources that are available to help you build the formulas of your dreams: