Skip to main content

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.

Comments

Anonymous 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

Popular posts from this blog

Zambia's first K2 BlackPoint roll-out

Reporting to you live from Code|Influence... My colleague and I have been managing our organization's SharePoint infrastructure for some time now and we have just rolled out the first K2 BlackPoint in the country, intended mostly for SharePoint workflow developments.

SharePoint: How to create a custom action to open Word Documents using "Edit in Microsoft Word".

Imagine you have a SharePoint custom search webpart, and on your search results, you return word documents, you will obviously want to at times be able to open them in your MS Word client program for editing. So basically, depending on your office client installed on your local machine, there are 2 different approaches that can be made for Office 2003 and Office 2007/10, using the same function " editDocumentWithProgID2 ". For Office 2003: - If your document libraries versioning settings have got "Require Check out" ticked, then you will first want to check out the document using: onclick ="CheckoutviaXmlhttp(‘{SiteURL}’, ‘{DocumentDownloadURL}’)" - Then to open the document, you use: onclick =" return editDocumentWithProgID2(‘ {DocumentDownloadURL} ’, ”, ‘SharePoint.OpenDocuments’, ’1′,’ {SiteURL} ’, ’0′);" href ="#" - and now combining the above 2 actions into one clickable action: onclick ="CheckoutviaXmlhttp(‘ {SiteURL} ’, ‘ {...

How to document your SharePoint Projects.

Here are the essential documents you need to complete… Initiation Business Case: To justify the financial investment in your SharePoint Project, you need to write a Business Case. It lists the costs and benefits, so everyone knows what the return on investment will be. Feasibility Study: Before you kick-off your SharePoint Project, you need to determine whether your project is feasible, using a Feasibility Study. SharePoint Project Charter: You then need to document the objectives, scope, team, timeframes and deliverables in a SharePoint Project Charter. Planning SharePoint Project Plan: You need to create a Project Plan listing all of the tasks required to undertake your SharePoint Project from start to finish. Every task must be scheduled, so you know what needs to be done and when. Resource Plan: Next, you need to plan your resources by documenting the money, equipment and materials needed for your SharePoint Project. Quality Plan: You then need to set quality targets, so that the S...