Questions tagged [column]

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

Filter by
Sorted by
Tagged with
0
votes
2answers
299 views

Column validation for datepicker - end date must be within 2 years of start date

I have a datepicker. I went into list settings for the start date and set the validation to =Start Date >= today() That works great. Now I want the End Date to be within 2 years of that End Date or ...
2
votes
1answer
2k views

How To Add Color To SharePoint List Column Background?

I have a requirement to make the background of a column in a SharePoint list colored (e.g. green). I have seen posts on CSR, JSLink, Conditional Formatting, etc. & all of these articles target ...
0
votes
1answer
179 views

Custom field type column editor in Sharepoint designer

I would need some help that i was not able to google it and if there is somebody who could help me that would be great. I successfully created a custom field type Now what im looking for is some ...
0
votes
1answer
5k views

Assigning Multiple People to Task

I created a Task app using SP13. Is there a way to add more than one more person per task without using a workflow? I have added a Person and Group column; therefore, the end-user can add the person ...
0
votes
1answer
38 views

Calculated Column for SharePoint List

I have a calculated column displaying a numeric score ---is there a way to have this score rank ordered automatically? (example - scores would be 87, 75, 74...- where 87 would be the number 1 priority,...
0
votes
1answer
533 views

Cumulative sum of a column

What function can I use to create a calculated column [Cumulative Meters] that will sum [Meters] for each row? I can only seem to get a single overall sum for [Meters] using the Totals tool in ...
2
votes
3answers
22k views

SharePoint 2013 Auto populate person column in list with creator name

I have a custom list which contains several columns. I want to add a column to the list which I would like to be a "name/person" field which is mapped to registered users on SharePoint (or AD). But I ...
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?
1
vote
2answers
71 views

How do i get a choice column to change from YES to NO depending on another column using calculated columns

I'm trying to uses nested ifs to change what a choice column displays but I'm not sure if this can be done or if I'm doing it properly. What I'm trying to have accrue is once the next review date ...
0
votes
2answers
21 views

SharePoint File Indexing

In a document library, I would like to show different columns at a folder level, not at an overall level. Currently, I can see the column fields common for all the folders. Is there a way to have ...
0
votes
1answer
47 views

View Item Column Type in Document Library

I'm using SharePoint 2013. When using a custom list an option available is a View Item column that allows the user to view the item details. But I don't see the same option for a document library. ...
1
vote
1answer
407 views

Is there a way to create a large number of columns quickly?

I am about to create 84 choice fields for a timesheet solution I am creating in Sharepoint. Clearly I am procrastinating on this task and here I am. Is there a trick I don't know about that might ...
0
votes
2answers
40 views

how to provide validation on to create SharePoint Date and time Column?

I want to create a SharePoint Date and time Column, so that the user is only allowed only to select a date 20 days ahead of today's date.
2
votes
1answer
237 views

First letter of internal name of list column converts to _x00XX_

I need to create two new columns in a standard list, one is called "AB12" and the other one "AB13". But when I create them, the internal names of them turns into "_x0041_B12" and "_x0041_B13". It ...
0
votes
1answer
26 views

How to Shrink Blue Outline on Page So Everything Shows on Screen

Please forgive me, but I do not know code at all, and I have been asked to maintain our teacher SharePoint page. Yay! Would you take a look at this screenshot? I've obviously done something wrong. I ...
1
vote
2answers
3k views

Powershell - Change display format in SharePoint Site column from friendly to standard

How can I change the display format from friendly to standard? I want to change this on all lists in the solution $sites = Get-SPSite "http://company.com/sites/testdelete/" $created = "Created" ...
1
vote
1answer
43 views

Get the column name of list

I tried this: var fieldValues = currentItem.get_fieldValues(); But it returns [object object]. How can I see through this without know the column name?
0
votes
1answer
507 views

Creating list with Columns in SPFx is failing for few columns

I am creating a list with specified columns on page load (later i will change this logic to on button click). I am using SPFx framework. I have installed sp-pnp libraries. I am able to create the ...
1
vote
2answers
34 views

Is it possible to update a Document Library's property column using SQL?

I'm a newbie with SharePoint so apologies if my terminology is a bit shaky. I've got a situation where the "Title" column associated with all documents in a Document Library (SharePoint 2013) needs ...
2
votes
1answer
132 views

Hiding specific column in search results

How do I hide specific column when user search for an item? For example, user searches for other people's names and the personal detail comes out but some detail should be hidden such as email. Is ...
2
votes
1answer
372 views

Is there a way to view version history of a column attribute changes?

This question is not about version history of changes made in an item record but changes made to the columns or attributes within the list settings. Like for example when someone adds a new attribute ...
1
vote
1answer
167 views

Migrate a SharePoint list with “Related Items” column field

I need to migrate a SharePoint list with "Related Items" column field content of all list items to a completely new SharePoint environment. It does not work when saved the template of the list and ...
0
votes
1answer
460 views

Sharepoint Online - Recover column from lists of project sites

I have a site collection with a lot of subsites attached to projects (each subsite is a site created by a project). Those subsites has a list with its fields. I executed a PowerShell script that ...
1
vote
4answers
1k views

how do you update a taxonomy metadata field where the fields Name contains a space in it

Here is the following specifics in question. I have the following taxonomy field and its associated Note field. The taxonomy field is defined with a space value in it. Taxonomy Field - ...
1
vote
2answers
76 views

How to display and hide columns on Display form based on whether they have data or not

Hi I added some new columns to a library and added those to content type. When user goes to old item in library and clicks it, on display form it is displaying all the new fields which doesn't contain ...
0
votes
1answer
32 views

Can i show imageurl that exist in a library as a column?

I got a picture library.I store the images. There are image urls. I want to reach these urls as a column. Is there a way to show them as a column?
-1
votes
5answers
80 views

Do not show column to user

We have a library where when user uploads file, inputs metadata in 4 custom fields via Nintex forms We also have 2 other fields which holds year & month (we enter a default value) Users are not ...
3
votes
4answers
13k 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
3answers
65 views

Column values do not show in a library

I have added two columns to a document library: "Version" and "Revision". Though I do see column headers on the document library page but the problem is that they are empty, even though some documents ...
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 ...
0
votes
1answer
729 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
1answer
797 views

create a Custom field Type for sharepoint online/ office 365

I need an custom option (custom field type) which can validate input that it is email(just for an example) or not by just selecting column type. Please look the attachment for more information where I ...
0
votes
2answers
5k views

How do I add a Publishing HTML column to pages?

On our site I need to have an extra column on pages where users can enter teaser content. The teaser content is displayed on our homepage. I've created the teaser column with the 'Multiple lines of ...
1
vote
0answers
164 views

SharePoint List flow - how to format link?

I am using SharePoint Online and I have a list for which I am creating a flow. This flow is connected to a document library so that when a new doc is created it is added to the list. We have a ...
-1
votes
1answer
59 views

Creating a custom column

Trying to create a 2 column section at the beginning of the page as shown in the image below - basically 2 column at the top but then rest as one column. One column will have an image and the other ...
0
votes
1answer
178 views

Column valiudation - restrict one choice based on another choice

Is there an OOTB way using validation / forumula to restrict choices in Column B based on the choice selected in Column A?
2
votes
0answers
81 views

Unable to search managed properties for a document library

I have a document library with metadata that seems to have managed properties. I want to be able to search these managed properties. For example, I can do 'Filename:docx' and it shows only word docs....
1
vote
0answers
24 views

Aggregate Data Source New Form Field Problem

I have webpart with five form field. But i need a data from another list. So i use linked data source. When i use it my all form fields broken.Some Input type text change input type file. <...
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 ...
0
votes
1answer
700 views

Unable to delete Hidden column from the list using CSOM in sharepoint online

I am unable to delete the hidden columns (IconOverlay) from the document library using CSOM. At the time of provisioning, the IconOverlay column was added to content type and content type is ...
0
votes
1answer
38 views

SharePoint 2016 modified no. of days

A quick one I hope. Is there an OOB setting to change the modified field in lists and libraries so it just shows the date instead of saying the number of days on occasion.
0
votes
1answer
36 views

How to customize a column's display name on a per-view basis

Is it possible to have the column display name change depending on which view is shown? When I change the display name of the column it applies to all views. The main reason for doing this is some ...
2
votes
1answer
256 views

how to create a calculated fields programmatically

I need to create a calculated item , which has: the ID of the item, the created date and title. How to do this combination in xml. i tried this code : <Field Type="Calculated" DisplayName="$...
1
vote
0answers
21 views

Disable field name localization

I'm using a SharePoint team site in an international setting, and I would like the entire site to be in English. Unfortunately, when some columns titles and descriptions were changed, these changes ...
1
vote
2answers
2k views

How do I create a choice column with integer values?

According to MSDN "You cannot create integer base-type choice fields". Is there a workaround for this? If I wanted a integer field with a set of possible values I could use a Number column and a ...
2
votes
3answers
15k views

Missing fields in the NewItem, EditItem, ViewItem forms

I am using sharepoint 2010. I have a document library. This document library has no content types. It has directly 5 columns. When I go to this document library I see the allItems view and shows all ...
2
votes
1answer
136 views

How was a user able to enforce a unique value for a choice column?

I have a document library with a choice column with possible values. In library settings, I have selected 'No' for both 'Enforce unique values:' and 'Allow 'Fill-in' choices:' A user was still able ...
1
vote
2answers
6k views

Show year and month only on a Date column

I have a date/time column. How can I show year & month only on this column (entered automatically is preferred) Essentially I am making a full digit out of the year and month and sorting it from ...
4
votes
2answers
2k views

Hide “add column” in Sharepoint 2013 List

Is there a way to hide the last column which is always the "add column" (with a little "+" sign in it)? I have changed the "management of content types" to "no". I cannot (do not have access to) use ...
1
vote
2answers
52 views

Custom Column data

I am trying to create a script that will iterate through specified site collections and find all files which have a specified data in the custom column named for eg. colours. in this coloumn it's a ...