Questions tagged [column]

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

Filter by
Sorted by
Tagged with
11
votes
5answers
7k 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 ...
40
votes
4answers
122k 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 ...
1
vote
1answer
5k views

Column validation for US phone number format

I want to validate the field for US format phone number(478-857-4578). I used the below code, it works fine for all but one scenario. If I enter only 4 digit number or below than, the error message ...
2
votes
1answer
987 views

Can anyone color code a column with an if statement?

Here is what I am trying to do. I have a SharePoint 2010 list that I want to color code dates based on that it expires 364 days after the date entered. Example: If the date is older then 334 ...
4
votes
1answer
10k views

Group by managed metadata column

Is there any (non-programmatical way) to group by a managed metadata column. My managed metadata column is in my view, but I can't select it in the 'Group-By' dropdowns, why? I'm using a SharePoint ...
14
votes
10answers
58k 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 ...
18
votes
4answers
91k 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 ...
3
votes
2answers
7k views

Use calculated column to add target“_blank” at the end of a Web field URL

It appears I cannot configure a hyperlink column to open in a new window. I read in this post that you can concatenate a hard coded url with the title field of an item to achieve this. However, that ...
3
votes
5answers
13k views

How to set columns visible only in Display Form on a Column used by a Content Type

I have a column that we will call C. This Column is associated to a Content Type (CT). If I go to the properties of the CT -> Column C I can set the column to be Facoltative or Hidden: If I put it ...
13
votes
6answers
20k 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. ...
7
votes
2answers
40k 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 ...
4
votes
1answer
13k 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 ...
1
vote
3answers
3k views

Column Width in Quick Edit or Datasheet View

Is there a way to adjust the column widths or enable text wrapping in the Quick Edit or Datasheet view in SharePoint 2013? I have seen ways to set widths in the standard list view (using CSS), but ...
0
votes
1answer
629 views

Use Sharepoint list fields in JSON column formatting

Some data from other fields can't be reference when using JSON to format Sharepoint List columns. What is being done wrong? For Person fields "@currentField.title" Works "@currentField....
3
votes
1answer
8k views

Why aren't the editing tools available when I am editing a “Multiple lines of text” field allowing rich text?

I have a site column set as "Multiple lines of text" and, under "Specify the type of text to allow:", "Enhanced rich text" is selected. When In the "Edit Properties" dialog, placing my cursor in the ...
3
votes
1answer
1k views

Column validation only when creating new item Sharepoint 2010

So I have a date field that needs to be a future date when the item is created. The formula I have set up for that is: =[Date Required]>TODAY() This works well however I am running into an issue....
0
votes
1answer
728 views

Color Coding a column based on a date

I found a great article on color coding a list item based on dates. However, this only works for 2 days within submission. I am trying to have a coding structure that will let me know when something ...
0
votes
2answers
632 views

Sharepoint 2013 Custom List Calculate difference between Today and Column Value

