I’m a huge fan of Lookup columns in SharePoint. Choice columns just don’t give me enough oomph, and Managed Metadata Columns give me plenty of oomph, but not all that I need. With Lookup columns, I can lookup into the Title of a reference list, but also store additional information in that list which is…
The SPServices discussions are a fount of interesting information. I find myself answering all sorts of questions which, while connected to SPServices, are often just as much about how SharePoint works in general. I had two questions recently about how to update Lookup columns with UpdateListItems, and I thought they would be of general interest….
I’ve been working on trying to improve the performance of some DVWPs I wrote about a year ago as part of an application that I inherrited from others. (Was that tactful enough?) One of the things that I’ve been trying to do is to filter on the LookupId of a Lookup column, but I couldn’t…
UPDATE 2010-08-26: I’ve added this template to the SPXSLT project on Codeplex. There’s a bit more explanation there. UPDATE 2010-04-27: Shalin Parmar pointed out in a comment below that I had a bug in the template where the separator would only be displayed between the first and second values. I’ve made a change to the template to…
I’ve written quite a few recursive XSL templates recently, so I thought I’d do a post explaining what they are and how useful they can be. On my current project, we’re using many Lookup Columns in Content Types which are based on items in Custom Lists. These Lookup Columns also are almost all multi-select, meaning that…
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,…