Rows of items containing columns of information.

learn more… | top users | synonyms (1)

6
votes
2answers
1k views

Best practice for combining two lists

I know it's a common SharePoint problem. I want to accumulate two SharePoint lists on MOSS 2007. One is a calendar list and the second a custom list with a date column. I want both in another list. ...
6
votes
1answer
6k views

Programmatically find lists by template ID

I am looking for an efficient way to programmatically find all SharePoint lists with a given template / type in the current site collection from within a sandbox solution. NB: I'm obviously aware ...
6
votes
3answers
10k 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: ...
6
votes
1answer
3k views

Choice field changed - How to propagate the change down to all lists that used it?

I have a feature (Web scoped) with a content type which contains a field (Type="Choice"). Values were A, B and C. I've created a list based on this content type and added some elements in it. I ...
6
votes
1answer
8k views

How can I restart list item ID numbering at 1?

I deleted list items that include an ID from the list and the recycle bin. When I create a new list item, the ID populates where the last line item left off. Now is there a way to make a new ID ...
6
votes
1answer
917 views

How to Combine IN-Opeator with LookupIds in a caml-query?

I want to build a CAML - Query using the IN - Tag. The queried Column is a lookup-field to a Title of another list. When I query using the text-property everything works fine: <Where> ...
6
votes
2answers
455 views

Create a decrementing budget

I'm new to sharepoint and I have been tasked to create a depreciation list using a sharepoint 2007 environment. Does anyone how to create a list that displays a fixed fiscal year budget, and as data ...
6
votes
2answers
5k 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 ...
6
votes
2answers
3k views

How to create SharePoint list with custom template using Managed Client Object Model?

Creating lists in SharePoint using Managed Client Object Model is rather easy task. Here's how to create a list with SharePoint's custom list template: ListCreationInformation lci; List list; lci = ...
6
votes
2answers
127 views

How to make the “Web Address” link in List Settings clickable

