Adding a simple Chat Facility to a Sharepoint Foundation 2013 Site

I've recently been working on a Sharepoint Project where the client requires their receptionist to be able to send them messages without flooding their email. So they asked for some kind of chat or instant messaging facility. I stumbled across Simple Chat a basic, lightweight JQuery based script which does the job very well.

Implementing the script is really easy. Here's the short version:

• Create a Document Library to store your JavaScript files.
• Create a Custom List to display your messages
• Add a Script Editor Web Part to where you want to keep your Chat facility. Edit Snippet, add JQuery code etc.

Job done.

Restore Content Types in Sharepoint Foundation 2013

If you find yourself in the situation where you've messed up with the Content Types in a Sharepoint Site Collection then this will help restore everything back to the default settings:

Open - Start - All Programs - Microsoft Sharepoint Products - Sharepoint Management Shell and run this:

stsadm -o deactivatefeature -name Fields -url http://sitecoll -force
stsadm -o activatefeature -name Fields -url http://sitecoll -force

Source: http://sharepoint.stackexchange.com/questions/8517/site-content-types-screwed-up-how-to-restore-to-default/26225#26225?newreg=0c4f241b46ab466ea0d265069efdca5f

Sharepoint Notes - Calculated Fields - Displaying HTML in Calculated Fiels, Displaying Status Indicator Icons, Display Week Number, Calculate Overdue Status

Display HTML in a Calculated Column

Make sure you select Number rather than single line of text for the format of your calculated column.

Use Calculated Column to Display if a Task is Overdue

This formula displays True or False: =AND([Due Date]<NOW(),Status<>"Completed",[Due Date]<>"") To make your Overdue column display a KPI Icon you can do this: ="<div><img src='/_layouts/images/KPIDefault-"&IF(AND([Due Date]<NOW(),[Task Status]<>"Completed",[Due Date]<>"")=FALSE,0,2)&".gif'/></div>"

Display KPI Icon for Yes / No column

This formula worked for me: ="<div><img src='/_layouts/images/KPIDefault-"&IF(Approved=TRUE,0,2)&".gif'/></div>"

Display Week Number in Calculated Column

This formula worked for me: =INT(([Due Date]-DATE(YEAR([Due Date]),1,1)+7-WEEKDAY([Due Date],1))/7)+1

Resources

Here's a list of resources I used to get to grips with this stuff. Some of them I've ended up referring back to several times.

• Week Numbers in Calendar
• Color Coding: More Examples
• Using calculated columns to add color coding to your SharePoint lists
• Using calculated columns to write HTML
• SharePoint Calculated Column Formulas
• Sharepoint converting a date to a week number
• Week Number – One Approach
• ISO8601:2000 Standard Week Number calculation
• Calculating Europen week number in SharePoint (ISO 8601)
• Conditional Color Coded List
• Colour coding a SharePoint 2013 list with jQuery
• Look Up A List of Week Numbers
• Modifying calculated column formulas based on values selected in other metadata fields
• SharePoint 2010 Icons
• HTML in SharePoint Calculated Fields (display a link)
• Week Number – One Approach

Sharepoint Notes

Week Numbers in Calendar Color Coding: More Examples Using calculated columns to add color coding to your SharePoint lists Using calculated columns to write HTML SharePoint Calculated Column Formulas Sharepoint converting a date to a week number