columns (fields) created using out-of-the-box column types

learn more… | top users | synonyms (1)

18
votes
4answers
59k 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 ...
12
votes
3answers
16k views

How do I convert SPUser to SPFieldUser?

I have a field in a list that accepts an SPFieldUser object. I have an SPUser object that I would like to populate that field with, but I cannot implicitly convert from one to the other. How would I ...
11
votes
5answers
14k views

Display the Sharepoint context menu in list items on another column instead of Title column?

In SharePoint Lists, we can define new View and select the columns that we want to show. I don't want to show the Title column but I also want to show the default Context Menu for the0 items on List. ...
10
votes
10answers
41k views

Read-only column in a SharePoint list

I want to create a read-only column in my "Request Approval" Nintex workflow task that I sent to the user. I did the following: Created a column in my list. Field name: “Guideline” In the default ...
10
votes
4answers
7k views

How to rename title column in Document Library using code?

Everybody loves renaming columns. The title column is a favorite of mine and I can't seem to rename it via code: SPList list = web.Lists.TryGetList("MyList"); Guid guid = new ...
10
votes
1answer
124 views

set column order of fields using CSOM/REST javascript

I am creting list fields using CSOM ecma script. How do I set the column order of the fields to be displayed in the form programmatically? For eg: I have created the following fields programmatically ...
9
votes
3answers
56k views

Can I create some sort of Attachment column in a list?

User needs a list to track issues. They also want to be able to attach a document to this issue. If this attachment was mandatory I would be able to create a document library, but since it is not I ...
8
votes
4answers
3k views

List Validation does not show Error when Conditions are not met

I am using List Validation feature for a list which is working fine i.e. doesn't save the item when condition not met. However, it is not showing the error message which helps to rectify the inputs in ...
7
votes
3answers
7k views

Possible to format how numeric columns display?

I have a numeric column in a list that displays like so: 16,090 I would like it to display without the comma: 16090 Can this be done?
7
votes
1answer
8k views

Referencing SharePoint list columns with spaces in names

I'm running into issues referencing column names in SharePoint Designer 2010 when the names have spaces in them. This is discussed in this blog post. For example, I've tried using the following ...
6
votes
2answers
22k views

More than 255 characters in multiple lines of text?

I have an InfoPath Form which submits the text of a textbox and saves it in a SharePoint list. Whenever a user types in more than 255 characters and I want to edit the element in the SharePoint list ...
6
votes
2answers
18k views

Why isn't “Column ordering” available in my list settings?

I want to change the column order visible when viewing or editing a list item. I have accessed the "Column ordering" interface via the list settings page on other lists in the past, but it isn't ...
5
votes
3answers
996 views

Add a user profile property as a library column

I have a few properties stored against user profiles (both standard and custom properties) that I would like to show, based on the user that created an item, in library views. For example, if the ...
5
votes
1answer
127 views

Multi line text field with unlimited length in document libraries allowed

What I am doing: Migrating Documents to SharePoint Online using PowerShell Script. Once document is uploaded I am simultaneously setting property values. Case: In a Document Library, I have a field ...
5
votes
3answers
3k 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
6k 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 ...
4
votes
3answers
11k views

Retrieve All Lists With Specific Name Using Powershell

I have a powershell script that I am trying to use to add a column (Created) to a specific view in a specific list in multiple webs. The list exists in every sub web. The view exists in every list. ...
4
votes
4answers
6k views

How to assign metadata to a Site Collection

In SharePoint 2010 we want to create several different Information Architecture views of our Site Collections. One idea is to use Term Store from the Managed Metadata Service as a way of creating an ...
4
votes
4answers
230 views

Possible to create a column that users can upload an image to?

I'm trying to create a column in a list that users can upload a picture to. I found the Hyperlink or Picture, but this requires that users specify a URL for the image. Is there way to create a ...
4
votes
7answers
301 views

Permissions for List or Library Columns

Is there any way to give permission to a specific field of a list or library? I want one of my users for example cannot add or edit data in a specific column. Can I set permissions to the form and its ...
4
votes
2answers
6k views

Validate a SharePoint list column with regular expression

I have a list. I want add a column for list with this format : XX-XXXX How to set this Validate for column? i use this link , but don't work for me.
4
votes
2answers
4k views

List View Filtering on Managed Metadata Fields issue

Our client asked us to change list view filtering to not show all terms from taxonomy in managed metadata, but only those from documents in library. Currently we have two columns: We have a managed ...
4
votes
3answers
611 views

Soap + Rest: Trying to understand differences for selecting fields between the two

I'm working on a Java-Application that integrates with SharePoint. The different SharePoint services are currently requested via the SOAP API. I am now working on an abstraction layer to also ...
4
votes
2answers
3k views

Add custom field to blog post.aspx page (SP 2010)

I have changed the default look of the post.aspx and default.aspx page for the OOB SharePoint Blog 2010 by using custom XSL file based on the OOB one only changed the option to show custom logo in the ...
4
votes
1answer
711 views

SharePoint Bug? Conflict Error when saving a Page with a “Required” DateTime field in the page layout

I've just recently encountered a weird error / bug in SharePoint. Here is the scenario: I have a custom column "Test Date" that is of DateTime field type. The field is configured as required. It is ...
4
votes
1answer
181 views

