Inject your custom javascript on every page with the help of a sandbox solution

The Google Analytics SharePoint 2013 / Office 365 project on CodePlex offers a sandbox solution that makes it possible to inject your custom javascript on every page.
In this way you are able to call your own CSS and javascripts for custom branding of your site.

Search schema: RefinableString +100

I've noticed lately that in the Search schema of my SharePoint Online tenant the number of available managed properties of RefinableString has increased with 100. The total number is now 200. That's good news since making custom columns available in the refinement panel is an every day business.

 

Column validation formula for time value only input in a single line of text field.

Here is a Column validation formula for time value only input in a single line of text field:
=TIMEVALUE(TimeText)<>TEXT(TimeText;"hh:mm")

Custom e-mail notification without SharePoint Designer: Three-state workflow

Someone asked me whether it is possible to send an e-mail notification with custom text after a request form (list item) is submitted to a list. These requests are personal so alerts are not an option. Of course it's easy to create a custom workflow with SharePoint Designer but what if you won't / can't use this tool? Well, the good old three-state workflow is your friend here! So how does this work?

1. Create a Tasks list called "Request status"


2. Change the Tasks list settings to secure the personal data


3. Create a custom list called "Requests" to be able to fill out a request form
4. Add a column of the type Choice with the name "Request status" and the following choices: "Submitted", "Being processed", "Completed". Default value is set to "Submitted".

5. Be sure that the Three-state workflow feature is activated at site collection level.
6. Add a standard workflow to the list Requests: select the Three-state workflow template.

7. Configure the workflow settings

8. Test

9. Results

It's an amazing discovery!

Notice:
Since it's a three-state workflow it will only be completed when the choice field is set to the last state, in this case "Completed". Else the workflow will stay In progress.

TIP: Tenth edition of the free DIWUG SharePoint eMagazine

DIWUG SharePoint e-Magazine #10

Download the 10th edition of the DIWUG SharePoint eMagazine now! This one has more great articles from renowned SharePoint specialists, speakers, trainers, former SharePoint product group employees and MCMs!
In this edition:

• Custom Forms in SharePoint 2013 Workflows with Visual Studio 2012 - Andrew Connell
• Pimp your SharePoint search results - Stefan Strube
• SharePoint, Yammer and the social landscape - Chris Johnson
• Protecting SharePoint 2013 with DPM 2012 - Sam Hassani
• Strategic Thinking and SharePoint - Jaap Zwart
• Custom Display Templates for the Content Search Web Part - Martin Hatch
• Optimizing SQL Server 2012 for SharePoint 2013 - Brian Alderman
• Enterprise Social Case Management, where Workflow and User Engagement meet - Marc Vanderheyden

The DIWUG SharePoint eMagazine is a free downloadable magazine with articles written by MCMs, MVPs and other authors from the SharePoint community. The target audiences are IT-pros, developers and end (power) users.