I'm attempting to use update a Column [Days Since Last Contact] by calculating the different between =TODAY() and a Column [Date of Last Contact]. I've been trying to use [Day Since Last Contact] as ...
15
votes
3answers
23k 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 ...
10
votes
4answers
11k 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 Guid("fa564e0f-0c70-4ab9-...
3
votes
1answer
596 views

How to associate an existing site column to a list using the REST API

In SharePoint 2013, I have a site column that already exists and I'm trying to associate it to an existing list using the REST API. I found examples on adding a new column to a list using the REST API ...
2
votes
2answers
5k views

Calculating Fiscal Year

I am creating a document library in SharePoint 2013, where I want to have a column which shows the fiscal year (= not the date, only the year). It has to be a choice menu, since people in the ...
2
votes
1answer
2k views

Differences between a fields DisplayName and Title

What are the main differences between a fields DisplayName and a fields Title? Why are they sometimes different and sometimes the same? What is the best practice regarding naming the DisplayName and ...
5
votes
4answers
9k 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 ...
1
vote
3answers
4k views

Add Columns in Document Library using REST

I am creating a Document Library using REST with the body content below. At the same time as i create this Document Library i also want to create custom columns. What should i type in the body content?...
5
votes
4answers
2k views

How to make a Column hidden in SP List Item View?

I have a column called "Employee Email" in a custom list. Is there any option to make the column hidden while viewing the item?
4
votes
3answers
21k views

How to increase the number of characters limit in hyperlink column type

I am using sharepoint 2013. I have column type Hyperlink in a list. It is not taking more than 255 characters for the url. Can I increase the limit? How can I do this using js?
4
votes
3answers
2k views

Set default value of Article Start Date to [Today] with CSOM

I'm struggeling with setting the default value of ArticleStartDate date-time column using PowerShell and CSOM. Bakground: I have a content type, used by a page layout, inheriting from Article Page ...
3
votes
3answers
8k views

How do I add custom fields to a wiki page?

I create a new wiki pages library (on SharePoint Foundation 2010) and create some new custom fields (1 choice and 1 text). When I create a new Wiki Page these custom fields are not shown on the web ...
3
votes
2answers
5k views

JSLink Client-side rendering

I need to render some fields client-side, I followed this guide: Client-side rendering but this code is not working: (function () { // Create object that have the context information about the ...
3
votes
1answer
466 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. ...
2
votes
0answers
599 views

Using a workflow to automatically create document folders each time a new list entry is made

I'm new to sharepoint developer, so I'm hoping someone is able to guide me (provide simple instructions!) on whether it's possible to create a workflow where once I enter a new item in a list, a new ...
2
votes
1answer
3k views

Anything other than username in Person or Group column will not resolve only in quick edit mode

This is a SharePoint 2013 environment migrated from SharePoint 2010 (this works properly in the old 2010 environment). There's a “Person or Group” column present in a document library. When using “...
2
votes
1answer
19k views

Change Field's DisplayName in a List

I'm trying to change the DisplayName for a field that belongs to a list. Below is the code that I'm using. using (SPSite site = new SPSite("http://sp10dev/sites/demo")) { using (SPWeb web = site....
2
votes
4answers
12k views

How to delete a column in a content type?

How to delete a column in a content type? The columns are not clickable? And content types inheriting from based documents or items ct.
2
votes
1answer
6k views

How do I unhide hidden column in SharePoint 2010?

I've upgraded a SP2007 to a SP2010 and now some settings have been lost. In some CQWP I need the Created column to group items etc. How do I unhide it so it is selectable in dropdownlists and displays ...
1
vote
1answer
3k views

Date column value changes because of DST

A list includes a column "Date" of type Date and Time, Date and Time Format is Date Only. An item is saved via web-service and is set to value such as 2013-04-01T00:00:00Z. When this same item is ...
1
vote
1answer
1k views

What happened to multiple lines of text text format and append changes only settings?

I have created a document library. Next, I wanted to add a Multiple lines of text field and have Append changes only option selected. But, to my surprise, once I choose the field type, I was not ...
1
vote
2answers
704 views

How to add an default Image to SharePoint list item?

I have a column named photo How can I add a default image in a list item, which in my case is photo? for example If a user does not have the proper image for an item, or if he forget to add image. ...
1
vote
2answers
1k views

Filtered lookup column

i have two lists, list A creates events, list B creates reports based on events on list A. I currently have a lookup field (in list B) that pulls the event name from List A, that way they can select ...
5
votes
3answers
14k 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 ...
5
votes
2answers
8k views

JSLink Client-Side Rendering Not Functioning on Custom List

I tested out the use of JSlink on the homepage with a demo list & it worked fine. I then used the same JSLink on the Demo List itself but images did not render. Any ideas on what I'm missing? ~...
4
votes
7answers
420 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
5answers
6k views

Want to link document to TITLE NOT to name

Ok, when I do as suggested by @users1100 This is the result I get, the column names goes away totally, and Title is still not acting as an url/linked to document.
3
votes
2answers
7k views

Get other field value in JSON column formatting

I've been looking into the new nice JSON column formatting functionality in SharePoint Online. I cannot find a way to include values from other columns in my display result. This should be a very ...
3
votes
1answer
703 views

Popup confirmation on 'status' column change

I'm looking to create a popup dialogue box when a column called 'Status' is set to 'Complete'. I want a popup box to ask "Confirm Complete?" with Yes or Cancel choices. Obviously Yes will update the ...
2
votes
6answers
5k views

How can I auto-increment a column?

I am working on a solution where I have a list with a column named LogIDNumber. For each new entry in the list, I would like to increment the LogIDNumber by one. I could use the ID generated by ...
2
votes
2answers
4k views

How do you create a multi-select people-picker field programatically in SP 2007?

I would like to create a people-picker user field where more than one user can be chosen. Currently, this is what I'm doing: SPField field = new SPField(contentType.Fields, "User", "Users"); ...
2
votes
4answers
8k views

Show list items depending on a user

I have a list and for example in my list there is a column called "Go to" and this column has values "user1", "user2" and "user3". I want my list items which have "user1" value just be visible to user ...
2
votes
0answers
525 views

Filter.aspx and GetDistinctValues

We found an issue, that filters on columns are stop working. Error message is: Cannot show the value of the filter. The field may not be filterable, or the number of items returned exceeds the ...