Is it possible for me to use a formula to extract highlighted text from a canvas column into another column? I’d like to try using Coda for progressive summarization.
Thanks!
It is possible with some black magic:
The formula will be:
ParseJson(thisRow.Notes._Merge() + "", "$..[?(@.highlight == 'Yellow')].text")
Returned value is a list of text values. You can then concatenate it, make a bullet list or whatever. There will be issues if there’s other formatting present in parts of the line (e.g. there’s a bold word in the highlighted line) — you’ll then get it split up in chunks of different formatting. It is possible to recreate it all but takes more effort than this.
That works perfectly! Thank you!!!