Explore

Experimenting with Hyperlinks

It looks like Coda treats lists of Hyperlinks in a variety of ways, none of which add up to the result I wish I could have. What I would like is a prefix before the list with the items in the list still legibly separated and linked. Make a copy of this doc to play with the formulas.

Table

Table

Name

Link

Eric

Mary

Charlie

There are no rows in this table

⁠

ForEach()

⁠

Eric Mary Charlie

⁠

The raw output of ForEach() produces a List.

⁠

Concatenate: Eric ⁠ ⁠Mary ⁠ ⁠Charlie ⁠ ⁠

⁠

It seems that Concatenate() collapses the list so that there is no longer any punctuation.

⁠

Plus: ["Eric", "Mary", "Charlie"]

⁠

But the + operator seems to “stringify” the list in a very JSON way.

⁠

Eric, Mary, Charlie

⁠

And the Join() function also stringifies the list, but in a way more similar to the ForEach() output, but without the links intact.

FormulaMap()

As far as I can tell, FormulaMap() is exactly the same as ForEach() , they behave identically and are documented in exactly the same way.

⁠

Eric Mary Charlie

⁠

Concatenate: Eric ⁠ ⁠Mary ⁠ ⁠Charlie ⁠ ⁠

⁠

Plus: ["Eric", "Mary", "Charlie"]

⁠

Eric, Mary, Charlie

⁠

A solution

⁠

Organized byEric Mary Charlie

⁠

This very simple solution adds the prefix using ListCombine(), which accomplishes everything except proper punctuation.

⁠

We see Eric ⁠ , Mary, and Charlie ⁠ ⁠

⁠

This much more complex solution allows for a prefix, the word “and”, and even the Oxford comma.

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.