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

3
votes
1answer
619 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
141 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
114 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
2k 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
22 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
642 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
387 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
694 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
762 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
56 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
632 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
678 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
97 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
737 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
10 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
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
791 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
769 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
729 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
24 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
73 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
268 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
600 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
33 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
22 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 ...
0
votes
1answer
171 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
30 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
35 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 ...
1
vote
1answer
935 views

Link list URL fields do not display when using FieldRenderingControl

I'm creating a custom New Form for a Link list. Depending on the view depends which columns are displayed. for(int i = 0; i < spView.ViewFields.Count; i++) { ...
1
vote
2answers
48 views

How can I locate a missing column in my List Settings?

I have a SharePoint Online list that has recently grown to over 5000 items. Here is what a given entry looks like on the AllItems view, with the column I'm interested in circled in red: When I go to ...
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 ...
0
votes
0answers
15 views

Sharepoint List - How to use various field types in JSON (column formatting) [duplicate]

Some data from other fields can't seem be referenced when using JSON to format Sharepoint List columns. What is being done wrong? For Person fields "@currentField.title" Works "@currentField....
0
votes
0answers
419 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
2answers
6k 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 ...
4
votes
1answer
61 views

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

I´m trying to check the value of the column "CheckoutUser" with json. ""style": { "min-height": "35px", "margin-top": "6px", "display": "=if([$CheckoutUser] != null, 'block', 'none')" }" ...
0
votes
2answers
24 views

Is it possible to create a column with two types? [closed]

Is there any possibility in sharepoint to create single column which will have both single line of text and choice as column type? Please suggest if possible.
0
votes
1answer
17 views

SharePoint 2016 - Column Settings missing from column header drop down

I'm using SP 2016 and am trying to access the column settings. I've read you click the dropdown next to the column heading and it should show up... however all I get are the filter options. Do I need ...
0
votes
0answers
21 views

Creating a view where only certain columns expand/collaps

Im busy with a SharePoint site where i need to display member of the team on a page, i want to be able to show all the team members(each of them have an entry in my team members list) but i want some ...
1
vote
0answers
23 views

SharePoint 2013 bulk edit column not updated

When selecting edit list, select the column, the choices are not updated from the lookup list. But if you edit an individual item the lookup choice is available for a selection. How do I get the ...
0
votes
0answers
15 views

Trying to Get Average of a Column in SharePoint - But One Row May Contain Multiple Counts

Ok so getting the average means dividing the sum by the count. Meaning I have a column with a count of 7 rows of numbers that all add up to the sum of 10. So I divide 7/10 to get 70%. Using a ...
2
votes
2answers
26 views

SharePoint IF calculation needed to consolidate columns

Looking to solve this issue IF Brand = A, B, C or D, then 'Special Brand'; otherwise (Brand = E and) if Buying Status = 1 or 2, then 'Top Tier'; Otherwise 'Bottom Tier'
0
votes
1answer
36 views

Bulk edit for large number of files not working?

I'm on Sharepoint Online, and I have a document library of about 1600 files. I have about 1000 files that are Unassigned in a certain column that I want to change from Unassigned to some other ...
4
votes
1answer
189 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 ...
3
votes
1answer
2k views

Display more fields in Discussion Board SP 2013

Can anyone tell me which function or part of the code I have to override from SP.UI.discussion.js to display extra fields in subject view of discussion board? Other than the fields it has OOTB.
1
vote
1answer
23 views

Hide columns in spreadsheet/edit view (JS/jQuery/Cisar)

Hiding columns in normal view is ok using either of the functions: function hideColumn() { var header = document.querySelectorAll("[displayname="Column Name"]")[0].parentNode; var index = [].slice....