Practical tips to get the results you need — In Coda we have late July 2023 three ways to use AI: on the canvas, acces via “ / “ to see the options in a table on row level and on column level AI blocks — via the canvas These AI tools permit you for example to: Create a…

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…

An advanced find & replace logic partly based on Regex — I got a question to support an advanced find & replace logic. In the doc a dirty string had he to be replaced by a clean string. The dirtiness was the result of mistyping, misspelling, and or failed manuel cleaning efforts. …

Why date time data is essential in your set up — In the community every once in a while questions surface on how to get the previous row value to calculate with. Mostly the questioner simplifies the question to get an answer in its simplest form and that means in many cases stripped from the original date time relation. As a…

Get the most recent price applying a BOM logic — We all know that prices change. Promotions make things (temporarily) cheaper while inflation or market demand shows itself in higher prices. When you want to review an invoice from a while ago, you need for that invoice the prices valid at that time. This is only possible when we timestamp…

Keep them up to date using a BOM logic — Since we have various column types like email, URL, text and number and because we often collect contact information like an email address or a phone number via forms or modals, it is easy to see why we structure a table as we do below:

Get always the most recent address — We all know that address and contact information changes over time. To keep track of these changes we can overwrite an old address with a new address or we can add the new address, time stamp it (as we did with the old address) and filter on the most recent…