Questions tagged [column]

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

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

LinkToItem not linking to document

I have tried linkToItem="TRUE" but it doesn't work on my SP2013 version but LinkToItem="TRUE" does. Only one issue, the LinkToItem doesn't open the file, it just opens the edit/item screen. How do I ...
4
votes
3answers
1k views

Date field validation in SharePoint 2007

I need to limit the Date field in a SharePoint 2007 list so the users can enter date from today and up to year after. How can i do it?
4
votes
1answer
7k 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?
4
votes
4answers
170 views

Page Library - new column with required field, how to prevent page creation if required field not filled

Here's my problem: In my default page library I have added the column "Content type". This contains a selection list (manual, source code, etc.) and can be edited via drop-down menu. I have set this ...
4
votes
3answers
620 views

Using Contacts app to store contacts without Last Name

I would like to create a contact list containing both Persons and Companies. Is this possible at all? The issue is that companies do not have last names, which is the title column. When I link the ...
4
votes
2answers
3k views

How can we enforce unique values based on more than one column in list

I am unable to enforce unique values based on more than one column in list. Current scenario: I can make a enforce unique values entered in single column unique using OOTB functionality. What I ...
4
votes
1answer
2k views

Field's TitleResource.SetValueForUICulture() does not work for the web's default language

I have a site column in my site collection whose title I change / translate with following PowerShell statement: $w = Get-SPWeb "URL to the site collection" $f = $w.Fields.GetFieldByInternalName("...
4
votes
5answers
6k views

Image column on document library

I have a requirement to add a thumbnail image column into an existing document library on my SharePoint 2010 site. Thumbnail images for each document are uploaded to the images document library. ...
4
votes
0answers
109 views

Highlighted content - how to filter by custom column?

We use SharePoint as a wiki. So we create modern pages in the standard library and in a newly added column we specify that it is a wiki page. The views are filtered accordingly so that only wiki pages ...
4
votes
1answer
281 views

How do I validate Start and End Dates by column?

I have a site where employees input schedule items, each with a Start Date and End Date. I would like an error message to appear when users select an End Date before the Start Date. What formula can ...
4
votes
1answer
179 views

How to retrieve column names in other languages with CSOM?

I am trying to retrieve display name of a column in all languages available in my SharePoint installation (currently English and German). internal static void TestColumn(Microsoft.SharePoint.Client....
4
votes
1answer
3k views

Phone number column validation

I want to add phone number column with below format: 1-121-343-6917, 434-5503 & 60-12-444 444 Used below method =TEXT(123456 ,CHOOSE( LEN(123456) ,"0" ...
4
votes
0answers
106 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 ...
4
votes
1answer
360 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
5answers
14k 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 ...
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
3k views

Calculated field not showing up in “New Item”

Is there any way to show a calculated field when I'm filling out a new item for a list? For example: If I select "Blue" in field1, and "Bird" in field2, then, on the same page where I am filling in ...
3
votes
2answers
2k views

How to display published date column in document library

The scenario is there is a document library where user maintains major and minor versions of a document. When the user has to edit a document s/he checks out the document and starts their editing. ...
3
votes
2answers
281 views

Can someone spot an calculated column error Please?

I am trying to create a calculated column where 'Today Date' is another date column. The first two block are working fine till the [Enter time]=2 condition when I add other two it says syntax error. ...
3
votes
2answers
8k views

Rest API - Get list items by column value

Assuming there is a list of Students with their zip-codes in one of the columns, what is the query string needed to get only students with a certain zip-code? So far here is what I've got: site.com/...
3
votes
4answers
16k views

How to hide a column for some users or groups

I want to hide a column for some users or groups. How can I do this with Sharepoint 2013 ? Is there a function to Hide or Show a column for specific users?
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
3answers
5k views

How to add a Custom Column to a Site programmatically

I'm programmatically creating Site Collections. The only thing I'd like to add to the newly created Site Collection are some Custom Columns that I've added manually in other examples.. The code I'm ...
3
votes
3answers
711 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> <CHOICE>bar</...
3
votes
2answers
152 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. I'...
3
votes
1answer
14k views

Sharepoint 2013: changing column order is not refleted in the list

I changed the column order on a list item. These changes are reflected in the "column ordering" view. However, the changes are NOT reflected in the actual list layout. I tried emptying the browser ...
3
votes
1answer
11k 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
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
80 views

SPO: Workflow not working

I have this basic workflow that would get the value of the "created by" column and would populate it as a user name in a people column. The issue is it is not working. I can see the flow going to ...
3
votes
2answers
4k 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
1answer
2k views

Managed Metadata field full path

I've added a custom Managed Metadata field in my custom contenttype but need to show the full path. Anyone knows how to do this? (if possible with xml, else with c#) XML so far: <Field ID="{...
3
votes
2answers
1k 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
3answers
4k views

SharePoint 2013 - get the internal name of a list

I use a SharePoint list to display a graphics in javascript and I want to get dynamically the name of the columns of my list and not write them in my code. Is there any way to that. To get my list, I ...
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....
3
votes
1answer
10k views

Change List Item Created Date field with Powershell

Good Day, I have a list in SharePoint 2013 that I'm importing items from a csv. I need to change the created date to the created date of the imported item. I'm able to import the list item ...
3
votes
4answers
8k views

Calculated column that updates daily

Is there a way to make a column in a list that updates daily with the current date? If not what's the best way to do this? I was thinking of using the 'Lookup' field to link to the calendar that's on ...
3
votes
2answers
6k 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
2answers
2k views

How to programmatically get questions from a Survey

The question is quite simple: how can I get the list of questions from a Survey?
3
votes
2answers
3k views

Association Columns “greyed out”

In the SharePoint designer, when I create a new reusable workflow (SP 2013), the "Association Columns" button is greyed out. Which is a shame, because I need to add a couple of them :) Does anybody ...
3
votes
2answers
34 views

Make a DATETIME column show red background 2 hours after duedate

So I got this code, it makes the background green when it has passed the set taskduedate. But I want it to show red background when it has passed 2 hours after taskduedate, it that possible? { "...
3
votes
1answer
183 views

Sorting Numeric Column

I have calculated column in a document library. The value for this column is a part of the files title. I'm using this formula: =RIGHT(Title,LEN(Title)-FIND("$",Title)) The data type returned from ...
3
votes
2answers
4k views

SharePoint Online: List column filter not showing all values present in it

A simple SharePoint custom list in office 365 has 8 columns and no special settings are enabled on it. The columns are of type choice and has 5-6 types of values present in them. The OOTB column ...
3
votes
1answer
96 views

Messed up columns and forms after adding from existing site columns

I'm very new to SharePoint and have a stupidly high level of access to a site built for our team (dangerous!). Apologies if this is a duplicate question however I haven't been able to find a ...
3
votes
1answer
52 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 IS10....
3
votes
1answer
790 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 ...
3
votes
1answer
15k views

How can I add fields from an InfoPath form to a list? [duplicate]

Possible Duplicate: Can I display a field from a form in my form library view? I have a document library that uses an InfoPath form as the standard template. How can I have data from the form, ...
3
votes
2answers
147 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
7k 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 point)...
3
votes
2answers
5k views

Column formatting with json

On a standard Date field that is inputted, can I display a full data format (example Friday, 23 March 2018 instead of 23/03/18) with Json to place in the column settings? Please advise

1
2
3 4 5
21