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…

In the Coda community one looked for a check box logic. My contribution results in something you see below. I used buttons and they behave like radio buttons, partly due to the label logic.

hire date + 90 days — A probationary period is a stretch of time during which a new or existing employee receives extra supervision and coaching, either to learn a new job or to turn around a performance problem. The probationary period can be as short as a month or as long as a year, depending…

when your tasks have overlap and you need periods — In the community I contributed by partly responding to: I have tasks with start and end time. I would like to have a canvas formula that displays Time left. How do I subtract that time so that 1 minute of real time can only count as one minute, instead of…

Replace a checkbox with counted values via a lookup — Many Coda makers direct the buttons behavior with a checkbox. You click on the button and via ModifyRows(), the checkbox is (un)checked. Once (un)checked other actions are permitted or blocked. When you look into a table you have to look into the buttons to understand when and how they modify…

this month, last month and next month — In my previous blog on weeks I showed a simple principle to get all dates this week, last week and next week. We do more or less the same with month, but a bit different because unlike weeks, month differ in length. How to Coda with weeks? This week, last week or next week?huizer.medium.com Months have mostly 30 or 31 days, sometimes…

This week, last week or next week? — Weeks have 7 days, always. That makes them rather easy to work with in Coda, but on the otherhand we have only a few week related functions. There is the Weekday(), the position of the day in the week. By default in Coda, Sunday is the first day of the…