Beast Mode - CONCAT with a carriage return?

kivlind
kivlind Contributor
in Charting

Looking to CONCAT several address fields into one, but with carriage returns between


Name

Address

City State, Zip

Any thoughts on how to accomplish this in a beast mode?

Best Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    If you are using the mega table card, you can use \\n to force a new line. Example:

    CONCAT('Name','\\n','Address')

    If you are using the HTML table card, you can use <br />, which the HTML tag for line break:

    CONCAT('Name','<br />','Address')

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • kivlind
    kivlind Contributor
    Answer ✓

    Thanks!!!

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    If you are using the mega table card, you can use \\n to force a new line. Example:

    CONCAT('Name','\\n','Address')

    If you are using the HTML table card, you can use <br />, which the HTML tag for line break:

    CONCAT('Name','<br />','Address')

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • kivlind
    kivlind Contributor
    Answer ✓

    Thanks!!!

  • MarkSnodgrass
    MarkSnodgrass Coach

    @kivlind no problem!

    If this worked for you, please mark the answer as accepted so that it can help others in the community.

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories