Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [column]

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

2
votes
1answer
1k views

Amending the Calendar form in Sharepoint 2013

I have a question about the Calendar app. I made the Location field compulsory from the Validation settings and a red warning message appears, when you try to save an event without its location. How ...
0
votes
1answer
192 views

Field Internal name changing when added to list?

I am having a very strange issue with the internal name of a site column. I created the column, added it to a Content Type, then created a list based on that content type. Somewhere along the way ...
0
votes
3answers
634 views

column validation against another column

i have a column called Loaned, dropdown (yes or no). If the user uses 'yes', then there's a "Return date" field below which will require them to put in a date. Is there a way to validate that if they ...
0
votes
2answers
32 views

Date validation to specific year for list Column in view

I've got a date column in a view and I'm using a validation formula: =IF(TEXT([Data documento],"yyyy")="2018",TRUE,FALSE) So that users can only insert date within the year 2018. I always get an ...
0
votes
1answer
610 views

Inadvertently Created Content Type Column and now can't delete it

I created a column on my root site's content type and now cannot delete it. It is somehow locked as "Read Only" and I have tried PowerShell and SharePoint Designer 2010 and every option I could find ...
4
votes
2answers
106 views

Is there a tool that helps with Modern UI column formatting?

It seems like the new column formatting JSON-based solution is much more inferior in comparison to the old client-side rendering with JSLink. I am mostly talking about dev experience. For example, ...
1
vote
1answer
17 views

Highlight Due Date Column with color

I am using SharePoint 2016. There is a Submittal library that has been created and one of the users would like the "Due Date" column to highlight in yellow when a document that has been submitted is ...
0
votes
1answer
25 views

Column Formatting Option not available

I can't see an option for format column where I can enter JSON codes.
3
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?
0
votes
2answers
618 views

Force “Name” field in SP13 Library to be equal to '“Title”

As I understand, SP13 searches documents by document Title. When you upload some document to the library, you have to fill in "Name" and "Title" ( the same field twice). What I want to do is to ...
2
votes
1answer
610 views

Using Office 365 Distribution Groups in a SharePoint column or workflow?

I am creating a document template library which is going to email our users when we upload a new template (powerpoint, word, etc). I am hoping to send this email to distribution groups I've already ...
0
votes
2answers
607 views

Columns not displaying value

I've added some columns (name, ID etc ) to the document library after the documents have been uploaded, and got no value displayed. Is there any way to fix this or I'll have to recreate the library?
3
votes
1answer
614 views

Add Rich text column to the Blog Post comment (SharePoint 2013)

I am trying to customize the Blog post comments in SharePoint 2013 by adding a new custom column using RichText (called RTBody) and hiding the old one called Body in several pages, such as Post.aspx ...
2
votes
1answer
13k 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 ...
1
vote
2answers
52 views

Can we create a look up column from multiple lines of text column in list

we need to create a lookup column from multiple lines of text column in SharePoint online list is it possible.
19
votes
3answers
4k 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 :...
0
votes
1answer
77 views

Column Formatting using JSON: Get value of the column “_ModerationStatus”

I'm trying to check the value of the column _ModerationStatus in a document library with that has content approval. I have the following JSON: { "$schema": "https://developer.microsoft.com/...
0
votes
5answers
1k views

Change column color of a list webpart

We have a landing page that consist of a scheduled maintenance list webpart and we want to have a color coded background for a column. For example: In Progress = Red Completed = Green I tried the ...
1
vote
3answers
8k views

How to remove “created by” on SharePoint blog post item?

I recently created a blog site and posted few blog posts but then I realized that "created by" column is showing on the item. I tried to check what page layout a post is using but I simple found ...
0
votes
0answers
16 views

Character Limit for Approver Comments Column Type in sharepoint.com O365

In sharepoint.com document set library, I am trying to add approver comment when I change the approval status. The comment supports up to 2414 characters, and when I enter more characters, it throws ...
0
votes
1answer
631 views

How to refine search using existing Site Collection columns

I want to refine the search based on existing site collection columns. How i do that: Any suggestion or good article on this topic. As i am pretty new to search? My requirement is that, my client is ...
0
votes
1answer
336 views

Column formatting changes not saving

For my document library on sharepoint online modern view, I have a column for Title. I've tried to format it so that the height changes dynamically based on how long the title is and when I save it at ...
0
votes
1answer
681 views

Saving Publishing Page in edit mode returns “Are you sure you want to leave this page?” dialogue

we're getting some ... interesting ... behavior in IE. Setup We have a page layout based on some content type. Both contain (besides other fields) a DateTimeField which is shown in edit mode. When ...
0
votes
1answer
706 views

Locking Sharepoint column after data is input

How can I lock a column (in a list) from further changes after it is initially populated? I want to lock down the "initial due date" and only allow changes to a "revised due date" column so we can ...
2
votes
1answer
48 views

Update SharePoint Online item build-in fields via Microsoft Flow

Is it possible to update SharePoint Online build-in fields (like "Created by") by using Microsoft Flow? When creating a new flow and using step "Update file properties", I can only select values to ...
2
votes
1answer
631 views

How do I configure required columns on Wiki pages?

In a SharePoint 2010 Wiki page library, if I add metadata columns to the page library, something like "Category" and make it a required column. When I go and create a new Wiki Page in that library I'...
0
votes
1answer
655 views

Efficient way to get all the field (column) values in an array from SharePoint List

I have to get all the field (column) values in an array from a SharePoint list. Right now I am looping through all the items in the list and creating an array. But it is very inefficient if I have ...
0
votes
1answer
30 views