On the "List Settings" page of any custom list that we make (or OOTB list for that matter), there are 3 fields that show at the top at all times: "Name", "Web Address", and "Description" (sample ...
6
votes
3answers
213 views

Equivalent of a database table in SharePoint?

I'm making a Publishing site, and part of this site will display information about company products. We have a number of products, and each one should have its own description page. The description ...
6
votes
1answer
143 views

Is it possible to have different timeline views against the same list?

Using a single task list, from our testing it seems that the add to timeline/remove from timeline functions store state across the site list rather than against the view. Is it possible to select a ...
6
votes
1answer
3k views

Inherit permissions on list in a sub-site causes site collection lock-out

Scenario is this - site collection contains a sub-site with unique permissions. In that sub-site, site owner with full control creates link list. That list is not created with the same permissions as ...
6
votes
2answers
878 views

Saving list template with managed metadata columns. Creating new list with the template.

I have a list that has several columns including managed metadata columns. I'm saving this list as a template and including all the content. I'm then taking this template to another site collection ...
6
votes
0answers
128 views

How to create a Sharepoint list that can be used by both an Access desktop application and an Access web app

A Sharepoint list that can be edited by both MS Access desktop and MS Access web apps (Access 2013). I want a Sharepoint list that works off line and then syncs when the network is working. Sorry, I ...
5
votes
9answers
16k views

How to delete all items in a List using PowerShell

I am using following PowerShell script to delete all items of the List. It's working fine but take too long for huge lists. Is there any efficient way of clearing list items, something like truncate ...
5
votes
3answers
7k views

Deploying List Instance - LookupMulti Type Column in XML

So I have been able to populate rows with Lookup type fields as such: <ListInstance ... > <Data> <Rows> <Row> <Field ...
5
votes
5answers
4k views

How to hide a column from new item but not edit item?

I have a list, and all I am trying to do is hide an column for when a user creates a new item, but allow the column to be shown in the edit item page. Currently if I hide a column it is hidden in both ...
5
votes
5answers
4k views

How do you hide a hidden list?

If you set the SPList.Hidden property to true, the list isn't shown in the Quick Launch, All Site Content, Lookup lists, etc. However, it is still possible to navigate to the list by typing in the ...
5
votes
3answers
12k views

How can I change URL of existing list?

If I create a list with a name like Project Risks it gives it a url like: http://myhost/mysite/Lists/Project%20Risks/AllItems.aspx. If I customize the list and then decide I want it call Project ...
5
votes
2answers
306 views

ListItem[“Property Name”] VS ListItem.Properties[“Property Name”]

When we try to get list item properties, three ways of getting property I remember are, ListItem["Property Name"] //always work fine ListItem.Properties["Property Name"] // works fine unless I ...
5
votes
4answers
4k views

Prefilling field in NewForm.aspx in modal popup

I have a listview setup on my page which shows orders from an orderlist. Works great. Now I want to add a column which displays an icon. When the user clicks this icon, the NewForm.aspx page from ...
5
votes
5answers
13k 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 ...
5
votes
4answers
5k views

calculated field - formula for ageing

Again a calculated field question, How can I create a calculated field to find out, what is the age of the entry. In the list I will have a created date field, from that I would like to create a ...
5
votes
2answers
10k 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?
5
votes
2answers
4k views

Location of Ribbon XML for List View

I'm looking for the location of SharePoint ribbon XML for List Views. I'm just curious to see how Microsoft has coded it. However, I don't know the location of the xml file. Could someone put me in ...
5
votes
1answer
631 views

Only show Sorting option not filtering opetion in contex menu of header in ListViewByQuery

I have creatd ListViewByQuery control through coding and added the control through RencerControl Event. I am filtering the list in code. so filtered result is shown. I want to hide filter context ...
5
votes
5answers
8k views

Is there a workaround for the 'You cannot create alerts for lists for which users can only read their own items.' error?

I have been trying to piece together a quick and dirty system to allow users to leave messages on each others sites where any user can leave a message, but they can only see messages they have left, ...
5
votes
2answers
3k views

How to change sort order of axis on Chart Web Part?

I have a Chart Web Part that is connected to a SharePoint list. I modified the All Items default view of the list so that it would be sorted correctly but the Chart Web Part does not pickup on the ...
5
votes
3answers
8k views

List with hierarchy

I want to create a list with tasks, subtasks of these tasks, etc. It should also be possible to add new tasks to a specific level in the hierarchy. The only thing I could find is the Managed Metadata ...
5
votes
2answers
305 views

Delete a 60GB list

I have a runaway list which - due to a recursive workflow and versioning - has grown to 60GB. We are now trying to delete it. It is in the recycle bin, however I want to remove it completely. If I ...
5
votes
2answers
2k views

DateTime list column with 1 minute increments

How can I change the time portion of a date time column to have 1 minute increments? When you create a coulmn by default it shows 5 minute increments, but I need to be able to use 1 minute increments. ...
5
votes
2answers
143 views

Only have the option to create Web Pages

I'm a new SharePoint user, getting my feet wet by learning the interface for WSS. I'm trying to edit an existing site by adding a links list. But I don't have the regular options. On the Home site ...
5
votes
3answers
4k views

How can I import e-mail data from outlook into a SharePoint list?

I want to copy an email data into a SharePoint list. User will select which e-mail s/he wants to add and e-mail will be coppied into a multi-line text box. Also, e-mail attachments will be copied ...
5
votes
2answers
2k views

Creating a poll in Sharepoint Online (lists or other approach)

There seem to be many web parts available for on-premise versions of SharePoint but I've not been able to find an easy way of doing them on SharePoint Online. My idea was to create a list that had a ...
5
votes
1answer
2k views

SPList.GetItems query returning an invalid SPListItemCollection. What am I doing wrong?

I'm trying to query an SPList object using a CAML query (see code below). SPQuery queryGetExistingTargetTask = new SPQuery(); queryGetExistingTargetTask.Query = ...
5
votes
1answer
522 views

In MOSS 2007, how to sort a list by a total/aggregate?

I have a basic issue tracking list with a few columns, let's say Application, Title, Created By, and Task Priority. My list is grouped by Application and I am performing a Total (Average) on Task ...
5
votes
3answers
1k views

List Template doesn't appear in gallery after wsp deployment

I have a list template (.stp file) inside a module that I am deploying to a Publishing Site (SP2010) via a wsp. The elements.xml has the correct mapping to the _catalogs/lt folder. When I deploy, my ...
5
votes
2answers
12k 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?
5
votes
3answers
2k views

Show Modified and Created columns with Date only

I'm looking for the best way (if there is one) to show the Modified and Created columns in a list/library with the date only, so without the time. For example, instead of 1/12/2011 8:37 PM it should ...
5
votes
7answers
5k views

Update read-only field (“completed”) in listitem programmatically

I want programmatically update (change) a read-only field (the "Completed" column) of a listitem in a survey, but on everthing I do, I get the message that it's not possible to update a ready only ...
5
votes
2answers
1k views

Data Form Web Part doesn't show data from Linked Data Source

I have Data Form Web Part with Linked Data Source which consists of three SOAP data sources to different libraries on different sites (one parent site collection with two subsites). All was ...
5
votes
1answer
3k views

Error while opening sharepoint list in datasheetview and exporting to excel

I have a List which is having around 14000 items in it.while opening that list in datasheet view it is giving error . Below is a summary of the issue: After selecting datasheet view : "Cannot ...
5
votes
2answers
2k views

Content Type dropdown in a custom list edit form

I have two content types created A and B. I have a list definition where I placed those content types. Using SPD 2010, I created a custom list edit form and as you know, SPD 2010 will ask you to bind ...
5
votes
2answers
157 views

Strategy Queston : how would you implement this calendaring use-case

At my organization there is a process that goes in to preparing for our Board of Director's Meetings that begins 6 weeks beforehand and involves about 9 different steps. We have a template document ...
5
votes
1answer
529 views

Tooltip showing latest pictures inside a Picture Library for SharePoint 2007

Inside a SharePoint Document List, I keep a few folders - Folder A, Folder B, Folder C. Each folder have some pictures inside them. May I know if there are any web part that can help me display at ...
5
votes
0answers
116 views

Create calendar overlay using visual studio list instance

I have created calendar list using visual studio 2013 with two views in List Instance. Now i want to create some calendar overlays using same views i have created in list instance. Please help me to ...
4
votes
3answers
3k views

Placing your branding images in the “14 hive” vs an Images list

What are the drawbacks or benefits of storing images in the hive versus a list within the farm? I have a debate with my colleague that deals with where to place images that must be accessible across ...
4
votes
3answers
4k views

How to add event receivers to all the lists in a site collection?

What is the best practice around adding event receivers across all the lists in a Site Collection?
4
votes
2answers
11k views

SharePoint List with many columns

We are designing a system where data from forms will be stored in sharepoint lists. Problem is that these lists can have very many columns. Question is: Is there a max number of columns in a ...