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.
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…
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
In this blog I’ll explain how we created this multi language SearchBox and how we overcame an undocumented issue with
Á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:
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.
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
False(), the rest of the formula simply tells…
Find & Replace, is that not like the horse and the carriage going together like love and marriage? It might feel that way, but once you dive into the Coda logic, you see something else.
This article is about how the function
Find() operates inside Coda and aims to clarify three use cases:
I responded to a question in the community on how to filter on something predefined. The questions was:
I want to filter it to show…
Having a mechanism that informs you in time that someone has her birthday in the days to follow, would be great for many people. At least one could timely order chocolate and flowers!
This blog shows how you can use automations in Coda to notify you days before the BD. This blog is not about GDPR and privacy rules related to the question if you have the freedom to share the BD date with colleagues for example. In the Coda blog about BD, GDPR alike rules do not seem to apply. …
Keeping data aligned is a challenge. Partly because data changes (people move, change phone numbers, use different email addresses and so on) and partly because data lives in different systems throughout the organisation. This blog is about how to bring data together and to deduplicate using a button outside a table.
Often I am called in for a job that should have been ready yesterday and is related to data collection. To move on fast, I create a new table in a doc and link it to the form I put online to harvest the data. When the project is…
You can easily use the Find and Replace features in any spreadsheet like Excel to search for a particular number or text string. You can either locate the search item for reference, or you can replace it with something else. Though it is simple, there are even videos explaining how to execute this simple task that only requests filling out two fields: find what you are looking for and the replacement.
This blog is about some essentials in Coda I already used in various posts. However if you are new to Coda and you want to speed up your understanding, this might be of help.
IsBlank( )it is still an item in this list