Share
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
0
Name
Link
1
Eric
2
Mary
3
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 by
Eric
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.