One way sync or a two way sync, you may need it — One task one doc In an remarkable contribution, Coda employee Al Chen wrote: These days, I try to have my templates do one thing and one thing well. Let me rephrase this to one task, one doc. Late 2022 I described how complexity can turn against you easily. Since then we have descriptions in…

2 Way sync is coming → sync your data as a pro — Coda is known for its many virtues. Certainly when it comes to the Coda Formula Language, actions (buttons — automations), templates & packs. The tool is used by teams of all sizes and supports a vast variety of use cases in which collaboration and data sharing are key. The central…

Why a button is your friend to track changes — I contributed in a discussion on how to keep track of sales in a table. The idea was to create a set up many makers feel familiar with. You take a value living on a previous row and or add or subtract a value. While this works very well in…

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…

How to show users the items in the language of their choice? — I have one table that generates multiple forms. Each form is language specific, I have a French form, a Dutch form and an English form. In each form there are some drop downs and I only want to offer the items in the language of the form. …

The first letters of your middle names in legal documents — When we ask for personal data it is often about a first name, last name, email address and so forth. Certain professions like lawyers notate names differently. They use initials that reference the full name. When I was reading the testament of my late father, I read all full names…

based on a public puzzle — It all started on Twitter when Scott Weir posted a challenge. I noticed it only a few days after and liked the logic. Below his challenge and the solution. His solution is clever and a bit complicated, mainly due to the syntax. The inline comments help. First have a…

What is 100K worth today when you receive it in 10 years? — The answer depends on the percentage you apply to cover interest rates and opportunity costs. Most Coda makers understand how to apply the Power() function to deal with interest rates and understand how much they need to be pay when you take a mortgage. I wrote a blog about it…

Using AI to get results Duration() does not provide for — Previously I wrote about the function Duration() and why it needs some love from the Coda engineering team to overcome some issues. In the blog below I wrote about the negative time and why ‘ago’ is often not the solution you need and why we need additional parameters. How to Coda negative hours? Use Sum() and Product() to get a visual coherent outcomehuizer.medium.com