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…

Applying basic JSON knowledge in Coda — In my previous blog on JSON I explained basics like why the double quotations ( “ “) are important, how you open with [ ] for Arrays and { } for objects and that in most cases we deal with (nested) objects. This is not so difficult as it looks…

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…

Add or update rows in your target doc using a webhook — In my previous blog on my for free webhook pack, see below, I explained how to set up a webhook that moves data row by row to the next doc. The webhook works fast. It takes about a minute and that is faster than the 60 minutes the automation takes…

How to use the webhook trigger to relate tables in two docs. — Together with Gijsbert Huijsen, he is the co-founder of this AI driven solution to translate audio into any language (speech2text) : Trandelion, het platform voor apparaatonafhankelijk live vertalen van spraak naar tekst Trandelion is een online platform die apparaatonafhankelijk spraak direct live omzet naar tekst en kan vertalen naar…trandelion.com

When your data stream is irregular — You may have noticed that once in a while I share on Twitter the evolution of the diesel price in Belgium. This price is an important variable to calculate the rentability of people transport besides for example the driver costs, the expected repair costs on certain trajets and so forth. …

How to integrate feedback — The idea for this blog came when I responded to a question in the community. It was about how to bring data together of 3 tables into one table. My response was to create a forth table that brings in the values from the separate tables via formula. The contribution…

Simple & more complex cases — One the core functionalities of a Coda button is to modify a value in a column. The label Modify Rows is a bit misleading since you can also modify a complete list — all items living in a column, see example 2. A button prints a value in a cell…