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

  • Author
    Posts
  • #23298

    cosmeticsolutions

    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

    rnedelkow

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

  • #23300

    cosmeticsolutions

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

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

  • #23301

    rnedelkow

    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

    cosmeticsolutions

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

  • #23303

    rnedelkow

    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.