KPIs for Everyone The HTML Calculated Fild每个人 HTML计算领域的关键绩效指标.pptVIP

KPI’s for Every Version of SharePoint! Brad Saide * The HTML Calculated Field What is it? How do you use it? What can it do for me? Ideas! More Info? * What is it? * Is a Standard OTB Calculated Field Comes with both WSS 3 MOSS Requires No Installation (Great for Hosting) So… How do you use it? The HTML Calculated Field * Use it to “Build” Conditional HTML Strings You can set conditions based on: Status Numbers Percentages Dates …Essentially anything you can test for, you can build a HTML Calculated Value to represent it. Problem is, the HTML gets parsed and rendered as text, Right? Yes… until you add this bit of JavaScript! The HTML Calculated Field * script type=text/javascript /* Text to HTML - version 2.0 Questions and comments: Christophe@PathToShareP */ function TextToHTML(NodeSet, HTMLregexp) { var CellContent = ; var i=0; while (i NodeSet.length){ try { CellContent = NodeSet[i].innerText || NodeSet[i].textContent; if (HTMLregexp.test(CellContent)) {NodeSet[i].innerHTML = CellContent;} } catch(err){} i=i+1; } } // Calendar views var regexpA = new RegExp(\\s*([a-zA-Z]*)(.|\\s)*/\\1?\\s*$); TextToHTML(document.getElementsByTagName(a),regexpA); // List views var regexpTD = new RegExp(^\\s*([a-zA-Z]*)(.|\\s)*/\\1?\\s*$); TextToHTML(document.getElementsByTagName(TD),regexpTD); // Grouped list views ExpGroupRenderData = (function (old) { return function (htmlToRender, groupName, isLoaded) { var result = old(htmlToRender, groupName, isLoaded); var regexpTD = new RegExp(^\\s*([a-zA-Z]*)(.|\\s)*/\\1?\\s*$); TextToHTML(document.getElementsByTagName(TD),regexpTD); }; } )(ExpGroupRenderData); /script The HTML Calculated Field * What can it do for me?Demo Ideas - Dashboard Task Calendar * Ideas – Project Status Dashboard * This is a CQWP Rollup Ideas – Highlighting List Items * From This… To This… Bold Mgr’s Name * Benefits Easy to change No Developer Required 0 Impact to SharePoint No Upgrade issues ? Business can create the Formula