Photo by Natalia Yakovleva on Unsplash | How to Cod a template?

How to Coda a language sensitive template?

Using a table and Format() to create dynamic content

I decided to template my invoices in Coda and relate the majority of text to the language of my client. Long story short, I have people I do business with, they have a language preference, this I store in a Coda table and when I select a client, the contact is linked and so is the language. To make the set up even easier I wrote a canvas formula I stored on a hidden page together with other handy formulas.

When I started with Coda I used the SwitchIf() to express the proper phrase per language. You get something like below:

SwitchIf to express language variations

Ín this blog I show you a better way, actually one rather easy once you see it.

The main trick is to write a normal text with variables we use when dealing with Format() , thus the {1} and {2} . Below how this looks:

writing a format function as text

Per row I have a language and a corresponding phrase with variables. This one I reference and link to the values as you see below. The formatting (bold for example) is preserved.

wrapping it up

This approach makes it super easy to add an other language and to change the phrases if you need to. The additional advantage is that once you have these elements defined, you can put them together.

Using Format() to bring all elements together

This is how I template my language sensitive texts. I am wondering how the recently introduced canvas column can level up this game. To be continued!

I hope you enjoyed this article. If you have questions feel free to reach out. Though this article is for free, my work (including advice) won’t be, but there is always room for a chat to see what can be done. Besides you find my (for free) contributions to the Coda Community and on Twitter

My name is Christiaan Huizer and I am the owner of Huizer Automation. A company specialized in serving SME in harvesting data and keeping it aligned. I am a Coda Consultant & Expert and rely mainly on Coda, Mailjet, Zapier & Paperform to get the job done.

Huizer Automation — Coda Expert and Consultant on “How to Coda a language sensitive template?”




Christiaan uses Coda mainly for planning & calculations of all sorts. Follow me to learn how to Coda with numbers. I blog at least once per week.

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Solid Principles:

Building Event Driven Architecture using AWS Kinesis, Lambda And Node JS

Interface vs Abstract class vs Concrete class

What is Math? (For Rubyists)

Run Command in instance without SSH — AWS Systems Manager

Composing A Scene in Unity

Deep Learning on Qubole Using BigDL for Apache Spark — Part 1

PDF OCR via React, Django REST Framework, and Heroku Part 2: Test Our Django Back End with Postman

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
Christiaan Huizer

Christiaan Huizer

Christiaan uses Coda mainly for planning & calculations of all sorts. Follow me to learn how to Coda with numbers. I blog at least once per week.

More from Medium

How to skip over blanks in Coda?

Old doc, new year: Part III

How to Coda with VAT — Part I

How to Coda dummy data?