A great way to manage the values for a Site Column in SharePoint is to put the values into a list and then use the Lookup column type to grab the values. When you allow multiple selections in the lookup column, what is stored looks something like this: value1;value2;value3;value4 If you would like to then…
Lookup columns in SharePoint can be very useful as a way to standardize input values. One of the drawbacks of Lookup columns is that they violate the Rules of Data Normalization (see my previous post entitled “SharePoint Is Not a Database”). Specifically, by storing the text value of the lookup rather than the ID, we…
Andy Lewis over at the Microsoft SharePoint Designer Team Blog has a nice post about how to do Filtering and Formatting with Date Values. The best part of the post (it is FULL of useful information) is a set of utility templates that do some useful calculations on dates: getDateFromDays Outputs the date that is…
I posted back in February about using the Data View Web Part to do cross list rollups (See Rolling Up Content in SharePoint Using the Data View Web Part (DVWP)). Since then, I’ve done quite a few of these, and I’ve been meaning for some time to post this update. Not everything that I believed…
Oftentimes you’d like to mimic the out of the box display capabilities of SharePoint when you create a view using a DVWP (Data View Web Part or Data Form Web Part). One of the things you might like to do is to show the document type icon for the documents in your view. These are…