Author: Marijn

Set a SharePoint people field with jQuery

When I talked about how to update fields in SharePoint, I was talking about the easy stuff: input fields and stuff. Now, I wanted to update / set a SharePoint people field on my form. I did some googling and found a solution by Marc D. Anderson (in my opinion he is THE authority on sharepoint …


How to format numbers with commas in SharePoint Dataview (using decimal-format functionality)

In a dashboard project we had to display certain valuta fields that came from a SQL-SERVER table.Those fields had following formatting: 139367709,8800 0,00000,00 51345998,3700 The goal was to display them as European style valuta: 139.367.709,88 0,00 51.345.998,37 To format those numbers to numbers with commas in SharePoint Dataview I used the xslt format-number() function Result was empty …


Loading dates via SharePoint Designer Datasource creates problems with daylight savings time

At a dashboard project I was using the SharePoint Designer DataSource functionality, getting data from a SQL-Server (more on why in this blogpost). I was having a funny issue however: all dates I got from SQL-SERVER had 1 hour off. When I had the date “15/10/2011” in SQL, I would have “14/10/2011 23:00:00Z”. Sidenote: in …


Remove original message from a SharePoint discussion forum reply via jquery

Someone on the MSDN forum asked how to remove the original message when replying to a thread.
That smelled like a jquery job to me!!Here is the code.


Set the width of multiple lookup fields in SharePoint via jQuery

Hide the SharePoint 2010 Search box via CSS

Every page in SharePoint has a search box on the right upper side. If you want to hide the SharePoint Search box on one page, add a Content editor webpart with following CSS.


Get the value of a SharePoint People Picker field via javascript

The ever handsome and cunning Marc D. Anderson (I felt like giving the man credit, since I use so many of his solutions!!) saved my behind once again with a fantastic javascript!
This time I was looking to find a solution to get the value from a people picker field via jquery.


Why I stopped using BCS and started loving SharePoint Designer DataSource

In Standard Edition SharePoint, you don’t have the BCS Webparts, so you cannot use parameters to query the exact item you need. I only found a way to get the item via a load of all items, and then a filter of those items.
That is when I discovered the Datasources in SharePoint Designer


Enable “Append changes” on multiline textfield in SharePoint 2010

In the default SharePoint “Issue Tracking” list you have the “Comments” field. Every time you add text to it and save the item, it is stored and the current text is added to the previous. You can get the same behavior an ony other multiline textfield in SharePoint 2010 you create. When you create the field, check …


Hit Shift-Enter in a SharePoint multiline text-field to insert a new line instead of two

At my customer, we created a solution where users can fill in some comments in a SharePoint multiline text-field. Unfortunately, every time they entered some lines, they appeared a little bit too far from each other. Looking at the code, SharePoint adds a “p” or double “div”’s around the line. After some testing, the simple …