Rows of items containing columns of information.

learn more… | top users | synonyms (1)

1
vote
1answer
911 views

How can lists be made to support master-detail relationships?

It is often useful to have parent-child data when entering form data. Consider a typical job application. Under Work Experience you will add n number of entries each having a start and end date and ...
13
votes
3answers
19k views

Show custom action in ribbon for only one list

Does anyone knows how to show a custom action in the ribbon for only one list? At this moment I've got multiple custom lists, but my button is added on all of them. I only want to show it on one ...
18
votes
4answers
65k views

Change Title (linked to item with edit menu) to different column

How can I change the column in a SharePoint list that has the link to the item and the link to the item with edit menu eg: Title (linked to item) Title (linked to item with edit menu) I want to have ...
17
votes
6answers
50k views

How to make a filtered lookup field

I have a list of departments. This list will change over time adding new departments and "deactivating" others (because of structural changes). I would like to use this list as a look-up for other ...
48
votes
9answers
31k views

Deleting all the items from a large list in SharePoint

What is the most efficient way to delete all the items of a large list in SharePoint? The code should take Query throttling limits into consideration.
2
votes
3answers
22k views

Hide/Show field on list form based on value from another field

I need to hide field 'B' when the value in field 'A' is NOT equal to 'Other'. This is a custom list form. Is jquery the way to go?
10
votes
4answers
25k views

How to submit data from repeatable table in infopath form to a sharepoint list?

I have a infopath form created from a sharepoint list content type. In this form I need to add a repeatable table to send data to another sharepoint list. So when people submit this form the original ...
18
votes
2answers
12k views

SPList.Add() vs SPList.AddItem() SharePoint 2010

Using some test code i found out that SPList.AddItem() executes slight faster then SPList.Add() - does anyone know why is it so ? DateTime start = DateTime.Now; SPList ...
1
vote
3answers
231 views

Calculate the average value of an array from sharepoint listitem