How to hide a List View column in Modern SharePoint

I have a List in a SharePoint Online site that uses the Modern experience. I want to hide a column, but need to stay in Modern. The easy way I found was inserting a few lines of Javascript in a Script ...
0
votes
3answers
1k views

How can I sort this by an actual DATE?

I have a calculated field in a document library that takes the "Modified" property makes a more readable date from it. The problem is, the column is now sorting alphabetically, even though the data ...
1
vote
1answer
702 views

Add a separator between certain columns on New/Edit Form on SharePoint 2013 OOTB

I have the following modified version of Curtis Weir's field hiding script from dmcinfo.com which I want to run using the SharePoint OOTB Script Editor: <script src="//code.jquery.com/jquery-...
0
votes
0answers
8 views

Person/Group column displays empty in web part view

New view is created with the person column. I can see the values in the view, when opening view on its own. However, the same view is added as a webpart and the person column is empty. However, when ...
0
votes
1answer
738 views

List that I've created is defaulted with “Stop editing this list”, want to make it so it defaults as “new item or edit this list”

One of the lists I've created is defaulted with this interface: I want it to be able to default with "new item or edit this list" instead as such:
0
votes
1answer
14 views

Column Validation in 2010

I need to use a column to capture ID numbers. I need a way to ensure that the answers entered are only numbers and exactly 12 digits in length. I've tried a zillion different formulas but keep ...
0
votes
1answer
778 views

How can I make sure that if linebreaks is inserted inside a multiline textbox it gets displayed like it

I have a field that looks like this in my schema: <Field ID="{7662cd2c-f069-4dba-9e35-082cf976e170}" Type="Note" RestrictedMode="TRUE" NumLines="15" Name="Body" DisplayName="$Resources:Project....
0
votes
1answer
745 views

Find out who added a column to my SharePoint 2013 library

We're trying to find out who added a specific column to our library. I can see some info about the fields via the REST API, but not exactly what I wanted at the level of who created the column: http:...
0
votes
1answer
724 views

Can field in form autopopulate based on other field's drop down selection? Both fields are from the same list

I have a form that's pulling in items from different columns of this list:![List][1] On the form, you have the option to select Job Title and, later on the form, Systems Access, ![Categories][2] Since ...
1
vote
2answers
1k views

Workflow: how to UNSET (or set to NULL) a date/time type value in a custom column?

Trying to build a workflow that clears a date column when the task "Completed" box is unchecked. Have tried several different approaches but have not gotten anything to work. The workflow completes ...
0
votes
0answers
23 views

PWA Project columns

I have setup the columns that I want to see in each new project in PWA. For example: Task mode, Text 1, Task Name, Start, Finish, Duration, Work, etc. When I create a new project in PWA, those are ...
0
votes
0answers
67 views

List people picker graph

I am pulling a list via the graph api. I would like to be able to filter on a people picker field. However I do I use the lookup field id to equate to a user/member i.e the id 18 person joe blogs.
1
vote
3answers
135 views

Retrieving column fields from SharePoing list using sp-pnp-js

I have a list. I want to retrieve the fields to see how many column are there in my list. For example, my list name is TestList, I have created 5 columns of different datatypes. I want to retrieve ...
-2
votes
1answer
584 views

Specify field to apply .css style

I have a field in SharePoint list. I am trying to apply a background color in the display form. Name of field is Process Instruction. I am having trouble with the .css syntax. It Works fine in IE ...
0
votes
1answer
23 views

Sharepoint 2013 - how to make a column content bold in task list

I am struggling with making any content under the 'Task Name' column in bold. I am using Sharepoint 2013. I have a task list (classic) and I want to make each task name in Bold. I would like to add a ...
0
votes
0answers
17 views

Changing the filed type from “checkbox” to “Radio Button” has overridden the “ShowInNewForm” property

We have a sharepoint on-premises farm 2013. I have a choice column which display the choices as check-boxes and it contain one option only, as follow:- but doing so have caused issues when filtering ...
1
vote
1answer
799 views

how to change the format of the “person or group” column

In my document set (Sharepoint 2010) I have a column with type of “person or group” which I can add the name of some users to it. The format of the names is like this: firsName1 Surname1; firstNmae2 ...
0
votes
1answer
794 views

Deleted “Resources” Column and now site gives error

I've deleted the Resource column in my calendar list and now, when I have Use this calendar to share member's schedule checked YES, I get an error: Unable to retrieve 'Resource' field from the ...
0
votes
1answer
850 views

How to hide specific column header in a list WebPart?

I created a webpart with URL column header, but i want to hide it for users...i know i can hide it using CSS but it hides all the colum headers in other webparts, Any solution to hide only the URL ...
0
votes
2answers
857 views

Create Custom People Picker Column in SharePoint 2013

I want to create custom Person or Group type of field which is mapped to User profile.when we add user name to that field then auto fill other columns like first Name,Last Name,Email,Work phone. In ...
0
votes
1answer
84 views

SharePoint Online Show/Hide column based on permissions

I have a couple of fields in a list that can only be modified by certain group of people. What is the best way to do this without a 3rd party application?
0
votes
0answers
25 views

column options in sharepoint online list

For a list i created in sharepoint online: On some of my columns, the drop down arrow only shows "column settings" While other columns show "A to Z", "Z to A", "Filter by", "Group by Contact" and "...
1
vote
1answer
34 views

Need advice on proper use of calculated column for my problem

I've been tasked with getting a SharePoint site up and running as part of my job, it requires a semi-automated way of marking files for an archival process where they are taken off of the SharePoint ...