Beast Mode - CONCAT with a carriage return?

kivlind
kivlind 🟡
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 Portland, Oregon 🥷
    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 🟡
    Answer ✓

    Thanks!!!

Answers

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🥷

    @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