Using text mode to concatenate custom rich text field in a report? getting error message | Community
Skip to main content
U
user01245
Level 2
December 23, 2024
Solved

Using text mode to concatenate custom rich text field in a report? getting error message

  • December 23, 2024
  • 2 replies
  • 566 views

I have a custom rich text field called /Request notes'. I want to include it in a report, but concatenate it so only the first 200 characters are shown.  When I try to do this by using text mode and replacing 'valueifled' with 'valuexpression' like I do with other fields I get an error message when loading the report.  Do I have to do something different because this is a rich text field?

Here's what I've tried that results in an error:

valueexpression=IF(LEN({Request notes})>150,CONCAT(LEFT({Request notes},150)," (cont...)"),{Request notes}) valueformat=customDataRichTextAsString linkedname=direct namekey=Request notes tile.name=component.customdata.richtextlistview type=tile



Thank you in advance for your help!

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Rafal_Bainie

    I believe you cannot use rich text fields in expressions. To verify this, try this formula in calculated field in Custom Forms section. I'm pretty sure this formula won't work there either.

    2 replies

    Rafal_Bainie
    Community Advisor
    Rafal_BainieCommunity AdvisorAccepted solution
    Community Advisor
    December 24, 2024

    I believe you cannot use rich text fields in expressions. To verify this, try this formula in calculated field in Custom Forms section. I'm pretty sure this formula won't work there either.

      KellieGardner
      Community Advisor
      KellieGardnerCommunity Advisor
      Community Advisor
      December 31, 2024

      @user01245 - Rafal is correct. Rich Text Fields cannot be used in calculations or text mode because of how they are stored. They are also very difficult to use in Fusion. I usually recommend systems not use the RTF if they are going to be doing any type of expanded reporting or integrations.

       

      There's an idea out there you can upvote Ability to use rich text format fields in Calculat... - Adobe Experience League Community - 529845

      Terms & ConditionsAccessibility statement

      Loading footer...