Hey all, wanted to share a really important bug you’ll run into when you’re using concatenate(). Specifically, if you’re mixing in Rich Text and Hyperlinks, Coda will drop some of the formatting. But, there’s a solution. Instead of using concatenate() use join("", list()) instead. Here’s what it looks like in practice
=Concatenate([Test: Concatenation].Text.nth(1), " ", [Test: Concatenation].Link.nth(1))
=Join("", List([Test: Concatenation].Text.nth(1), " ", [Test: Concatenation].Link.nth(1)))
An example wouldn’t be complete without a screenshot. In it, you can see the original table, and how join()+list() will preserve the rich text attributes. Hope this helps someone else out!