For the most part, this works well. The issue I’m running into is when I paste the content, it’s adding additional commas. For the life of me, I can’t figure out how to update the formula to not include those extra commas. If I replace all commas in the formula with +, then the hyperlinks don’t work. I’d appreciate any advice!
Also, if possible, I’d like the formula to bold the first App Name.
First thing to understand is the RETURN value type of a formula. Your data in Coda has different types. Some examples are:
Text
Number
Row Value
Date
Boolean (true/false)
And most importantly:
Lists
Notice here, I did a simple forEach() Loop on your table, and it returns the values in that table with a comma between each value because forEach() Loops ALWAYS return LISTS
You can also confirm that the return type of a forEach() loop is a list here. The chip-icon on actual chip itself has a little shadow letting you know that the value is a list.
Here is full documentation on Coda formula chips and value types - I recommend giving it a look
So that is the source of your rouge commas - commas are an indication of a list. So how do we get rid of them?
Well one really good way to turn lists into plain text value is to JOIN lists via a certain character. The Join() formula in Coda was made just for this!
Notice here with this simple forEach() list, I used Join(lineBreak()) which allowed me get ride of my commas, and return my values stacked!
@Scott_Collier-Weir I cannot thank you enough for your generous response. This is truly above and beyond. Your solution is perfect, and I really appreciate you sharing so many resources so I can continue to learn. I am going to deep dive into as much of this as I can. I’d love to absorb as much as possible. If there’s anyway I can upvote you, please let me know. I am truly in awe.