Tag Archive: Lookup Column

Jul 08 2011

Updating a Lookup Column Using SharePoint’s Lists Web Service

Updating a Lookup Column Using SharePoint's Lists Web Service

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. …

Continue reading »

Permanent link to this article: http://sympmarc.com/2011/07/08/updating-a-lookup-column-using-sharepoints-lists-web-service/

Oct 09 2009

SharePoint Lookup Column Based on a Calculated Column Woes

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 …

Continue reading »

Permanent link to this article: http://sympmarc.com/2009/10/09/sharepoint-lookup-column-based-on-a-calculated-column-woes/

Jun 11 2009

Displaying a Multi-Select Column "Nicely"

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 …

Continue reading »

Permanent link to this article: http://sympmarc.com/2009/06/11/displaying-a-multi-select-column-nicely/

Jan 25 2009

Recursive XSL Templates in DVWPs

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 …

Continue reading »

Permanent link to this article: http://sympmarc.com/2009/01/25/recursive-xsl-templates-in-dvwps/

Aug 13 2008

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, …

Continue reading »

Permanent link to this article: http://sympmarc.com/2008/08/13/string-before-values-in-a-sharepoint-lists-lookup-column-based-on-a-calculated-value/