Preserving Rich Text Formatting from Jira

user028768

My team is leveraging a Domo Workbench connection into a on-premise Jira instance. Jira allows rich text formatting in many of the fields that we need, and I'd like to preserve that when I display the data in Domo text cards. I can see the patterns in formatting when I compare my Jira input to my Domo card (ex: [text] = _ + [text] + _, where text = * + [text] + *), but I can't figure how to to find the pattern and then apply specific formatting to the text in between. See attached for a comparison.

Can I do this via RegEx commands in Magic ETL - or is there an easier way in SQL? If RegEx, would I need to do a series of RegEx commands (1 for italics, 1 for bold) applied to every field where I'd want to have the card presented with the formatting?

I appreciate any help the user community could provide to me.

Domo_Rich_Text_Fields.png

GrantSmith

Hi @user028768

You can use the replace text tile with a regex. You can perform a regex on multiple different columns in the same tile but you'd need a tile for each formatting. The other thing to note is that the text cards typically don't support any text formatting with the exception of the HTML table using HTML code.

user028768

Thanks for the response here, @GrantSmith . I'm trying to reconcile your first statement ("you can perform regex" + "need a tile for each formatting") with your second statement ("text cards typically don't support any text formatting"). Are you indicating that I can use regex to change the data in Magic ETL, but it may be a moot point because the formatting will be ignored when displayed onto a text card?

GrantSmith

@user028768

Correct. You can change the data in Magic ETL however you won't be able to make much use of it within a Card in domo because it won't interpret the formatting and just treat it as text.

jaeW_at_Onyx

@user028768 ,

It looks like your text is actually MarkDown formatted... which is not the same as HTML and if it were me I would google and see if there are any other developers who've writtend out regex to convert MD to HTML tags.

Or maybe I'd run the data through a python package and then push it to Domo (via APIs)

regarding your numbers i guess if you do a sum(amount) you could wrap it in html tags. But Domo may have broken that functionality recently...

user028768

@GrantSmith , @jaeW_at_Onyx - Thank you both for taking the time to respond and provide insights. I will dig further with the direction that you have provided.

Derreck

@GrantSmith , @jaeW_at_Onyx Whats interesting to me is the airtable cloud integration displays correctly in Domo when using Markdown enabled in Airtable.

I linked two screenshots for reference. Also, If I copy the text from the Domo table card I see the following when I paste in Apple Notes:

1. Fighting with suppliers for many request to increase price of purchase – 4%\n2. Late delivery date confirmed from Hydraulic Suppliers\n3. Short Time working in production , supported by Government (on a low level)\n4. Prototype New T300.4 is in Test Period, as well as the ST31\n5. Lead Time growth (also because of internal orders between RM and the Group companies) \n\n

- Test\n- Test\n- Test\n- Test\n- Test\n- Test\n

CleanShot 2021-04-28 at 12.56.40@2x.png

CleanShot 2021-04-28 at 12.56.02@2x.png

jaeW_at_Onyx

Domo HTML Charts will display content that's been encoded with HTML tags. Mega Charts support some HTML encoding. I believe Pivot Tables support the least amount of HTML encoding.