How to Coda a form?

I enjoyed the early versions of and was greatly impressed by the ease of use, the flexibility, reporting tools and email follow-up. Many years later in 2020 I came across, an — in my eyes — even better way to collect and process data. My clients loved what they saw and took for granted that the data floated gently from a form into Coda tables.

As you understand when it comes to technology, you need to do something to make it work. In this context I used Zapier as a bridge between and Coda. Long story short…

scenarios based on interest variations

In my blog on previousRow I mentioned at the end that for interest calculations we do not need a previousRow logic, instead we apply Power() .

Loans of all sorts are related to variables as with or without installments, the amount, residual value (if any), interest percentage(s), period (mostly in years, but often expressed in months) and a possible prepayment.

In this blog I simply focus on the loan and the interest rates. The rest like a prepayment or an intermediate payment can be simply added once you see the logic unfolded.

My spreadsheet bias

When I started writing the formulas I initially…

In Coda the choice is twofold: either you have an automation active based on Row changed or it is Time-based. Once you select the Time-based option, you have a a few additional choices, but none of them is date related.

In this blog I’ll show how a condition can be used to deal with dates. First I repeat what I wrote earlier and second I’ll show how a formula can help you out when your dates are variable dates, living in tables and function as triggers to set something in motion.

Gmail &

About a year ago, — April 2020 — I was exploring Coda and tried to make sense of the integration with Gmail. Frankly speaking, I was not impressed then.

When a client asked me to set up an automation to email an order confirmation in Coda with Gmail my feedback was ‘I am afraid you will be disappointed’. Nevertheless I looked into it again and I changed my mind. What follows are my findings and why I believe the Gmail integration is a great example of how to empower Coda users.

It works

Yes, emailing via Gmail from Coda simply works. …

How To Coda?

If you — like me — have no background in coding, the options Coda provides may feel overwhelming. Certainly in the beginning when all you have is blank page staring at you. And there are tables and formulas, many many formulas.

How to make use of Coda?

I like this question better than ‘what is Coda?’ I use Coda to keep track of daily health related measurements, to write reports in, to calculate on investments, to present a team, to structure a meeting, as an assistant on birthdays of friends & family, to plan a weekend, to manage the inventory of my business, to inform bus…

It started when I was looking into a color scheme to get some inspiration for a project. I came across the html() sheet below and felt the need to translate these values into HEX values to see the colors they represent.

How can you keep track of your stock after sales? Orders arrive in one table and stock lives in a separate table. How to make them talk? This article explains the bridge using a button.

Before I got started, I first had a look at templates in the gallery. It gave me a bit of inspiration on reporting, but not on the formula logic. Next I remembered a worthwhile to share course from Paul.

Step 01 — databases

In this video of Paul you see the basic structure of most documents that have data tables. You set the database apart from the rest of…

Using Find in a list of lists

Last week I launched my first template for sale. In this template the user can type the name of the month or day in several languages. This multi language approach is possible due to the function Find().

In this blog I’ll explain how we created this multi language SearchBox and how we overcame an undocumented issue with Find().

How to ‘find’ the name?

Ás explained in my previous article on Find() it gets you the first position of a name or a number in string. This is easy part, you get a number, a position.

Next you have to understand how that position relates to…

More often than not you see in the web link the letters UTM. Ever wondered what it meant ? “UTM” stands for “Urchin tracking module”. It was created by Urchin Software Corporation (which was later acquired by Google), and it can now be used with Google Analytics. You can also use any other analytics tool you prefer — just make sure you use the right UTM structure that differs from one tool to the other.

An example of a URL link enriched with UTM tags looks like this:

In this URL, some parameters are mandatory and others optional. You…

How to make use of WithName in Coda ?

The function WithName() was introduced late december 2020. Ít intents to make the writing of functions easier and to protect the user against human mistakes. The function enables two key scenarios — reusing logic within a formula, and nested loops.

Reusing logic within a formula

I see the usage of WithName ()— when we talk about reusing logic within a formula — mainly taking place in an If() statement or in a SwitchIf(). The first part is a condition and often this condition is the outcome of a formula. If the outcome is a simple True() or False(), the rest of the formula simply tells…

Christiaan Huizer

Coda Expert | Huizer Automation

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store