Sorry if this has been asked before but my search terms aren’t filtering the right answers for me!
Is it possible to apply a style (in this example, bold) to how a document displays in a view depending on a particular variable? I can’t seem to find a column formula to do it.
I can use another workaround to change the colour and use capitals but not apply bold!
I’m implementing a database of job descriptions and the user has requested I display it like below. Each document in the view is a job description. I’ve tried every which way I can think of and been through the API but can’t find a way of doing it.
Am I having a new year’s memory blank?
Denotes bold
Division Dept Job Description
Division1
*Head of Division1*
Dept1
Dept staff1
Dept staff2
Obviously I can bold the Division column in the designer but can I format how the job description document displays for the head of the division differently from the other staff? I’ve got a nasty feeling the unread marks for documents in a database are the sticking point but someone cleverer than me might know a way!
Thanks in advance
Chris
Subject: RE: Is there a Notes column Formula to make a document display in bold within a view?
In the Notes client, there’s no way to apply formatting selectively on some rows. You can, however, set the background or foreground color of a row (or of selected columns on the row) using a color column. I believe this overrides the coloring of unread rows.
You can also display an icon on some rows but not others using an icon column formula that returns an icon number, image resource name, or “” (the latter for no icon).
Subject: RE: Is there a Notes column Formula to make a document display in bold within a view?
Hi Andre,
Thanks for that. I’ve been playing around using row colouring and capitalization (@Uppercase came in handy) and we these techniques as well as icons quite extensively in our workflow applications. Quite bizarre how you can do all this but not apply a simple bold! The user had reported back to me in this case however that it looked ugly!
I think I’ll just have to diplomatically tell her it’s the best we can do 
Cheers anyway
Chris
Subject: Is there a Notes column Formula to make a document display in bold within a view?
Make the view as HTML.Add this formula to your column:
@If(fieldA=“yes”; “”+ fieldB + ; fieldB)
Regards
Litty Joseph
Subject: RE: Is there a Notes column Formula to make a document display in bold within a view?
Hi Litty,
Thanks for the response…I’ve ticked “Treat view contents as HTML” and added the formula. However now I’m just getting Field a in the view, it doesn’t seem to be rendering the HTML tags in the text.
Is there another option somewhere or doesn’t this work in the client?
Cheers!
Subject: RE: Is there a Notes column Formula to make a document display in bold within a view?
Hi Litty,
Thanks for the response…I’ve ticked “Treat view contents as HTML” and added the formula. However now I’m just getting Field a in the view, it doesn’t seem to be rendering the HTML tags in the text.
Is there another option somewhere or doesn’t this work in the client?
Cheers!
Subject: RE: Is there a Notes column Formula to make a document display in bold within a view?
Nope, doesn’t work in the client (and it wouldn’t work on the web straight away without further modifications either).
I don’t think that what you are asked can be done, but it’s a little hard to tell, as the forum removes all indentions, so I’m not 100% sure, how the formatting of the view should be. Maybe you could edit your posting and try to add dots or minuses to indicate the indention levels?