The following is a re-post from Bryon Wyly’s blog Codeless Solutions for Sharepoint originally posted 11/21/2009.
Right now I am in Birmingham Alabama getting ready to give a couple of presentaions at the SharePoint Saturday here. I have uploaded the outline to how to Jazz up your sharepoint pages with no more skill than copy and pasting.
Three items are already covered in my blog; Pie charts, SharePointCanvas.com, and Hiding/Displaying web parts. The other three are from other authors and I have provided links directly to their sites. Please let me know if you are author on any of these sites and the links or credit due is not to your liking.
* note: I updated the Progress bar text to the code I use on my site, since the linked text did not work during the presentation.
1. Making unwanted items disappear:
- Go to http://www.sharepointcanvas.com
- Uncheck the elements you don’t want. Click on the camera item to see where they are.
- Click Create CSS
- Copy/paste the code into a content editor web part in your page
- Hide the content editor web part in layouts
2. Showing a Progress Bar in your Task List:
- Create a new calculated column in your task list.
- In the formula copy and paste the following:
- =”<DIV style=’background-color:blue; width:”&([% Complete]*100)&”%;’> </DIV>”
- Copy and paste the code at
- http://www.sharepointcanvas.com/spc/docs/text2HTML.txt
- into a content editor web part
- Hide the content editor web part in layouts.
3. Highlighting text in a List:
- Go to: http://techtrainingnotes.blogspot.com/2008/11/sharepoint-color-coding-sharepoint.html
- Copy and paste the script into a content editor web part
- Change the text conditions to what you want, i.e:
if (x[i].innerHTML=="Not Started") //find the data to use to determine the color
{ x[i].parentNode.style.backgroundColor='white'; // set the color }
This part says if the table cell contains “Not Startedâ€, highlight the entire row white.
You can change the text and colors
Taking out parentNode ie x[i].style.backgroundColor=’white’; allows you to highlight only the row
x[i].style.color=’red’ – will change the font color to red
4. Showing a “Mini†Calendar:
- The out of the box calendar view is huge and can’t be resized.
- Go to: http://pathtosharepoint.wordpress.com/2008/10/06/tiny-sharepoint-calendar-1/
- Copy and paste the styles into a content editor web part
- Note there are other styles created by this author
5. Making a Dashboard Pie Chart:
- Pick a list to use, group by the column you want to use
- Go to: http://wyly.wordpress.com/category/sharepoint-dashboard/graphs-pie-charts/ (percent) or http://www.endusersharepoint.com/2009/04/20/finally-dynamic-charting-in-wss-no-code-required/ (count)
- Copy and paste the code in a content editor web part
- Hide the list if you wish, the chart still works. (optional)
- Click here to see how to add multiple pie charts on one page:
- http://wyly.wordpress.com/2009/04/24/adding-graphs-bar-and-pie-charts-to-sharepoint/
WARNING: This uses google API’s that means the data on your page is sent to google to be processed. Don’t do this with confidential data!
6. Hide/Show Web Parts:
- Add all the web parts or views of web parts you would like to use. Give them all a common keyword in the title ie “department†or “task†(Capitalization Matters!)
- Go to: http://wyly.wordpress.com/2009/05/22/showhide-multiple-web-parts/
- Copy and paste the code into a content editor web part
- Set the keyword to the common title element from the first step
- Pick if you want the first web part to show up when the page is loaded and if you want a menu or a drop down box
- Hide the content editor web part
Bonus: Creating a Master Calendar or Library
First Created by Mike Smith at http://techtrainingnotes.blogspot.com/2009/03/sharepoint-one-library-multiple-sites.html
- Create a calendar (works on document libraries too)
- Add the calendar as a web part to the page
- Open up the page the calendar web part is on
- Find the string <ExportControlledProperties>false</ExportControlledProperties> – Change from false to true
- Export the web part somewhere you can find it – ie your desktop
- Find the GUID of you web site, use one of the methods on Mike’s site
http://techtrainingnotes.blogspot.com/2009/03/sharepoint-finding-sharepoint-guids.html - Open up the DWP site with your favorite text editor find <WebId ….> guid_here </WebId> and replace guid_here with you guid ID
- Upload the web part to your site collection web part gallery (Top site – site action – modify all site settings – Under galleries)
- Now when you go to any site in your site collection and go to add a web part, the web part you uploaded will be available. It will show the data from your list no matter what site you are in!