This topic contains 5 replies, has 0 voices, and was last updated by rnedelkow 5 years, 10 months ago.

  • Author
    Posts
  • #23298 Score: 0

    cosmeticsolutions
    • Contributions: 0
    • Level 1

    i am trying to concatenate a text series, is there anyway to enter a line break?

    below is my function.

    CONCAT({custrecordcs_pc_display_name}, CONCAT(' ' , CONCAT({custrecordcs_pc_unlabeled_config.descripti on}, CONCAT(' ' , CONCAT({custrecordcs_pc_component_1.displayname}, CONCAT(' – ' ,{custrecordcs_pc_label_1.custitemlable_media})))) ))
    This is a cached copy. Click here to see the original post.

  • #23299 Score: 0

    rnedelkow
    • Contributions: 0
    • Level 1

    This format works for me in most cases – {field1} || ‘< br >’ || {field2}.

  • #23300 Score: 0

    cosmeticsolutions
    • Contributions: 0
    • Level 1

    hmmm. i tried this and got an error. what would the entire string look like?

    CONCAT({field1} || ‘< br >’ || {field2})

  • #23301 Score: 0

    rnedelkow
    • Contributions: 0
    • Level 1

    Something like:

    CONCAT({custrecordcs_pc_display_name} || ‘< br >’ || CONCAT(' ' , CONCAT({custrecordcs_pc_unlabeled_config.descripti on} || ‘< br >’ || CONCAT(' ' , CONCAT({custrecordcs_pc_component_1.displayname} || ‘< br >’ || CONCAT(' – ' ,{custrecordcs_pc_label_1.custitemlable_media})))) ))

  • #23302 Score: 0

    cosmeticsolutions
    • Contributions: 0
    • Level 1

    OK – that didn't work still getting an error. any other ideas?

  • #23303 Score: 0

    rnedelkow
    • Contributions: 0
    • Level 1

    I tried something similar without the concat parts and it worked for me. Your formula might look like this:

    ({custrecordcs_pc_display_name} || ‘< br >’ || {custrecordcs_pc_unlabeled_config.descripti on} || ‘< br >’ || {custrecordcs_pc_component_1.displayname} || ‘< br >’ || {custrecordcs_pc_label_1.custitemlable_media})

You must be logged in to reply to this topic.