SharePoint driven rich text dashboard using jqueryui.


I had a task to update a dashboard created by another developer.  The functionality was
  • Groupings of buttons on the page with multiple colors
  • When clicked, the button opens a dialog window which displays either rich text or a webpage
  • There are up to three optional buttons at the bottom of the rich text.
  • When one of the optional buttons is clicked, you either see more rich text in another dialog, a webpage content in the dialog, or a link to a new page in a new tab

The previous developer wrote this in HTML and javascript using jqueryui to generate some nice looking in-page dialog boxes.  My goal was to make this content driven by a SharePoint list so the end user could maintain the dashboard.

I created a list with the following fields
I added descriptions to make it easier to understand.  The new entry form (below) is out of the box SharePoint with no InfoPath customization. Title must be unique, and section is limited to whole numbers 1-10.  The color choices are case sensitive and must match the CSS [black, red, orange, green, blue].  The Optional Button choices are also case sensitive and must match the javascript [Off, Link, Text, Link - New Window]




Here's a link to download the scripts and stylesheets. 

The Javascript file can be seen here.
The CSS file can be seen here.

That code will add to divs by name (case sensitive as well).  I suggest even these be in separate files and add a content editor web part for each one:

<div id="divregion" align="center"></div>
<div id="Section_1" align="center"></div>
<div id="Section_2"></div>
<div id="Section_3"></div>
<div id="Section_4"></div>
<div id="Section_5"></div>
<div id="Section_6"></div>
<div id="Section_7"></div>
<div id="Section_8"></div>
<div id="Section_9"></div>
<div id="Section_10"></div>

The last step is to add everything to a web part page.  Pick one that gives you a good looking layout.  I used the first option [header, three columns, footer]. The page has 13 Content editor Web Parts, and each one links to a file in the siteassets.

If you found this useful, please add comments below



Comments

Post a Comment

Popular posts from this blog

Setting SharePoint announcements to auto delete after expiration

Image
Setting announcements to auto delete after expiration One thing that always bugged me was the expiration date attached to an Announcement list that does nothing out of the box. Sure, you could always add a filter and change the default view but as soon as you add an Announcements web part to a page the view is UNFILTERED even if a filtered view is the only one to choose from.  You or I could change the default view, but we can’t trust all users to do so. A workflow would be fine to delete the item – simply pause until the expire date then delete the current item.  The workflow would stick with the template if you saved your list off as a template and then still work when you created a new list from that template.  That’s good, but still relies on the user creating the right Announcement list. The better answer was to change the Announcements default content type.  If anyone asks, tell them it’s called Governance, Sparky. The first step was to go to site sett...
Read more

Updating a single field in a SharePoint List using Power Automate Flows

Image
  Updating a single field in a SharePoint List using Power Automate Flows Updating a single field in a SharePoint List using Microsoft Flows (aka Microsoft Power Automate) can be a bit tricky with longer lists with lots of required fields and drop downs possibly resetting your data. The work around is code, but if there are non-developers creating flows, then this process is even more cumbersome. As a result, the Flow below will do the heavy lifting using a separate list and then anyone can populate that list from a different Flow when such a thing is needed. First step: create the list Here’s the input needed in this list. List: The name of the list SiteLink: The link to the site (trim off /lists/xyzlist) IDFromSource: This is the internal ID of the item to update FieldToUpdate: The name of the field you want to update. This is case sensitive. ValueForField: What you want to set it to. Next, create the Flow. Here’s what it will look like   When a Shar...
Read more

SharePoint driven rich text dashboard using jqueryui. (JQuery file)

Jquery file for Operations Dashboard Download this file <script type="text/javascript"> $(document).ready (       function()       {             SP.SOD.executeFunc('sp.js', 'SP.CamlQuery', RetrieveListValues);       } ); function RetrieveListValues() {       var query = new SP.CamlQuery(); query.set_viewXml("<View><Query><OrderBy><FieldRef Name=\"SortOrder\"/></OrderBy></Query></View>");                                     var clientContext = new SP.ClientContext("https://sharepoint.name/section/OD");       var oList = clientContext.get_web().get_lists().ge...
Read more