A lookup column is a SharePoint list column that retrieves its available values from another list in the SharePoint site.
0
votes
3answers
3k views
How do you connect a Calendar List to a Project Tasks list using Web Part Connections?
I created a Calendar List and a Project Tasks list. Then I added a lookup from the Tasks list to the Calendar list. However, when I try to connect the two with the related field visible on both list ...
0
votes
1answer
257 views
Copy data from Lookup field to Filtered Lookup
I'm migrating a list up a level from the site to the site collection. After migrating the list via list template, I need to move the data from the Lookup to the new Filtered lookup field on the same ...
0
votes
1answer
585 views
How to pre-fill the look-up column in a child list?
How to pre-fill the look-up column in a child list item based on the parent item, from whose form the child is being created?
Is this possible?
0
votes
1answer
516 views
Filtered lookup field
I would like to apply filtering to existing out-of-the-box lookup fields (without InfoPath).
The solution should be limited to GUI only: when Backup/Restoring to a clean farm the filtering would be ...
1
vote
1answer
4k views
How can I pass a Parameter via Query String to populate a lookup field on a New Item Form/DVWP?
I have two lists:
List A: Products
List B: Requirements
I'd like to have a nice Create Requirement page launched from the Product Listing page.
I have a DVWP/Multi-Item View displaying all ...
7
votes
3answers
1k views
Multiple Lookup field , how to return better deliminators using object model?
I have a multiple lookup field, and when I do this:
string myValue = oItem["MyLookupField"];
I get this string back:
[id];#[displayText];#[id];#[displayText]
or a real example:
"5;#C3;#15;#P3"
...
2
votes
2answers
479 views
How do I create custom control or action that works in a list's DataSheet view?
I have created a cascading lookup column field for a list in sharepoint 2010. It's working fine in the Standard view but not in the DataSheet view.
In datasheet view it is showing all the possible ...
0
votes
0answers
123 views
How to retain permissions for a user in Lookup field?
I have column level permission using a custom code. But I am unable to retain permissions for a user in Lookup field! Is there a way to do it?
0
votes
3answers
3k views
Add values to lookupmulti field in c#
I want to add values to a lookupmulti field with c#. the form shows the field correctly but my code just won't work:
SPList list = SPContext.Current.Web.Lists["testlist"];
SPListItem item = ...
0
votes
3answers
5k views
How to implement Cascaded lookup in SP 2010?
In sp 2007, I have used jquery to do the cascade. But now I hear sp 2010 provides cascaded lookup. I have 3 level to drill down (Country > State > City). Is/are there any good instruction on how to ...
0
votes
1answer
546 views
Lookupfields not showing up in customlist sharepoint 2010
I have a custom list on dev-int environment, now I saved it as a template and moved it over to the dev-vm environment and created a list (Listl1) based on the template. Now this list consists of few ...
1
vote
0answers
201 views
Content Organizer rule based on a Lookup Column with more than 20 selectable values
Does anybody have any experience making content organizer rule based on a Lookup column with more than 20 values in the list? (When you have more than 20 values, the view of the Lookup field changes. ...
0
votes
1answer
5k views
Setting the value of a lookupfield(sharepoint dropdown formfield) in sharepoint 2010 list forms
How can i set the value of sharepoint form field dropdown box(lookupfield) in sharepoint list form when the form gets saved (using jquery)
note: the lookupfield (dropdown formfield renders as input if ...
1
vote
0answers
228 views
How to take a value from a single line of text field in one list and set it as a lookup field in another list?
I have SP 2010 and SPD 2010.
I have list A that has a single line of text column named Res ID #. This provides the source for List B as a lookup column. I want to create a WF that will put the info ...
2
votes
2answers
234 views
Assign lookup list item with a quantity?
Parent List has a lookup with multiple promotional items. Once user chooses a promotional item, I want user to be able to add a quantity to that specific item. User should be able to select Multiple ...
1
vote
1answer
98 views
Creating lookups with OOTB Lists in SharePoint 2007
I am developing a solution which has multiple OOTB lists like Links, Contacts, Custom List and Document Library.
And, I have to create a lookup field in four lists which refer to a field in a Custom ...
1
vote
1answer
72 views
NewListItemForm with pre-defined values from selected Entry inside form
i got two lists. One is called 'Projects' the other one 'Reports'. When i insert a new report i got the following fields
Associated Project: <LOOKUP FROM PROJECTS_TITLE>
Current StartDate: ...
1
vote
1answer
196 views
How to link two lists using a multi-valued lookup column?
I have two lists, one contains files, each file has one or more ID(depending on its content). These IDs are lookups to another list. Now, I generate another list on fly, this list has the ID column as ...
1
vote
1answer
3k views
Using an Additional Lookup Column Value in a Calculated Column
I have a lookup column based on another list's description (a 'Category' list) and have ticked the other list's 'Category ID' column to be shown at the same time (I note that this is a manually ...
0
votes
2answers
490 views
Trigger workflow email when item created
We have a list called employee details, which has client name as one of the columns which is of the type lookup (from another list name columns value). So when the users create a new item in the ...
4
votes
1answer
1k views
dropdown box on change event in SharePoint list forms
I am editing an SharePoint list form using SharePoint Designer. I need to have two drop down boxes one with the names of the countries and other with the names of appropriate state. How can I ...
3
votes
1answer
367 views
How can we use multiple fields from an external list in a survey?
We are trying to build a survey, that uses data from an external list.
It works fine for a single field.
But what we would like to do is to bring about 10 fields back from the external system and ...
2
votes
3answers
262 views
How best to handle metadata lookup?
I have a query regarding how I should best handle uploading documents into SharePoint (currently WSS) where the Taxonomy asks for client code for all documents. The problem I have is that we have say ...
3
votes
2answers
3k views
How to get lookup value only via REST (listdata.svc)
I am trying to retrieve a list of items including lookup fields via listdata.svc. My lookup points to a list of companies which has the following fields: Title, Address, Phone.
By default, listdata ...
1
vote
0answers
159 views
My custom form isn't saving lookup fields
I have a list with two content types. I've created two custom forms for creating new items (because one field I don't want until the 'edit' form). One works great. The other one doesn't. What's ...
1
vote
1answer
202 views
Association between a custom list and an external list
I have a very basic question.
I have a Custom List and I'd like to add a lookup column from an External List based on a WCF Service. Is it possible?
E.g. I have employers in a custom list. I'd ...
3
votes
2answers
637 views
Migration tool for specific lists
I am looking for a migration tool that works at the list level, not for a full site or server.
One specific requirement is to be able to migrate lists that are connected via lookups.
For example, if ...
1
vote
1answer
307 views
SharePoint 2010, InfoPath and top-level list lookup
We want to have some lists (Suppliers, Projects, etc) at top-site level which can be reached by all child-sites.
Using InfoPath on child-sites we want to have a lookup field in the lists there so we ...
3
votes
1answer
1k views
Can you have lookup column to rich text field
Can a SharePoint 2010 lookup column point to a multi-line rich text field in another list? From what I'm reading, it can only see single-line text fields in the other list, which limits its use in our ...
0
votes
1answer
705 views
Set lookup field value in infopath form on new Item(List Infopath form)
I have lookup field called project stage, on item created I'd like to set to its default value,(project start). Then this field can only be changed by the Workflow as the project moves to the next ...
3
votes
2answers
2k views
Client OM - setting lookup fails
I'm using client object model to migrate data from some external data source. The problem is that when I set lookup (normal list or user) I get:
Value does not fall within the expected range.
I set ...
0
votes
1answer
254 views
Output of SharePointWebControls:LookupField inside an <a> Tag?
I have a lookupfield which is containing an E-Mail Adress and want to have it inside an Tag.
How is this Possible?
Like:
<a href="mailto:<SharePointWebControls:LookupField ...
1
vote
2answers
632 views
Compare two person columns in a list
I have a list which has a "Person or Group" column called as Reviewer. I want to notify the reviewers whenever he/she is added to the list item.
I created a custom workflow which sends a mail on ...
0
votes
1answer
172 views
lookup field to display content types
Is there a way to add a lookup field column to display all the content types sitting at the site collection level?
1
vote
2answers
385 views
How to show results of one-to-many relationship in search results?
We have a one-to-many relationship between a document library (with 150,000 documents) and a custom list storing additional metadata. We're looking to show the additional metadata from all of the ...
2
votes
3answers
447 views
Department lookup from User Profiles - SharePoint 2007
We have some 30,000 user profiles . We'd like to build a custom list with lookup for Department from a unique list of departments in our User profiles.
Possible?
Was thinking of buildin a new ...
0
votes
1answer
1k views
Pull values from a lookup column using SPServices()
I would like to retrieve values from a lookup column (pull down) using SPServices() and load an array in javascript. This is available only in Newform.aspx. How can I do this?
1
vote
2answers
165 views
Lookup field not updating when the document uploading
I am uploading document programically and passing lookup field value but its not get updated, how to handle this?
using (var site = new SPSite("http://ussecavpdvrwk06/sites/TAS/"))
{
...
1
vote
2answers
1k views
lookup fields and client object model — i'm going bald?
new to the development world, not to sharepoint.
I'm ultimately trying to populate a listbox with items from a multivalue lookup field. If it's a single lookup, no problem. When I make it a multi ...
1
vote
1answer
1k views
SharePoint 2010 difference with lookup columns
I recently upgraded my site from SharePoint 2007 to SharePoint 2010.
The first issue I noticed was that the "lookup" columns in "Display view" showed up as the hyperlink instead of the string.
...
1
vote
1answer
369 views
Lookup fields - not unique values in look field
We have a list, which contains schools with their names and addresses. We have another list, which has lookup field to that list on school name field. Since schools in different cities can have same ...
2
votes
1answer
964 views
Validate a date column against a lookupfields additional column
In a list you can create a lookup column which queries data from an other list, the fun part is that you can add "additional columns" which results in some sort of ghost column which is added to the ...
0
votes
1answer
203 views
Looking for an additional feature - Cross site lookup field
We want to implement the cross site lookup in our environment and decided to use the solution available at http://sp2010filteredlookup.codeplex.com.
Unfortunately, there is a missing feature that ...
1
vote
2answers
64 views
Is there any tool that can convert 2007 text/option field type into Managed Metadata fields
we have a 2007 farm that we are rebuilding in 2010. I want to take advantage of some of the new feature like Managed Metadata and I was wondering if there were any good tools out there that can ...
2
votes
1answer
1k views
Sharepoint - Creating lookup field to list on site collection scope
I've got a big problem with creating Lookup field between two lists which are deployed on site collection scope. I've got this field definition:
<Field ID="{c80e8e3c-7124-4772-a39d-5b69f131d542}"
...
0
votes
1answer
293 views
Item Editor form for list - use a lookup table for dropdown
We have a list on SharePoint 2010 called "Policies". It contains a couple of dropdown boxes which point to custom columns. These columns get their data by going to List Settings > clicking on the ...
1
vote
1answer
267 views
linking a document to another document
our setup for document library as follows. We have bunch of document sets (200 doc sets to be exact) in a document library. Each doc set is for particular vendor. We place contracts in each document ...
0
votes
1answer
167 views
Restrict item in List from modification if used in other Lookup or Cascading Drop-down field
Currently I have three lists.
The 1st list contains a single column.
The 2nd list contains two columns - one of the columns performs a lookup on the 1st list.
The 3rd list contains three columns - ...
1
vote
1answer
430 views
Is it possible to iterate all lists in Sharepoint in search for a given Field?
Is it possible to itterate all Lists in SharePoint to find out which ones use a custom Lookup field?
I have an application which is currently failing because the custom Lookup field was pointing to a ...
0
votes
1answer
629 views
Problem with SPFieldLookupValue in SharePoint 2010
I have an SPListItem object from a list based on a custom content type. Many of the fields in that content type are lookup types that point to other lists. When I get back the SPListItem object for a ...
