Rows of items containing columns of information.

learn more… | top users | synonyms (1)

3
votes
1answer
214 views

How to have a calculate column that compares the difference between the current item and the previously submitted item?

I have a list with the columns Room Number, Temperature, and a column Temperature Change. What I would like, is for Temperature Change to be a calculated like so: When the user fills out a new ...
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?
3
votes
5answers
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 ...
3
votes
3answers
2k views

Logging emails in SharePoint list

We have a requirement on a project that the client would like to see all correspondence between them and their customers in a central location. We though of using a sharepoint list. What is then the ...
3
votes
5answers
8k views

Sort order issue

I'm having an issue sorting data in ascending order. Right now the sort order is: 1.0.0 10.0.0 10.0.1 11.0.0 2.0.0 2.0.1 3.0.0 3.0.1 3.1.0 What I want is: 1.0.0 2.0.0 2.0.1 3.0.0 3.0.1 3.1.0 ...
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 ...
3
votes
2answers
2k views

Can I use the SharePoint 2010 Client Object Model with Sharepoint 2007?

Any workarounds or alternatives that work on both SP2010 & 2007. http://www.microsoft.com/downloads/en/details.aspx?FamilyID=b4579045-b183-4ed4-bf61-dc2f0deabe47
3
votes
4answers
114 views

Make lists hidden that users can still contribute to but not see

I have a scenario in which I want users that belong to a site collection to be able to edit a list through an application but not see the list itself. I have made a farm solution in SP2010 that is ...
3
votes
3answers
1k views

How do I use getbytitle with special characters?

I have a list named "St. John's Calendar". How do I use it with SP.CamlQuery? I'm thinking I need to encode it in some way, but nothing so far has worked. Something like: ...
3
votes
3answers
6k views

Sharepoint list column limit

We are designing a system where data from forms will be stored in sharepoint lists. Problem is there are many fields around (260). What is the better way to handle this ?
3
votes
5answers
8k views

How can I limit user to only enter one item in a list?

