HOW TO: CREATE a Practical Dashboard using a SharePoint List & jQuery…
2013 06 23 MV to All: OK, so I realized I’d never actually posted a handy little jQuery approach to transforming your SharePoint lists into actual – genuinely useful – dashboards.
So WHAT really makes a dashboard useful? In a word – color-coding. Period. Full Stop. Graphics don’t really add a thing to the equation – they’re just complexity for the sake of complexity. Color a few key cells Green, Yellow (even Orange) and Red, and in a single customization you draw The User’s attention to the Red Ink.
Here’s a way to add some very simple, “inheritable” (remember how I DEMAND my solutions be INHERITABLE by clients?) jQuery to a SharePoint list on a page via the CEwp (Content Editor web part).
Here’s the page in Edit Mode, showing a CE wp at the bottom of the page, pointing (NO embedded jQuery/HTML in the CEwp – it doesn’t always work in Office 365) to a txt file in a nearby SharePoint library filled with jQuery:
Here’s the actual jQuery library. NOTE – I could have also simply referenced any of the popular CDN-based repositories for a copy of the jQuery library, and in most cases that’s what I DO – for several reasons.
But for now let’s keep things “in” SharePointland:
SOURCE CODE FROM CELLBGCOLORIZERJQUERY.txt :
– friend & colleague Kiran Kakanur for helping me discover the oddity about CSS delimiters in jQuery …