I have a “Requirements” table with the following fields:
- ID
- Description (rich text)
- Question (rich text)
I want to render all of the records as a single document so I can email it. Example (with Markdown formatting):
# Outstanding questions
## {id 1}
{description 1}
### Question
{question 1}
## {id 2}
{description 2}
### Question
{question 2}
...
My current attempt: Write a script and use output.markdown(...)
to render everything.
The issues: record.getCellValue('Description')
returns a string, but that string isn’t suitable for passing to output.markdown(...)
. For example, if there is a “[” in the string, it’s interpreted as a link. Is there a way to render rich text values properly?