Questions tagged [column]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
708 views

How to change list column that is defined as multi-line to single line input

I have imported an excel document into SharePoint 2010. One of the columns was automatically defined as being multi-line, but I want it to be single line input instead. I have looked at redefining the ...
3
votes
1answer
704 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 ...
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? { "...
0
votes
1answer
677 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
898 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
39 views

Can't get Organization Name from AD

Good day, I have a question with getting user profile data from AD by JavaScript for SharePoint Display Form. I can get user Department by script: <SharePoint:ScriptLink ID="ScriptLink2" name="SP....
0
votes
1answer
843 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
13 views

Create columns for each month

I need to create a forecast list where users can enter the projected number of staff for each project. Rather than manually entering the columns for each month, is there an automated way of creating a ...
0
votes
2answers
1k 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
702 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 ...
2
votes
1answer
639 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
752 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 ...
1
vote
0answers
23 views

Setting person column with workflow

I am using a reusable workflow to collect feedback on a document. One of the initiation form parameters is "owner" with the "person or group" information type. I am trying to get the "owner" parameter ...
1
vote
1answer
25 views

Can I use a list workflow to make changes in two different lists in SPD 2013

I want to know if I can use List workflow rather than the Site Workflow to make changes from one list to another if something has been changed or do I need a site workflow to achieve this? I also ...
1
vote
1answer
1k 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 ...
0
votes
2answers
3k views

Save to a People or Group column using SP 2013 REST API by login name only (without the ID)

This question will be a duplicate of this one (which has no accepted answer). I am trying to save a SP 2013 list item using the REST API. One of the columns is a People or Group column. Normally ...
1
vote
0answers
28 views

Help with auto calculated field for dates from another column [closed]

I am trying to make a column with expire dates from a date entered in another column. For example I have a column with a date entered for training. I then want another column named expire date that ...
2
votes
2answers
31 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'
1
vote
1answer
51 views

Columns doesnt count right

So I got this example: The green value should show 01:00:00 but it doesnt. I think the formula I got "ROUND" it somehow (I got the code online). And I need this code so the value can exceed 24 hours. ...
0
votes
0answers
10 views

Validation settings acting weird

So I got this problem with validation settings on a sharepoint list.. I use the formula below and it kinda works. I cant choose "tekniker klar" and save the form if I havent filled in these columns [...
1
vote
1answer
674 views

Field names in announcement list in Sharepoint Online

I am trying to add fields to an announcement list. I have successfully added various fields with single-word names: announcementy.Fields.AddFieldAsXml("<Field Type='User' DisplayName='CreatedBy'/&...
5
votes
4answers
5k views

Show Modified and Created columns with Date only

I'm looking for the best way (if there is one) to show the Modified and Created columns in a list/library with the date only, so without the time. For example, instead of 1/12/2011 8:37 PM it should ...
0
votes
1answer
2k 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....
1
vote
0answers
20 views

I am trying to make a value limited RSVP System

I have been tasked with creating a list in SharePoint to let users pick one of three training sessions. Each training session must be limited to 50 users. I've been leaning towards a list with a ...
0
votes
2answers
697 views

Field not found exception

I have an ASP.NET Web Service (ASMX) and a class for working with lists (CRUD operations). Web service's method calls method (retrieve item from list) from CRUD-operations class and then I recieve an ...
0
votes
2answers
38 views

I would like to insert another =IF in this formel

I would like to insert another =IF in this formel, for example: =IF it says "Hello" I want the text to be the color green. Is that possible? { "$schema": "https://developer.microsoft.com/json-...
3
votes
1answer
81 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 ...
1
vote
1answer
139 views

How to add list column to list content type via SharePoint online PowerShell?

I'm trying to add some custom property to list content type at SharePoint Online site by following script: $context=New-Object Microsoft.SharePoint.Client.ClientContext($URL) $context.Credentials = ...
0
votes
1answer
702 views

Spservices autocomplete with many columns

Could somebody advise how can I make autocomplete for multiple columns, currently I'm using it for one column: $().SPServices.SPAutocomplete({ sourceList: "My list", sourceColumn: "Email", ...
2
votes
1answer
4k views

Making column required is only possible after it is added and edited (happens in content type only)

While creating columns in content type the option of Require that this column contains information is disabled so I cannot make the column required. But once I save the column and edit it I am able to ...
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 ...
0
votes
1answer
90 views

Insert bold in column formatting

How do I insert code so this will also become Bold? { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", "elmType": "div", "debugMode": true, "...
2
votes
3answers
54 views

How to write internal column names to host

At the moment I m trying to use this: Add-PSSnapin microsoft.sharepoint.powershell #Get Web $web = Get-SPWeb http://... #Get List $list = $web.Lists["List1"] $list.DefaultView.ViewFields | Write-...
0
votes
1answer
31 views

Copy user field value to SharePoint online site

I have a user field in a list that has allow multiple user setting on. ie I can have more than one user in the field. I am trying to copy my User field data form on prem SP2016 site to online site. ...
4
votes
0answers
111 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 ...
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 ...
0
votes
1answer
31 views

SharePoint column fill notification in SharePoint designer 2013 Workflow

I am using SharePoint designer 2013 and want to notify certain people if a specific column in the list has been updated by someone. I simply want to know what can I use in the stages so that it can ...
0
votes
1answer
20 views

Column validation user message pops up for millisecond

So I got this column validation: =[Sleep]>TODAY() And user message "NO". And it works, I cant put a date back in time, but the user message "NO" is just popping up for a millisecond, someone knows ...
0
votes
1answer
21 views

When adding an item, will deleting the coloumn where we add new data, will it delete the previous data already entered in the records

I have a share point website with a list and important records. However my manager told me to amend the columns, as it's type has also to be changed to choice from Azure AD rather than the single line ...
2
votes
1answer
612 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 ...
1
vote
1answer
2k views

Infopath 2013 validation error message about a missing field

Currently testing a Sharepoint list form customized in Infopath. Once I've been through the whole - long- form in Sharepoint, and click on 'submit' the form returns a message error that reads: ...
1
vote
4answers
2k views

The “_x0020_” of the Internal name for a SharePoint column

I am currently doing documentation for our SharePoint Applications. For the purpose of explanation/definition, What is the "x0020" portion of a SharePoint internal name for a column? I'm not sure if ...
0
votes
1answer
347 views

Get value of Name column from SPO list for JSON formatting

First of all, apologies if this horse has been beaten before but I can't find anything so far to help me out. I'm trying to do some conditional formatting of a column in a SP list. One of the ...
1
vote
0answers
32 views

Problems with exporting a list to Excel

I have modified my view and selected just the columns that i want to show. But when I export the content to excel I can see more columns. (In my nomal view I am not seeing them, just when I export it ...
2
votes
3answers
840 views

Change the Yes/No Column Type into a Checkbox for a SharePoint Online List

I am having trouble trying to find out how to change the Yes/No Dropdown to a Checkbox while in quick edit mode. I am on a SharePoint Online list and have tried a few different things without any luck....
0
votes
1answer
130 views

Is it possible to recover a deleted column from a list in SharePoint 2013?

I accidentally deleted a column from a list that contained a lot of entered data. I have no backup of this data, is there any way to recover?
1
vote
1answer
81 views

If calculated value column exceeds 24 hours

I got this calculated column that shows values of "hh:mm:ss". But i've noticed that if its exceeds 24:00:00 it will restarts to ex. 01:00:00.. Is there any way to make a validation or format the ...
0
votes
0answers
11 views

Creating a Date Column to display in the “Friendly” Format

I'm confused. I have a column "Date Chart Requested" and at first it did display the dates as "5 days ago" which is exactly what I want. But after further tweaking of the custom list, it no longer ...
0
votes
2answers
49 views

SPO How to Hide column on Display form for specific group permission?

I want to hide a column for a specific group permission on Display form. I have found a jQuery code and I have tried to use it but the column still visible to the user that is on this particular ...
1
vote
2answers
62 views

SPO: Display column only on Edit Form

I have a column called "Comments", i have hide this column to appear in New form. But i want to make this column appear on edit form so i can see the related comments of the approvers and the "...

1
2
3 4 5
21