One text box for multiple text cards?

Canio

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?

ColemenWilson

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`)

MarkSnodgrass

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.

MarkSnodgrass

Like this:

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

Canio

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

ColemenWilson

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`)

MarkSnodgrass

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.

Canio

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

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

MarkSnodgrass

Like this:

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

Canio

@MarkSnodgrass brilliant! I must have been missing a paren

Thank you both!

Canio

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

MarkSnodgrass

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,''))

Canio

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/>'