Is there a way to copy the inline link text to a new field or into an email report?

Question

I'm building a Trello email report. The report simply lists all the description fields from a number of cards. In each card, the description is a URL.

The pattern I've set in the automation is "[{carddescription}]({carddescription})
" but simply putting "{cardescription}
" gets the same result in the report: a list of the URLs.

However, in each card, the description field of the card shows the URL as an inline link — that is, it displays the META title of the URL rather than showing the URL itself. (this is the smartlink, i guess?) And that's just what I want to reproduce in the report.

I'm getting:

* https://www.mycompany.com/blah/blah/blah
* https://www.mycompany.com/yeah/bam/boom

What I'd like to get is the title of the page as a hyperlink:

* The Blah Blah Blah
* The Yeah Bam Boom

Is there a way to get the report to include the inline link as it does in the description field of the card?

I've tried adding the link as an attachment and then copying the name of the attachment — {attachmentname} — but that hasn't worked. I've also tried workarounds to use the variables {mentionlessmentiontext} and {linklessmentiontext}, among others, but with no luck.

Andrew Eitelbach · Answer

I have a found an ugly workaround, but I think someone who knows JSON could help me create a more elegant solution: I created two automations: * when a card with a complete due date is moved into list "tiger", get url "https://www.mywebsite.net/blah/blah/id/{cardname}", and set the card's description to "{httpresponse}" * when the description of a card in list "tiger" with a complete due date contains "{?} | HELLO", rename the card to "{wildcard1}" From there, it's just a matter of turning the card name into a hyperlink in the report by using the pattern [text](link) But isn't there a way to use JSON to augment the {httpresponse} variable to return ONLY the character string between the tags? Or is there a way to use a REGEX within the {httpresponse} variable? I'm good at REGEX and shaky at variables, but I know diddly about JSON other than that it exists and can probably solve my problem in one automation rather than two. Any thoughts?