Rows of items containing columns of information.
13
votes
3answers
5k 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.
7
votes
4answers
8k 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 ...
9
votes
2answers
6k 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 ...
4
votes
5answers
10k 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 ...
3
votes
2answers
3k 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?
2
votes
1answer
3k views
Dropdown lookupcoloumn in sharepoint list form (newform.aspx)2010
I have a dropdown lookupfield in newform.aspx sharepoint form...unlike choice dropdown the lookupdropdown is 'input' field and not 'select'..
so i raise an onchange event using jquery
...
3
votes
6answers
4k 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
2answers
279 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 ...
4
votes
3answers
4k 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:
...
3
votes
4answers
15k 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 ...
2
votes
4answers
1k 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
3answers
1k 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. ...
1
vote
2answers
151 views
List Security in Sharepoint
I need to set permissions for a list that looks like this:
I have two different teams, each with a team lead and 3 team members. The team members should not see each others data.
Team leaders have ...
0
votes
3answers
438 views
How can I set a field value in a display form when a list item is first read?
I have a list with multiple columns.
This list may include multiple records. I want the value of a specific field to be changed when a special record is read for the first time.
9
votes
5answers
4k views
Which is the easiest way to migrate entire List to a new new site?
Hi
I need to migrate a list with 800+ items to a new location but within the same site collection. Which is the easiest way to do it. I want it to be a exactly same with all data, attachements etc ...
8
votes
2answers
1k views
How can I create an Entity Relationship Diagram for SharePoint lists?
I'm trying to design/document a collection of lists with lookups in an Entity Relationship Diagram.
Currently I'm using Visio's built-in ERD template, which is most of the way there, but it lacks two ...
3
votes
2answers
826 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 ...
3
votes
5answers
5k views
What's the best way to move a list from one site to another?
I know you can backup site collections with stsadm -o backup, and you can backup sites with stsadm -o export. But what's the best way to copy a list. I've tried to use the save as a list template and ...
2
votes
1answer
285 views
How to count number of finished tasks over total tasks in a sharepoint 2010 list to display in KPI
My problem is this:
I need to create a dashboard/kpi in SP2010 that will show the progress of a certain project.
The progress should be counted via the number of tasks/milestones completed in the ...
6
votes
3answers
131 views
Filter out folders from a user alert against a list
I have created an alert for a user against a list (more specifically, a document library).
I want the user to be notified of all changes regarding list items (documents) and not any sub folders.
...
6
votes
2answers
2k views
Renaming Title Column in SharePoint List Definition
I am defining a custom list content type for SharePoint (using VSeWSS 1.3 and schema.xml).
I want to change the display name of the default title field ('Title') to 'Serial Number':
<Fields>
...
5
votes
5answers
3k 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
2answers
807 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 ...
3
votes
1answer
160 views
Best Practice to handle items modification in SharePoint 2007
From my understanding, there is no checkout function inside a SharePoint 2007 List.
So, what is the best practice that SharePoint Professionals and Expert do to make sure that a item of a SharePoint ...
2
votes
1answer
1k views
Visio Diagram link to SharePoint 2007
May I know what are the steps to create a office layout inside Microsoft Visio Diagram, then link this Visio Diagram to SharePoint List, such that when my mouse hover at a particular location in the ...
2
votes
1answer
628 views
“Access denied” while loading the BCS list from the database
I have tried to display data from SQL Server to a SharePoint page through BCS services
using SharePoint 2010 designer.
While loading I am getting this error:
Access denied. You do not have ...
1
vote
2answers
381 views
Any way to only include a particular page (such as DispForm.aspx) in Search Results?
I'm trying to create a search scope in SharePoint 2007 that searches all lists in a given site. But I want the results to only include the actual list item itself, not the all items form or anything ...
1
vote
2answers
1k views
How to disable new/edit/delete of SharePoint list/library views
In our SharePoint portal we have some custom views defined for list and libraries.
I have created the views using list event receiver. Now I need to disable the new/edit/delete views option from ...
0
votes
1answer
1k views
Getting items from rows 4-8 in a Sharepoint list using CAML query?
Here is the code Im using to retrieve the first 4 most upcoming announcements from the OOTB announcements list in sharepoint:
How do I modify this to retrieve the next 4 (5,6,7 and 8) most upcoming ...
6
votes
4answers
355 views
What are the benefits of grabbing a list by Guid compared to any other way
I know its always best to access a list by its Guid since it won't ever change, compared to accessing a list by Title or Url, but what are the other benefits of grabbing a list by the Guid?
There ...
6
votes
1answer
448 views
Where to load data in the lifecycle of custom webpart
I have a webpart where I access a sharepoint list and render contents of that list.
At the moment I'm fetching the data in CreateChildControls().
When a button is clicked the data will be fetched ...
5
votes
3answers
5k views
How to delete the undeletable list
Somehow a developer has managed to royally screw up a site collection. The site collection has the Publishing Feature enabled and it's working fine. A botched migration from 2007 to 2010 has caused ...
3
votes
2answers
4k views
Permission levels for user exporting list into excelsheet sharepoint 2010
What are the minimum permissions needed for a users to export the list into excel sheets in SharePoint 2010?
3
votes
2answers
2k 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 ...
3
votes
2answers
2k views
Customising Data Sheet View
I'm using SharePoint 2007, with custom list.
I'm using Content Editor web part in order to design my list.
{In my list the row color determined through the item ststus.
e.g: If the status equal to ...
3
votes
4answers
2k 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, ...
2
votes
2answers
1k 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 ...
2
votes
4answers
1k 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
1answer
2k views
What does the GetListItems query option IncludeMandatoryColumns do?
I found myself working with the Lists.GetListItems method fairly often. Unfortunately, I have never understood what the IncludeMandatoryColumns query option actually does. The documentation seems to ...
2
votes
2answers
189 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 ...
2
votes
2answers
641 views
Create Site Column (lookup type)
Is there any solid (proven) method of creating Site columns (lookups) where list GUID is not known?
I think this is where feature activation kicks in; getting the lookup list by its name and then ...
1
vote
2answers
76 views
Filter list data based on page Url
I have a relatively small SharePoint list. When a user comes to the list page I want a generalized list to display with a search box. I want this list to have no parameters or variables attached to it ...
1
vote
2answers
129 views
Delete list in Sharepoint 2013 larger than 5000
I have created a sharepoint list in 2013 by importing an access 2013 table which has 7414 records and have set the list to sync with the table held on my local PC.
I want to start over again but
when ...
1
vote
2answers
172 views
Import a single row from Excel spreadsheet
I'm currently trying to copy a single column from an excel sheet and import it in an existing list on sharepoint. I tried this via microsoft access, but i'm only allowed 255 characters per row!
Is ...
1
vote
1answer
63 views
I have list that I need 2 columns (Choice) to pull up different fields
I have a column named Origination and a column named Sub organization.
When the user choose choice A in organization I need specific choices to pop up for Sub Organization.
When the user chooses ...
1
vote
2answers
349 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.
...
1
vote
1answer
328 views
Retrieve SharePoint list (and library) & their items name
I have the following code that will help me to retrieve all the List in my SharePoint list. However, I have a few questions as follows:
[1] How do I set it such that it will only display those ...
1
vote
2answers
184 views
Re-executing JQuery Function on List Manipulation
I have the following JQuery code entered into a content editor web part which does some conditional formatting on the table cell of a list. The trouble with this is that it executes fine on document ...
1
vote
3answers
738 views
How can i reorder items or swap items in a list or lib(Drag and drop will be ideal)
I have a project and one of the requirement is ti be able to re-order images ot items.
So lets say they load the page and i have this 6 images.
1 2
3 4
5 6
and the users would like to swap 1 ...
1
vote
3answers
915 views
Possible to load a SPListItem from the item url?
I have a FullTextSqlQuery that is returning the URL for a list item. I would like to create a new SPListItem object from that URL. Is there an easy way to do this, or will I need to peel apart the ...
