Lookup with Picker Data Type for a SharePoint List

While researching the issue I mentioned in my previous post, I ran across this neat thing at CodePlex: http://www.codeplex.com/lookupwithpicker/Wiki/View.aspx.  Here’s the brief description: Microsoft Sharepoint Server 2007 lookup control with element picker for custom list.This control is useful if you need to choose lookup data from large lists. This control supports single and multi select…

string;# Before Values in a SharePoint List’s Lookup Column Based on a Calculated Value

I’ve seen lots of posts discussing this, but no workarounds.  Here’s the situation: One list (List 1) contains a list of values that are calculated (say ColumnC = ColumnA & ColumnB) Another list (List 2) uses ColumnC above as a lookup for one of its columns If you go into Datasheet view for List 2,…

Counting Subsets of Items in a Data View Web Part (DVWP)

I’ve posted about this application before. It helps my client manage their inventory of sports tickets which they can use with their clients and vendors.  They have a regulatory reporting requirement to maintain information about who uses the tickets and what their relationship is. In this case, we wanted to be able to count the…

Interesting Article on SharePoint at Computerworld

There’s an interesting article on SharePoint over at the Computerworld Web site:SharePoint challenges IT as the Excel, Access of the day. The most interesting part to me is the is the unflattering comparison between the evolution of SharePoint and Lotus Notes usage in the enterprise: "Departmental users used those tools to build applications that collect…