0

Display a text sequence in html format

Hello,

I would like to find a formula that allows me to display in a formula field the content of several other formula fields whose content is html()

Here is an example of a formula that I would like to reproduce but the join() function does not seem to accept the html format

let gatherData := ('Historique des activités 1:N'.'Arbre de vie'['Type d''évènement' = 6] order by -date('Date du rendez-vous'));
join(gatherData.'Synthèse concaténée',"
")

My goal is to display in a formula field a visual summary of the contents of all the 'Synthèse concaténée' fields that are in HTML format and in descending order.

Since the text is formatted in HTML format with titles, line breaks and bold, I absolutely must keep this formatting.

Is this possible? Thanks for your help.

5 replies

null
    • Fred
    • 4 wk ago
    • Reported - view

    you can wrap the last line in html() instead of join.

    html(gatherData.'Synthèse concaténée')
      • Créateur de bien-être
      • Sebastien_Guillet
      • 4 wk ago
      • Reported - view

       Thanks, it works!

      I have a comma that is automatically added between each paragraph. Is it possible to remove it or replace it with a horizontal line <hr>?

      • Fred
      • 4 wk ago
      • Reported - view

      Yeah, I was trying to figure it out but I couldn't at the moment. But try this:

      let getRecs := (select Table1);
let finalHTML := html("");
for rec in getRecs do
    finalHTML := html(raw(finalHTML) + raw(rec.Formula) + raw("<hr>"))
end;
finalHTML

      I get something like:

      • Créateur de bien-être
      • Sebastien_Guillet
      • 3 wk ago
      • Reported - view

       It works, thank you very much

    • Fred
    • 3 wk ago
    • Reported - view

    Thinking a bit too much about this. To make things a bit easier in the future is to breakup 

    'Synthèse concaténée'

    into two parts. One would be a new formula field (preHTML) that is just the html without the html() command. Then 'Synthèse concaténée' would be the field you show when you wrap the preHTML field in html().

    Then you can the code can drop the raw part:

    let getRecs := (select Table1);
let finalHTML := "";
for rec in getRecs do
    finalHTML := finalHTML + rec.preHTML + "<hr>"
end;
html(finalHTML)

    This allows you to combine different html sections together easier since it is just text.

Login to reply

Content aside

Categories

View all topics
  • Status Answered
  • 3 wk agoLast active
  • 5Replies
  • 59Views
  • 2 Following