A lookup column is a SharePoint list column that retrieves its available values from another list in the SharePoint site.
0
votes
0answers
14 views
Access Linked List - Lookup Column “cannot Update. Database or Object is Read-only.”
I have a SharePoint contact list linked in Access. The list contains a Site Column, which is based on a lookup from a list at an upper-level site in the Site Collection hierarchy. Permissions are set ...
0
votes
1answer
26 views
Numeric field in SP displaying 10 as 10.000000 how do i remove that?
I have a list look up column which fetches values from another list which is number(int), but on loading it takes it as a flaoting number.
for example the value in list firld in 10 but it is taken as ...
0
votes
1answer
11 views
Editing rendering of Lookup Field - XLST
Let's say I have a simple text column named MyCustomName with four fields in it:
REMOVE one
REMOVE two
three
REMOVE four
...and I want them to display like
one
two
three
four
in my list View. In ...
2
votes
1answer
34 views
Self Referencing Related Documents Library Through Lookup Column
I am trying to create a single document library that links to documents in the same library in SharePoint 2010 Server. I've created a multi-value lookup column that references the same library to ...
0
votes
1answer
16 views
Cross site cross database lookup field SP2010
SiteCollection 1 in ContentDB 1 has List 1 with custom lookup field.
This lookup field returns all text fields from any selected list in a site collection specified. Each site collection is in a ...
1
vote
1answer
48 views
How to retrieve documents from list?
I created a simple Custom List in WSS3. I also created a Document Library with an additional column field which is a lookup to the Custom List that I created before. Now when I am on the Custom List ...
0
votes
1answer
19 views
Retrieve reference for list from Lookupfield
I have a sharepoint 2007 and in a document library eventhandler: in ItemUpdating, i would like to be able to retrieve the value by id's from lookupfield. So with other words i have to get the ...
1
vote
1answer
22 views
Include additional fields with Person Site Column
When I create a column of type Lookup, there is a section at the bottom labeled "Add a column to show each of these additional fields:" I want to do this same thing with a Person column.
It seems ...
0
votes
0answers
14 views
Retrieving the SPLookupFieldCollection with particular ID's
The situation is following:
I have this kind of string = 58;#value;#59;#value2;#60;#value3;....
So as you see this is just if i do:
SPFieldLookupValueCollection collection= new ...
0
votes
0answers
12 views
not all columns appearing in edit in datasheet
I have a customized work order view with the following fields:
ID#, Title, Assigned To, Client, Status, Priority, Due Date, +8 other fields
When I got to Edit in Datasheet, the Client field doesn't ...
0
votes
0answers
9 views
Disable lookup item link
I am looking for how to disable a link of lookup field i.e. when a user clicks on lookup item of source list it opens Target list instead of opening source list even though he was selecting an item ...
0
votes
0answers
47 views
SharePoint Online - Use Site Column Lookup Value In Workflow
I am trying to generate a unique ID for items in a document library based on values from other fields. I have several lists located at the root of my site, and have created lookup site columns for ...
1
vote
3answers
172 views
Lookup Field programmatically in FeatureActivated
I've created a lookup field programmatically in the featureactivated method.
This is the code snippet.
public override void FeatureActivated(SPFeatureReceiverProperties properties)
{
using (SPWeb ...
1
vote
2answers
47 views
Lookup field two projects
I've got two Sandbox Solution projects in visual studio that I want to use in SharePoint online. The first project has a list and a lookupfield. The other project has an other list and I want to use ...
0
votes
0answers
40 views
List view group by Lookup field only grouping by string value of Lookup, ignoring ID part
I have custom lookup field of my custom list definition:
<Field Name="MyLink"...Type="Lookup" Mult="FALSE" ShowField="Title"../>
Then I have list view in SharePoint Foundation 2010, created ...
0
votes
1answer
34 views
Default null value to a required Lookup Column
The title pretty well speaks for what I need. I have a lookup column on a list, getting data from a custom existing site column i created.
I need it be null by default so they get an error if they ...
1
vote
1answer
46 views
Filter a parent list by a particular child list item's lookup field value
I have two lists, Activities and Objectives. The Activities list has a multi-value lookup field that references the Objectives list.
I am trying to create a filtered view on the Objectives list that, ...
1
vote
0answers
39 views
Find all lists that look up a Contacts list
I have a Contacts list in my site collection, and it is used in lookup columns by multiple other lists.
Is there an easy way to get all the lists that have a lookup column pointing to the Contacts ...
1
vote
0answers
43 views
Lookup column automatic selection in list form upon adding new item
I have a site page with two related lists, this relation being established via the webpart option "insert related list", and I'm using ID column in my child list as the lookup column.
The child list ...
0
votes
0answers
52 views
Creating Word document with tables from template
I found this blogpost about automatically creating Word documents from a list item using workflows in SP2010.
...
0
votes
1answer
29 views
quick way to access splistitem in different list?
I have 2 lists: listA and listB
listA has 2 fields:
Title (text)
PortalID (text)
listB has 3 fields:
Title (text),
listAField(lookup to listA Title field)
UserID (text)
I have a UserID value ...
0
votes
0answers
19 views
Access additional user information column keyed by “Created By” in SPD workflow
In SharePoint Foundation 2013, I would like to create a SPD list workflow that takes different action based on the value of a custom column in the User Information List (keyed by who created the list ...
0
votes
1answer
22 views
Lookup Field searchbar
I have this lookup field which is coupled to a customlist of artists.
I use this lookup field as a column for another list. So when someone creates
a listitem in this second list he or she can choose ...
0
votes
1answer
38 views
Restricting number of selections on a multiple lookup column
How can I restrict the number of values a user can select from a lookup column? It doesn't seem to have the same column validation settings as some of the other column types.
I only want a user to be ...
0
votes
0answers
34 views
Grouping in lookup multi
I have Lookup field in the list, with multiple choice. On NewForm I have JS code which groups items in 2 listboxes of this field (SelectCandidate and SelectResult).
Problem: I need to group items ...
0
votes
1answer
38 views
List GetRelatedFields() returns field ID that doesn't exists in dependant list
I have got list item exception. [ArgumentException: Invalid Field Name.]
[ArgumentException: Invalid Field Name. {01b89bed-bbe3-4bcb-9b92-c64183ffe135} /Lists/AcceptanceAgreements]
...
0
votes
3answers
490 views
Get value from drop down using jQuery (lookup column)
I feel like this should be an easy one but am having trouble finding the answer here and via Google. Using jQuery, how do I retrieve the currently selected value from a dropdown in an ...
0
votes
0answers
91 views
Filter a CQWP on a Lookup Column
I'm creating a custom page layout that contains a CQWP that I'd like to display documents related to the page. The document library has a lookup column that relates to the page title in the Pages ...
0
votes
1answer
60 views
Possible to lookup a Sharepoint list in Access?
I am trying to make a very large list of records with about 1,000 items or more added monthly, and I was told that it would be better to use an Access table instead of a Sharepoint list for so many ...
0
votes
0answers
124 views
Use JS to add new list item with lookup where multiple items in lookup list have same title
I'm trying to add a new ListItem using the client object model.
Scenario:
List I am adding to has Title, Team (lookup) and Date fields.
The list that contains the teams has Team Name, Department and ...
2
votes
2answers
371 views
access additional lookup fields using JavaScript and CSOM
In visual studio I have added lookup field (SubMenuItemIdRefTitle) to list definition listA that references ListB. I have also added
<ViewFields>
<FieldRef ...
0
votes
1answer
105 views
Adding the other fields in addtional to lookup field in CAML
I have a custom field definition in VS2010 that contains a lookup field (Title). All is well and I can use the Title ref to add items in the SharePoint list UI. in the instance UI, I can also check ...
0
votes
2answers
116 views
How to call a c# method in my XSL File
I have two lists Client and Project, each Client has from 0 to N Project stocked in his SPLookupField where multi values are allowed. And I created a new computed Column in the Client List where it ...
1
vote
0answers
140 views
Calculated columns supporting all column types
I would like to develop a column which will allow the end user to do the calculations based on values of other columns of the same item (SharePoint 2010). I need it to work also with people, look up ...
2
votes
2answers
707 views
Multiple fields to same list in join (CAML)
Current situation:
=============
In my example, I've got 2 custom lists:
Accounts
Addresses
In the "Accounts"-list I've created 2 lookup columns to the "Addresses"-list
Address1
Address2
When ...
1
vote
1answer
72 views
SPQuery on null lookupfield
I have a contact list with a company lookup field and I need to retrieve those without any company associated
so I was thinking can I put it like this:
<Query>
<OrderBy>
...
1
vote
0answers
134 views
user lookup field for external lists
Guys please don't beat me too much, I want to add user lookup field into my external content type to use sharepoint people picker in my external list, the price doesn't stand up. So is it ever ...
0
votes
0answers
26 views
Is there any programmatic way to determine if a list has any relationships to other lists?
If list A has a SPFieldLookup to list B is there any thing in list B's SPList object to show the relationship with list A?
While I can flip through list A's fields and find the relationship to List B ...
0
votes
0answers
22 views
Why Does a People Field Return a String by Default?
I recently "cleaned up" a chunk of code that was using SPFieldLookupValues like:
SPFieldLookupValue lookup = new SPFieldLookUpValue(listItem["Field"].ToString());
int itemID = lookup.LookupId;
string ...
0
votes
1answer
81 views
Can I edit a LOOKUP column?
More concisely: How do I edit a lookup column?
I have a custom list with columns [Name] and [Product] named
'MainList'. I would like a third column [Referral] which shows a name
found in ...
1
vote
0answers
88 views
Filtering LookupMulti by FilterMultiValue SP2010
I can't filter LookupMulti's column using FilterMultiValue. My Url contain this fragment
FilterName=Tags&FilterMultiValue=Flower;Sword
Three is nothing, apart correlation ID. I found in ...
1
vote
1answer
156 views
How to add values from a multi-valued field from a list using SPD's Update an Item Action
I have a workflow that automatically updates the value of a multi-valued field in an item.
This workflow is working as expected. BUT, when that field/column of an item has a value already, the current ...
1
vote
1answer
410 views
How to get users/usergroups from an lookup column from SPField
I have a custom list for example "MyCustomListA"
I have created a custom ListForm template and overide the ListFieldIterator. I have overide the ListFieldIterator and CreateChildControls to implement ...
0
votes
1answer
480 views
Add additional field to lookup field inside schema.xml
I'm following the steps in this article to setup a joined data view webpart joined on a lookup field:
...
1
vote
1answer
263 views
Issue with lookup column in subsite
I add lookup columns with a elements.xml file and like everyone else I had issues with them once deployed, i.e. "Get information from:" was empty for the lookup list. I found ...
0
votes
2answers
59 views
Sorting out lookup values while getting them
I have two lists,
List A [Document Number, Name, Title,...] (document library)
List B [Information Number, Name, Title, Document Number] (simple list)
Now List B is getting all documents from List ...
0
votes
1answer
23 views
Checking if a list is consuming lookup value column or not
I have two lists,
List A [Document Number, Name, Title,...] (document library)
List B [Information Number, Name, Title, Document Number] (simple list)
Now List B is getting all documents from List ...
0
votes
1answer
156 views
Change size of Multilookup field
I have a multi lookup just like this image, with 2 listboxes and Add and Remove buttons:
...
0
votes
0answers
66 views
multiple column lists and lookup controls
I've created a List that has two columns a title (MyTitle) and a value (MyTitle), in my page I have a Lookup SharePoint Web Control that is currently just displaying the title, how can I set the ...
1
vote
1answer
404 views
Updating SharePoint List with Linked Access Database - New List Created Instead of Updating Old List
When you've linked an Access Database to SharePoint lists, how do you make sure that saving the database updates the existing list instead of creating a new one, so that lookup columns pull from the ...