So I'm getting my listItems with a Camlquery, but i want to calculate the avg of the "price" rows This is the code I've used so far: function VisaLista() { namn = ...
5
votes
2answers
16k views

Using Default List Forms for Edit & View

Is it possible to configure a SharePoint 2010 list to the default form for editing and viewing while displaying my custom InfoPath form only for new items?
9
votes
9answers
56k views

Update Sharepoint list using excel

I have a SharePoint that has list and I need to be able to update this list with new values from an Excel sheet (using VBA). This can be done from Access not a problem however I need it to be Excel ...
4
votes
6answers
34k views

Is setting permissions on views now possible?

In the previous SharePoint version of SharePoint you couldn't have permissions on list views. Is this now possible on SharePoint Foundation 2010? So for example I have a list and 2 views but I want ...
5
votes
3answers
34k views

SharePoint 2013: “Find an Item” search box does not return results

We have 2 web applications, in one of the web application search is working properly and we are able to see search results from "Find an Item" box above the list name. However in the other web ...
2
votes
2answers
6k views

Dropdown lookup column in Sharepoint list form (newform.aspx)

I have a dropdown lookup field in newform.aspx form. Unlike choice dropdown the lookup dropdown is input field and not select So I raise an onchange event using jWuery $(document).ready(function() { ...
3
votes
6answers
16k views

List 'add new item' link at top of list

The 'add new item' link which is always located at the end of the list. Is there a way that we can add a similar link at the top of the list?
1
vote
1answer
499 views

SessionStorage caching when getting items from a list

SP.SOD.executeFunc('sp.js', 'SP.ClientContext', sharePointReady); var listTitle = []; var listUrl = []; var listIsActive = []; var listOrder = []; function sharePointReady(){ var siteUrl = mysite; ...
6
votes
2answers
7k views

All versions of one item in list

Is it possible to see all versions for one item in SP list a different way than through version history? We have one extensively used list with 100, 130, 150... with a lot of (multi-line and rich ...
2
votes
1answer
6k views

How to Sort “Change View” List Drop-down

On a list item, on the Browse tab, you have the drop-down to select a view. My issue is, this list is ordered by the view's creation time. I would like it to be alphabetically. If you looks at ...
2
votes
2answers
492 views

Possible to specify the GUID when adding a List to a SPListCollection?

I found this documentation which goes over how to add a list, but it doesn't seem possible to specify a GUID if you use this method. Is there any way to create a list and specify the GUID? I am ...
0
votes
3answers
117 views

Issue with calculated column

I have a calculated column CRM ID with simple formula =CONCATENATE("CRM")&ID. The formula concatenates ID field with string CRM. The issue is: Sometimes when user update list records, the CRM ID ...
0
votes
2answers
873 views

Not all views being displayed in my web part

Issue: Not all views being displayed in my web part. When selecting a view in my web part it only shows 30 views. How do I get it to show all views created for a list if there is more then 30?
11
votes
5answers
45k views

Sharepoint Lists vs. Sharepoint Libraries

Fundamentally, what is the difference between the two? I'm in the really early stages of working out what's what with sharepoint and I can't seem to tell the difference between the two.
9
votes
1answer
12k views

PowerShell - create list from list template in list template gallery

Using PowerShell on a SharePoint 2010 site, how can you create a new list from a list template found in the list template gallery?. I want to be able to add several lists at once (just in numerically ...
4
votes
3answers
29k views

Create Custom New Edit and Display form for sharepoint list

I am new to SharePoint and I have created several custom lists. I would like to use visual studio 2010 to create new EDIT/NEW/DISPLAY forms for this list. I can't seem to find anything on the internet ...
5
votes
2answers
7k views

Filter People and Group column using [Me]

Our list has a people and group column (called Users) which we want to filter using [Me]. It works when the field only contains individual users, but when the field contains a group (either SP group ...
5
votes
4answers
21k views

Display List or Library on another site as WebPart?

I want to display my list on another site in same site collection. I edit List with SPDesigner, select the view and save it to site gallery. After these steps, I added the view webpart on my another ...
4
votes
2answers
2k views

CAML: Possible to query non existing field?

I'm using SPSiteDataQuery to fetch list contents from 2 different lists. List A) has the fields CustomField and Title List B) has only Title Is it possible to build a (filter) query with ...
4
votes
2answers
5k views

sharepoint 2010 Retention Policy not working?

I have created one simple document library and want to enable a retention policy for that, for this thing I have created one document library and have navigated to following steps: 1) Document ...
3
votes
3answers
33k views

Import Sharepoint List into Excel Using VBA Only

In Excel 2007, I have a VBA script that consolidates various data sources into a single Excel file for monthly archiving and reporting purposes. How can I import data directly from a Sharepoint ...
1
vote
2answers
659 views

Create security field

How can I implement security field for SharePoint list? For example, the list should have field that contains salary. This field should be displayed for the Managers, but should not be displayed ...
11
votes
3answers
11k views

ListInstance with predefined data, prevent adding records to list with same name on deployment

I have a feature which on activation has to create a list called Scanners. Only one column from the list (Title) is actually used in my app. The list needs to be pre-populated with some values. To ...
7
votes
3answers
12k views

Best method to create custom NewForm / EditForm

I am new to sharepoint development and need to create some custom NewForm/EditForms for a new custom list I am creating. It seems like I have two choices: ...
7
votes
6answers
7k views

SharePoint List Item Permissions

Does anyone know of a way to implement permissions within a SharePoint list so that items are only visible to the person who created it (or potentially who the list item is "assigned to", as in like a ...
3
votes
4answers
6k views

Possible to save a list template and maintain lookup relationships?

My issue is that I have two lists that I would like to move with their data. While I am able to save both as templates and then upload to the new site, none of the lookup columns in my parent table ...
2
votes
3answers
1k views

Disable List Event Handler in the Client Object Model

I have a client windows application that is uploading many rows of data to a list. However, I don't want the event handler on the list to fire while rows are being added via the windows application. ...
2
votes
4answers
2k views

How can I Make a Dropdown box in a Form Field Conditionally Read-only/locked?

I have a drop down box form field (with values level1,level2) in SharePoint list. How can I lock the drop down box selection in the edit form.aspx whenever the condition is level2?
1
vote
2answers
5k views

Retrieving a lookup Value from a List using jquery and REST

I would like to get the lookup Value from a List item depending on it's Title. My List is set up similar to the following example: ColumnA : a | b | c lookupB : 1 | 1 | 2 The jquery: function ...
1
vote
4answers
4k views

Can you restrict a list to add item only but not read?

Is it possible to create a list where you can add items to a list but not view items in a list?
5
votes
2answers
6k views

SharePoint Lists' EditForm & DispForm

I haven't been able to find any information regarding this, so I hope you guys can help me out on this. Since all lists in SharePoint all have an EditForm.aspx and a DispForm.aspx I am wondering if ...
4
votes
1answer
3k views

Export to Spreadsheet option missing from Actions in SharePoint 2013

I am unable to export a SharePoint List (Survey) to a spreadsheet. The option "Export to Spreadsheet" is missing from the Actions dropdown menu for the list. I've done lots and lots of searching for ...
4
votes
4answers
5k views

Blog - how to avoid List Tools in ribbon when clicking on text

I have created a custom blog with the publishing feature enabled. When I am logged on with a normal user (with no admin rights) and click on a text or an image, "List Tools" appeares in the ribbon, ...
3
votes
1answer
3k views

Event Reciever run with elevated previledges

I created one event receiver and deployed it, but only users who are site collection admins are able to view this web part. I have included the SPSecurity.RunWithElevatedPrivileges but the same thing. ...
3
votes
4answers
9k views

Error - while exporting a Sharepoint List (Export to Excel)

Colleague of mine is facing the below issue while trying to export the SharePoint List which has more than 10 000 items. However I was able to export the complete List without any issues. Note: He is ...
3
votes
7answers
7k views

ArgumentException when trying to access SPListItem value

I have a tool to update all items in SP (link replacement). The tool works most of the time but sometimes it throws me an ArgumentException ("Value does not fall within the expected range."). Here is ...
2
votes
3answers
2k views

How to authenticate BDC to the external system?

I'm using the following tutorial to define a workflow on a SharePoint list to create an element in and external List. When the workflow action tries to create the item in the external list, it fails ...
2
votes
1answer
3k views

Which view is the “Current view”?

I have got a SharePoint 2010 website with a WebPart-page and a few WebParts on it. One of the WebParts displays a list/a view of a list. The views of that list have been updated due to business ...
1
vote
2answers
34 views

Column Type for User Fields

Can you change the default column type from Single line of text to Person or group on the User Fields in List Settings?
1
vote
3answers
7k views

How do I handle the large List with more than 5K items in SharePoint 2010?

Have developed a simple request tracking application on SharePoint 2010; it stores the info on the SharePoint List. I would expect ~100items / week getting stored on the root folder of the list(as ...
1
vote
1answer
4k views

How to get approval status of a list item as a column to that list?

I have a Calendar list and an approval workflow. The workflow is initiated when a new item is added. The event gets approved in the task list. I want to get that "Outcome" column to the list. But when ...
1
vote
3answers
6k views

IMporting all Contacts from OUtlook Public Folder into Sharepoint list?

What is the best way to import all contacts from outlook public folder to a sharepoint contacts list? We have about 3000 contacts and I understand going over 2000 items in a list hits performance. ...