One text box for multiple text cards?

Canio
Canio Member
in Cards, Dashboards, Stories

I may be coming at this wrong. I tried to concat but on occasion a zip is missing or something like that. I think I want to use a notebook card somehow, but my brain is blocking me from thinking outside the box.

How would you get this data in multiple text cards, into one?

image.png

Tagged:

Best Answers

  • ColemenWilson
    ColemenWilson Coach
    edited January 31 Answer ✓

    To put the text in a summary number you'd create a beastmode and then select it as the summary number value:

    CONCAT(`street`,' ',`city`,', ',`state`,' ',`zip`)

    If I solved your problem, please select "yes" above

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    CONCAT can have trouble dealing with nulls, so I would suggest wrapping each element in IFNULL and replace it with an empty string, like this: IFNULL('zip','')

    Hope this helps you.

    **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.
  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    Like this:

    CONCAT(IFNULL(Street1,''),' ',IFNULL(city,''),', ',IFNULL(state,''),' ',IFNULL(Zip,''))

    **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.

Answers

  • Canio
    Canio Member

    It just dawned on me I can put text in the Summary number. Now I can't remember how though!

  • ColemenWilson
    ColemenWilson Coach
    edited January 31 Answer ✓

    To put the text in a summary number you'd create a beastmode and then select it as the summary number value:

    CONCAT(`street`,' ',`city`,', ',`state`,' ',`zip`)

    If I solved your problem, please select "yes" above

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    CONCAT can have trouble dealing with nulls, so I would suggest wrapping each element in IFNULL and replace it with an empty string, like this: IFNULL('zip','')

    Hope this helps you.

    **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.
  • Canio
    Canio Member

    @MarkSnodgrass talk to me like I'm a 2 year old?

    CONCAT(Street1,' ',city,', ',state,' ',Zip) How do I wrap each one?

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    Like this:

    CONCAT(IFNULL(Street1,''),' ',IFNULL(city,''),', ',IFNULL(state,''),' ',IFNULL(Zip,''))

    **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.
  • Canio
    Canio Member

    @MarkSnodgrass brilliant! I must have been missing a paren

    Thank you both!

  • Canio
    Canio Member

    ok, next level…is there a way to do a line break? ;)

  • MarkSnodgrass
    MarkSnodgrass Coach

    I have been able to use the HTML br tag in summary numbers to do line breaks. Like this:

    CONCAT(IFNULL(Street1,''),'<br />',IFNULL(city,''),', ',IFNULL(state,''),' ',IFNULL(Zip,''))

    **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.
  • Canio
    Canio Member
    edited January 31

    freaking brilliant! I'm going to just use as a card now and drop it into a Dashboard, so looks like that </br> isn't gonna work. But totally fine! Again, thank you so much.

    update: duh, I just needed to remove a space on the brackets:

    '<br/>'

Categories