0

Problem with multi-line rich text fields

I'm experiencing a problem when importing data from a csv file into a rich field. The import process combines all lines in a field into one line.

The same thing happens if using Update Multiple Records, and specifying a formula to copy the fields. For example:
Text1 is a multi-line field.
Text2 is a rich text2 field.
When updating multiple records, I put this formula into Text2: Text1
The result was that all of contents of Text1 were added to Text2, but all lines within a field were combined into one line.

9replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Birger H
    • Birger_H
    • 2 yrs ago
    • Reported - view

    Please import into the multiline Text (Text1).

    Birger 

    Like
  • I can do that. But how can I copy the data from there into the Text2 field, and still retain multiple paragraphs?

    Like
  • Hi Chuck, 

    You can use the following formula in the function "Update multiple records" to transfer the content of a "Multiline text" field with the line breaks into a "Rich text" field:

     

    replace('Text (mehrzeilig)', "
    ", "<br>")

     

    Kind regards, Jörg

    Like
  • I don't understand what "mehrzeilig" is.

    Like
    • Support
    • Support
    • 2 yrs ago
    • Reported - view

    Hi Chuck, 

    -> multi line

    (that's only the name of my multi line text field) 😉

    Best, Jörg

    Like
  • Ok, thanks!

    Like
  • That didn't work, but this did:

     

    replace(text (Text1), "
    ", "<br>")

     

    Thanks for pointing me in the right direction.

    Like
    • Luis
    • Luis
    • 1 yr ago
    • Reported - view

    Add-On - 

    Everything else works... eg from the "Fonts" menu... eg Bold, Underline... 

    Also from the "right click" menu: eg "Transformations" and then Upper Case, Lower case, Capitalise etc etc

    Like
    • Luis
    • Luis
    • 1 yr ago
    • Reported - view

    sorry!!!! answer to the wrong question !!!!

    Like
Like Follow
  • 1 yr agoLast active
  • 9Replies
  • 1685Views