I am creating subsites for individual clients. In the subsites I have different lists that capture information for the client. Some of those lists would be repeating (a client might have three ...
3
votes
1answer
340 views

Delete List Item with Ajax

I've been trying a few options out, but I'm finding good SharePoint AJAX guides to either not exist or be hard to find. Very simple, I am rendering list items with a repeater, and I want to be able ...
3
votes
2answers
876 views

Sharepoint 2010 Lists, is value specific formatting of columns or rows possible?

I would like to format columns or rows that contain certain values, without any client side javascript hacks. I'm looking for an OOB solution. For example - if 1 column in my list being of type ...
3
votes
4answers
19k views

possible ways to import an excel spreadsheet to a sharepoint 2010 list?

I am running SharePoint Server 2010 and I have an excel spreadsheet of about 3000 rows / 30 columns, which I would like to import to a SharePoint list. I've seen on codeplex a free tool for MOSS/wss ...
3
votes
4answers
198 views

Add custom JavaScript to SharePoint 2013 list

I need to add a custom JavaScript link to my SharePoint list, so it would only affect that list. I don't need to add it to any other forms. How could it be done? I was thinking, if to change .aspx ...
3
votes
1answer
734 views

Modified vs Last_x0020_Modified

Which is the difference between the fields: Modified and Last_x0020_Modified in a SharePoint list item ?
3
votes
2answers
4k views

Remove HTML Tags from the SharePoint List column value?

We were trying to create a SharePoint List based on a spreadsheet, a few columns in the spreadsheet has bulleting/numbering. SharePoint List is updated with the details from the Excel, however it ...
3
votes
2answers
2k views

Unable to delete List during solution deactivate

I have two list that I need to delete when a solution is deactivated and removed. But my code doesn't seems to be working. I am trying to delete and remove the quicklinks to the lists in ...
3
votes
3answers
10k views

How to get Item from ListItem with Client Object model

I'm trying to printOut some items from a ListItem. But when run the code I get following exception: "Invalid usage of query execution. The query should be executed by using ExecuteQuery method on ...
3
votes
1answer
209 views

Can an entire list/library be versioned?

It's possible to enable item versioning on lists and roll back to a previous version on that item. Can this be done for the entire list? So we can roll the whole thing back? We accidentally modified ...
3
votes
4answers
266 views

Approaches to hide certain list columns from certain users groups, inside the add/edit/views form & inside list views without using 3rd party tools

I am creating a new list inside SharePoint server 2013, which have these columns:- Title Description Price Other… Now I want to only allow users within a specific group to be able to view and ...
3
votes
3answers
274 views

Display current year on 2013 list

How do I display the current year on list date? Example picture below, only the items modified last year or before have the year displayed.
3
votes
4answers
186 views

Only send notification when certain items are changed

I have a List with two workflows. One that runs when an item is created/updated, and another that runs daily to perform a calculation. Emails go out when an item is created, updated, and expires. ...
3
votes
4answers
1k views

Restricting access based on a field

I have a sharepoint list of 2000 employees . They are from 25 different offices. One of the fields is Office name. I would like to restrict access so each office can see only their employees but ...
3
votes
2answers
30k views

How can I filter a SharePoint list based on a date column?

I have a column with "start date". I also have a column called "expire date". How can I make a filtered list so that it only shows items where the "start date" is equal or greater and equal or ...
3
votes
1answer
2k views

Implementing a simple bug tracking tool inside my SharePoint 2013

We have implemented a SharePoint 2013 web application , which contains two site collection; one community site & team site. Currently we have a custom software ready for testing . so I was ...
3
votes
1answer
2k views

Show Ribbon Button on all types of Lists

I want my custom ribbon button to show in all list views. I found this example: How do you create a Ribbon Button custom action that will appear on all kinds of lists However, this also shows the ...
3
votes
1answer
3k views

What permissions do I need for a user to see all entries in a list where typical users can see only their own submissions?

I have a list where users can create and see their own items, but not other users' items. I, being the site owner, can see all items. How can I give specific users within a Sharepoint Group the ...
3
votes
2answers
2k views

PowerShell Scripts

Does anybody know if there's some way to delete items from an SPList using PowerShell scripting? If is this possible, has anybody any good tutorial? Thanks!!!
3
votes
2answers
91 views

Training site editors to use SharePoint

We are rolling out about 30 departmental web sites on SharePoint 2010 for our intranet. They all use a common look-and-feel and have publishing pages. The users have capability to edit pages and ...
3
votes
4answers
8k views

How to get rid of a list's column headers?

I have a link list and would like to get rid of the column headers. How can I do this? The reason I would like to do this is because I am grouping links based on a category, and it looks weird with ...
3
votes
2answers
99 views

Delete item post closing date in SPS 2013 List

How to automatically delete the Item from the SPS 2013 List after the closing date has reached for the item. Closing date is one of the column part of the item.
3
votes
1answer
105 views

Document Library Lookup Column

I have a sharepoint list of communities. Each community has an owner (people column). I have a sharepoint document library and a view that joins the document to a community. I am not able to ...
3
votes
3answers
176 views

Is it possible to set the default as “No” for “display this list on the quick launch ” while creating a list?

When you create a new List, the default to include in Quick Launch is YES, which causes "LISTS" to appear in the left navigation. You have to go back and change it to NO. If we want LISTS to not ...
3
votes
2answers
2k views

Get SPQuery TotalItems from query

I want to get the total number of items that match my Query, BUT also limit the results. So say I have 100 items in the list. 50 of the 100 items in the list match my query. I want to only get 10 ...
3
votes
1answer
10k views

Powershell to List GUIDs of Lists and Libraries but how to seperate

Working on a script that will dump out all of the lists and libraries in a site, I found the script on Mike Smith's Blog: ...
3
votes
2answers
17k views

How to use GroupBy in CAML query

I have simple list, consisting of 2 columns - Date, Order. Now what I want to do, is to GroupBy Date and count orders. So, for example if I have following items Date Order 08/10/2012 5 ...
3
votes
1answer
184 views

Changing the name of a sharepoint list programmaticaly

I'm trying to change the "name" of a sharepoint document library (not the title). I have found a way to do it from sharepoint designer: ...
3
votes
2answers
7k views

Creating a word document from a standard sharepoint list item

Can anyone point me in the right direction. I have a list in Sharepoint 2007 which is not a document library. From an item in the list, I can attach files quite happily using thestandard features. Now ...
3
votes
2answers
10k views

How can I provision a list with a calculated field?

I am trying to create some fields, a content type, a list definition and a list instance in Visual Studio. All of my fields are working, showing up in the list etc. except for calculated fields. What ...
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 ...
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
3answers
2k views

Migration tool for specific lists

I am looking for a migration tool that works at the list level, not for a full site or server. One specific requirement is to be able to migrate lists that are connected via lookups. For example, if ...
3
votes
3answers
3k views

How can create a view to filter the a list based on the current login user

How to create a view based on the current user is in a Person or Group field , this Person or Group field can contain multiple user but not SharePoint Group ,I try to use the contains to filter the ...
3
votes
3answers
1k views

Hide a column on a custom list from non admins

When you create a new item is there a way to hide a field on the new item form? I have a status field which I dont want the user to fill in. I only want an admin user to be able to change the status. ...
3
votes
2answers
6k 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
1answer
456 views

Does 1000+ items in a list make it slow for navigation?

It looks like my task list has become slower as items in the list keeps on increasing (currently 1000+). Is there any way to make loading & navigation of the list faster?
3
votes
4answers
6k views

Unable to save changes in Datasheet View

We have a custom list that we are trying to edit in Datasheet view and are getting the following error when the next row is clicked: Another user has changed the structure of this list. All your ...
3
votes
3answers
84 views

Can I trigger a workflow from a hyperlink in a list?

I'm trying to incorporate functionality in one of my lists that will allow users to submit candidate resumes for open jobs that appear in the list. My initial thought was to just have a hyperlink ...
3
votes
1answer
467 views

Check if a Date field is greater than another Date field

I am working on an issue tracking list and I added two custom fields of type Date/Time which allows date only, as follow: Plan start date. Plan end date. How can I check that the start date is ...