Friday, July 20, 2012

SharePoint Calculated Columns: Render HTML, Color coding etc

3 Important tips to note when creating calculated columns that display color coding, robots, hyperlinks, that are generated on SharePoint page rander.

- When you place your JavaScript code in your content editor web part, always remember to move the webpart to the bottom of the page. Somehow its like SharePoint Pages load webparts bottom-up.
- The HTML codings in columns don't work on personal views, only on public views.
- The HTML codings in columns don't work when your view is has groupings and the view loads with groupings collapsed.

Cheers.

1 comment:

Stu said...

Hi Chris,

I believe once of Christophe's (Path To SharePoint) later versions of his HTML JavaScript allows for grouped views.

Another couple of options might be Sarah Haase's XSL:
http://sarahlhaase.wordpress.com/2012/06/06/using-calculated-columns-to-add-color-coding-to-your-sharepoint-lists

Or my company's free HTML Calculated Column:
http://www.pentalogic.net/sharepoint-products/free-stuff/html-calculated-column