How to send email to people from choice column with multiple selections

I would like to choice people from choice column with multiple selections and then send email to these people by using workflow SPD. Can I do it? I use SharePoint Foundation
3
votes
1answer
2k views

How to get Column Level permission in SharePoint 2010?

I require column level permissions in SharePoint 2010. In MOSS 2007 I was using SPListDisplaySetting. However, it does not work for SP2010. Anybody has an alternative solution?
3
votes
2answers
48 views

How to seen all JSOM internal fieldnames not DisplayName of Column of the list?

I know to get the Internal Fieldname from URL. But that takes long time and status bar is not always full with the url, so you have to open ze field and see in the top url what the internalfield name ...
3
votes
1answer
11k views

2010 Column Validation Formula

This formula works fine when adding a new list item: =[Class Date]>=TODAY()+3 Basically ensuring the user selects a date greater than two days away from current date. I don't want the formula to be ...
3
votes
3answers
542 views

The CHOICE element contains the value within its body. What gives?

As stated on MSDN, the CHOICE element contains the value within its body. That means that in a field, if I have: <CHOICES> <CHOICE>foo</CHOICE> ...
3
votes
2answers
127 views

Create custom view

I have a product library which contains choice menu column. The name of the column is New Product?. And the choices are TRUE and FALSE. I want to create a custom view which only shows Old Products. ...
3
votes
4answers
2k views

How to create web-related lookup field to 'pages' list?

I have SharePoint site collection 'http://microsoft.com/' with few child webs ex: http://microsoft.com/news/ I want to create lookup field to 'Pages' list. On each child web lookup field should ...
3
votes
2answers
9k 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
1answer
186 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 ...
3
votes
3answers
326 views

Can I add a start workflow link to a column in a list view?

I would like to add a link directly to a start workflow page in a column so that users don't have to go through several clicks to start a workflow. The link needs to change based on the item ID for ...
3
votes
1answer
7k views

Uploading a file using powershell and updating column values

I am trying to upload a file from a local drive to a sharepoint doc lib, this much I have been able to find, however, I also want to update a column relative to the file, foe example, I have a company ...
3
votes
2answers
3k views

Sharepoint External Data field with multiple values

I need to create a list column which contains external data (from BDC). The field has to contain multiple values. But I haven't found a way how to make a external-data-field take multiple values. ...
3
votes
2answers
252 views

Why are some of my content type columns grayed off?

Here's what my content looks like, currently. Some of the columns are grayed off for some reason, and I can't change their visible/hidden/required status. It only happens with Integer columns. If I ...
3
votes
1answer
4k views

What does the “Copy Source” column mean in a document library/list?

Pretty basic one here. Google borks out. I have a document library, and one of the columns is named "Copy Source". What does the data in the column mean?
3
votes
1answer
46 views

Can I prevent duplicates to a SP2013 list with a validation formula?

I have a SharePoint 2013 list and want to use 2 columns as sort of a natural key on the list, so when a user enters a new entry, if these 2 columns combined match an entry already in the list, it ...
3
votes
1answer
32 views

Field name changes when I add a number

I use the shortest words possible when creating fields in a custom list. I go back and rename it sometimes, but the URL retains the shorter name. I have created a list, and have fields IS1 thru ...
3
votes
2answers
136 views

How can I identify columns independent from language?

I've got a webpart which reads several values from a list, while developing local I've got a column "Due Date", but when I upload my webpart to SharePoint online (Office 365) we have a German version ...
3
votes
1answer
3k views

Converting number field to text field results in data loss

I have the following scenario: A standard generic list with a number column. There is a large number of list items in the list - 200000. All list items have an integer number value (no floating ...
3
votes
2answers
439 views

Is it possible to copy the default value setting of a folder and its subfolders to a new folder?

I configured the column default values for one folder and all its subfolder in a Document library. I would like to repeat the same setting for a new folder in the same library. I tried to copy/paste ...
3
votes
2answers
1k views

A change to the 'required' value of a site column not reflected in content type

As title suggests, I had a site column defined in the xml of a content type. The site column was required. I have just changed the definition of this field (it is not defined anywhere else in the ...
3
votes
1answer
265 views

Convert Field To FieldLookup using ClientContext

I need to get a FieldLookup from a list (already queried). First line in the below code errors out "Unable to cast Field to FieldLookup". Yes, the field I am trying to retrieve is a lookup field only. ...
3
votes
0answers
25 views

Multiple validations in a single column in 2013

I have been working on something I feel should be very simple for far too long. I have a single line text column in a list and would like to employee multiple validations to the column. The ...
3
votes
2answers
61 views

Create auto generate sequence number column

How do I change the default "Title" column in SharePoint 2013 into a column which have sequence number generate automatically? Example as below: PO-15-2001 PO-15-2002 PO-15-2003
3
votes
0answers
46 views

Pasting into a metadata column

So I am moving our phone inventory over to SharePoint, and I have created numerous columns. Three of the columns use metadata, and so when I paste the items into the field I get the little red box ...
3
votes
0answers
124 views

How do you validate a column only if it's new item being added?

I recently added validation to a field which works great. =[Arrival Date]>=TODAY()-5 However, I ran into an issue when an employee is editing an older item to update the "Status" but it's not ...