Tagged Questions
2
votes
1answer
32 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
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
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
1answer
104 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 ...
1
vote
0answers
139 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
675 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 ...
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
1answer
152 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 ...
0
votes
1answer
442 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:
...
0
votes
2answers
184 views
Calculated Formula Insert From Another List
I have List A which has all information.
List B has Col 1 that looks up one of the List A's columns. Col 2 is a Calculated column that want to use Col 1 but SharePoint is not able to see Col 1 ...
1
vote
2answers
209 views
Matching value from single line of text column to lookup column
I have a library containing a large amount of items.
The library contains a column of type 'Single line of text' with a code in it. The code was taken from an external system and entered manually.
...
2
votes
2answers
372 views
SharePoint 2010 NewForm.aspx Lookup Fields Issue
I have a SharePoint 2010 Foundation site that has recently been upgraded from WSS 3.0. The upgrade was completed successfully with no glitches.
However, ever since I have upgraded the site I have ...
2
votes
1answer
133 views
Use count-related column value as int in a SP Designer-workflow
I have another problem concerning the count-related column-value of SP2010 in a workflow(see also: How to get count related Lookup value programmatically? ).
my use-case: I have a column "actual ...
0
votes
2answers
155 views
Accessing LookupFieldValue throws error
I have a lookup field on a list (header) that looks up values on the same list. I am trying to read the value out of that lookup with this code:
using (SPSite site = new SPSite (mySite.ID))
{
...
0
votes
1answer
458 views
How to get count related Lookup value programmatically?
Another day, another question ;)
So, I have two custom Lists, "Attendees" and "Events". In the Events-List there's a Lookupfield "Registrations" which I want to fill programmatically on page_load. In ...
0
votes
2answers
230 views
How to add a from lookup field value to the text
I think about how to add a from lookup value to the text ? How can I write it to another colum ? In the same list.
1
vote
2answers
55 views
Library item “referencing” other content
Sorry for the nondescript title, it's a little hard to explain concisely.
We are setting up SharePoint 2010 to act as a simple document management system, to store documents such as forms, ...
0
votes
2answers
94 views
Lookup between lists with additional data
I have two entities, Toolbox and Tool, where Toolbox contains a set of tools (hammer, saw, screwdriver).
The trick is that there can be several hammers in the same toolbox, so I need an amount, or ...
0
votes
1answer
59 views
Pro grammatically adding choice field with another field relation
sorry about the title am not sure how i should name it.
I want to be able to create two columns for a list that have a division - subdivision relation.
If in the first field if i choose People the ...
0
votes
1answer
102 views
Multiple LookupField?
I have a couple of problems that i would need help with.
I need to create a list that has a lookup to multiple lists. Is there a way to do this without including third party.
I have a site, with a ...
1
vote
1answer
445 views
content query web part with multi value lookup column
I am trying to work out how I can query a content type with a multi value lookup field using the content query web part.
I know that natively this is not possible with ootb sharepoint 2010 however I ...
1
vote
1answer
659 views
Conditional Sum of Data in Another List
I have two lists 'Projects' and 'Tasks' where 'Tasks' are associated with 'Projects' with a lookup column.
On the Projects list I would like to display the sum of all of the 'Actual Time' values (a ...
2
votes
2answers
201 views
Lookup List and return data from within a Form
OK, I'm beginning to despair at SharePoint...please help restore some faith :)
Seems some very basic things are very hard to achieve?
1:
I have data in an SQL database table. 78,000 rows, but I want ...
1
vote
0answers
298 views
How do I create a lookup field for a hyperlink field and display the URL?
Ok, so there are a zillion posts related to and circling around this question, but that do not actually answer it to my satisfaction.
I have a regular, out of the box, list of type "Links". I have ...
0
votes
1answer
352 views
Is it possible in LINQ to SharePoint
I have a task to make a WSP, which should provide definitions of custom list and library, but not instances. List definition has a lookup column to library item
<Field ...
1
vote
2answers
455 views
Add lookup field to list from a RootWeb
I have the site collection rootweb called Main Site. I have many subsites called according to the year, 2012, 2011, etc. In the rootweb, there is a list called Products. In the subsites there is a ...
0
votes
2answers
425 views
Lookup field on custom form does not save once deployed on testing
I have a custom form on a content type I've created. This content type has 3 site columns which are a lookup field from 3 lists.
In the form I've created the user selects a dropdown box and chooses an ...
0
votes
2answers
750 views
Multi select Lookup column returns null in javascript client object mode;
I am trying to retrieve the selected values of multi select lookup column and store them in array and then set the lookup column with the same selected values after drop down value changes but always ...
1
vote
0answers
68 views
Lookup columns into document template
I've a DocLib with the lookup field Field01 and I want to display the associated lookup columns as Field01:FieldA, Field01:FieldB...
I already have them on the view, now I want the exact same ...
1
vote
2answers
1k views
Modify existing lookup type column to managed metadata type
We are in process of migrating one of our big website which is built in WSS 3.0 to SharePoint 2010 Standard version.
In the process we want to convert all lookup columns to managed metadata type. We ...
2
votes
1answer
353 views
REST API Filter by multilookup property
Having an Activities list with a column called Engineer of type lookup that allow multiple values. How to build a call to listdata.svc in order to get only activities that are asigned to an Engineer ...
0
votes
1answer
735 views
SPLookUpField and Adding Values
I am creating a custom list programmatically. List has one Lookup field. Here is my code sample how I am creating LookUp field.
oList.Fields.AddLookup("Parent", oListGuid, false);
...
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?
1
vote
0answers
226 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
1answer
484 views
How to create a lookup field that has a list column picker
How would I be able to create a list field in VS that would be a lookup to select columns from any list?
I would preferably like to have something like the PickerTreeView.aspx, but instead of ...
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 ...
1
vote
0answers
158 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
940 views
Get related items from a parent list item through lookup
I've got 2 lists: Companies and Employees. In Companies I have a text field called Name and in Employees I have a lookup to Companies based on the company Name.
What I'm trying to achieve is to get ...
1
vote
0answers
947 views
Inserting new item in list with EntityRef field to User Information List using Linq to SharePoint
I have a list with SPFieldUser field type in it. I try to insert new item in this list using Linq 2 SP.
So, I generated data context class using the following configuration file:
<List Name="User ...
3
votes
2answers
493 views
Deactivate the link of lookup-fields! (2010)
On our solution (SP Foundation) we multiple lists with quite some lookup fields. Some of the lookup fields are user fields who link to the user info list, and we don't want that to happen.
Of ...
0
votes
1answer
49 views
How to test lookup?
When creating a workflow, is there any way to test the look up values? For instance, I have a 4-level look up which finds the manager of a user who is entered on the form. I'd like to be able to see ...
3
votes
3answers
811 views
Export Import Library with Lookup column
I did export operation of custom library in Central Administration. Library has some custom fields and Lookup field on existing library on the site.
After exporting main library and all dependecie ...
