Microsoft 365 Community Column and view formatting tips, 26 Jan 2019

Previous Meeting Next Meeting

⏯

youtube image

►

From YouTube: Community Demo - How to apply column formatting to multi-line columns?

Description

Recurrent column and view formatting tip demo taken from the SharePoint dev Special Interest Group recording at 24th of January 2019. This time Chris shows how to apply column formatting to multi-line columns?

Presenter - Chris Kent (DMI) - @theChrisKent

More details on the SharePoint dev community calls from http://aka.ms/sppnp.

A

Okay, hi everybody, I'm Chris, Kent, I'm, an office, development, MVP and remember the core team. Let's take a look, so this you'd be glad to know for your marketing overlords they're concerned about the warrior horses that the worried horses have gone corporate alright.

A

So now, let's see what they got to do so as now they're going corporate and they're trying to incorporate more enterprise level battles, they need to really bump up on there they're a corporate, nothing, that's right! So the little speeches throughout the day, so I'm gonna, take a look at that. So I've got this list over here, alright folded, my corporate, nothing! This I got a nice title and I've got in a little speech.

A

They need to do here right and generally, if I wanted to call them formatting it's as simple as I come down here, call them settings, I, say format, this column and I paste an exciting format. All right all this one does is. It applies teal text right that was easy. So now I come over here and I've got our nice repo here, get that we've got all sorts of cool samples and I come in here to call them samples and I.

A

Look down here and I, say: hey look, text, wrap format, I think this is exactly what I want. What this will do is it'll. Take this stuff right here. What's getting cut off there, I want to see that full speech right, so horses have hooves. You know using a mouse is hard, so I want to show the full speech all at once so I'm gonna grab this format. It's a really simple format. It's actually one of our earliest ones.

A

Now come back here and like okay, I'm going here, there's no formatting this column option for multi-line text fields. What do I do? Oh good news, although that is strange and not obviously you can always do this for all columns. You can go into list settings choose your column down here and there's this nice little field all right down here where you can paste your column, formatting directly right, so I can expand that out.

A

So you can see little there, so I'm going to paste that format I got from the sample all right, we're gonna see if we can make it just slightly fancier, alright, we're gonna, add attributes. Let me edit it right here.

A

What's that a class all right just to make it a little more obvious that something that applies when it's the MS on color I'll save feet? Okay, all right! So we save that. Okay, on that now we go back to our exciting site boom. Now you can see the full thing and it's a lovely shade of blue, but the whole idea here is for whatever reason, multi-line text fields don't have that option so just to review what we did take a look back here.

A

Does that you normally do it for coma formatting but you're, sad down, because you can't do it a multi-line go in there. Little list settings choose your column, column, formatting, paste it right. There you're good to go, you'll, see the same thing in site columns, so you do this for all of them. So if something else doesn't show up here, you go alright. One caveat, though, on this is: don't use rich text, just it's not recommended, don't use it so list formatting is going to always encode your values.

A

That's why you can't just do HTML directly. You've got to do that. Elam type right and rich text values. They come back as HTML. Therefore your HTML will be encoded and displayed, and you will be sad, so just don't use rich text.

A

If you can use multi-line play text all over the place, you can easily reference that any other format or view format, everything as needed, and finally, here's some other resources so check out the full documentation here find out what kind of columns are allowed all that kind of stuff here's that sample and then, if you want to a longer write-up of that, you can go to this link here, paste that in there, so it's a slightly longer blog because that's it for the list. Formatting tip this week.