Why a button is your friend to track changes — I contributed in a discussion on how to keep track of sales in a table. The idea was to create a set up many makers feel familiar with. You take a value living on a previous row and or add or subtract a value. While this works very well in…

Pick your projects with prudence and keep focus — The Coda Formula Language is elegant, versatile and since the performance increased substantially over time — the Coda connaisseur Joostmineur told me that he had 100K rows running without major issues — one may start to believe that due to the mix of performance and the CFL everything is possible…

Using the file link you create with ParseJSON — In the Coda Community one of the requests is how to get an invoice out of Coda. Today this is not supported very well, but you can do it in certain way. It actually means that you push the file link into the email and via your email, you download…

Why I use Coda instead of Excel — “I set up calculations” is my close to standard response when asked what I am doing. In Dutch: ‘Ik maak sommetjes’ and then people gaze at me. Let me explain what this means: ‘sommetjes maken’. Most people use spreadsheets, Google Sheets but more often Microsoft Excel. For good reasons I…

One way sync or a two way sync, you may need it — One task one doc In an remarkable contribution, Coda employee Al Chen wrote: These days, I try to have my templates do one thing and one thing well. Let me rephrase this to one task, one doc. Late 2022 I described how complexity can turn against you easily. Since then we have descriptions in…

when your weekend is not a Saturday and Sunday — In October 2022 I already wrote in a blog about the next working day in a context that a working day can have 1 up to 7 days. The standard of 5 working days, is however common, not practical as hard coded value in a function. In the community the…

Use patterns you can repeat and adapt — The last few weeks I came across Coda challenges on Twitter dealing with getting the right date each year knowing that in a given month it is always the x Sunday or y Thursday. The most surprising solution was generated using AI. A table was created on command and filled…

something simple going wrong easily — Below an easy to follow but nevertheless wrong solution to get the next birthday.

How to get rid of deleted items still living in your lookup? — In the Coda community an interesting question got a smart response from Virginie. In short: how can we clean up a table that contains items removed from the lookup (or relations are they are renamed). …