Questions tagged [column]

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

Filter by
Sorted by
Tagged with
0
votes
1answer
33 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
22 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
4answers
3k 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
534 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 ...
2
votes
3answers
1k 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
409 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
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
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
65 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
vote
1answer
82 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 ...
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
1answer
1k views

Yes/No field in JSON view formatting

This is about JSON formatted views (not columns) in modern SharePoint online. List A has a Yes/No field. The values show as Yes or No in the view. When I format the view and show the field value ...
0
votes
4answers
54 views

Add a Document - SharePoint Online || Deos not display the recently added column to the List

Looking for a way to add existing newly created column called Business Area which is a choice based column to add a document form in SharePoint Online. This form appear when I try uploading a ...
0
votes
1answer
30 views

How to convert documents to Base64

It would be awesome if we could convert documents (word, excel, PDF, images) to base64 and then store the value in a column. I would love to automate this if possible. I know it is possible with flow, ...
1
vote
1answer
24 views

Page Layout field

I need some help to update a field in page layout. I don't have much information but I am trying my best to explain the issue. In our page-layout we have a hidden field for the owner to choose to ...
0
votes
0answers
21 views

Sharepoint List - Quick Edit adding a text box

I'm a SharePoint neophyte without admin access. I'm experiencing an odd problem when editing items in a list. I have a column set to 'Multiple lines of text' and Enhanced Rich Text. If I edit an item ...
0
votes
1answer
24 views

SharePoint 2013, Column Ordering doesn't seem to be working

New here. Just started working in SharePoint 2013 to manage various project docs and due dates for my team. I set up a list using the Import Spreadsheet app that had the column headers ordered in a ...
0
votes
1answer
73 views

SPO How to set permission for a specific column in a list?

I have a list contain 3 columns: Ex: A,B,C The Admin can create/edit and delete all columns. My requirement is: The invited user can also create/edit and delete except of column C. He can see it ...
0
votes
2answers
248 views

In a library, I find a column called TAGS, what is it?

While playing around, I noticed a column appearing among the available ones in the view settings called 'Tags'. I have displayed it and the image inside the library (of a person) showed the tag '...
0
votes
1answer
53 views

Value of the Yes/No Column

What is the values of the Yes/No Column in SharePoint? 1, 0 Yes, No "Yes", "No" True, False Trying to use calculations: =IF([Col1]=Yes, 1, 0) So if it's true, put 1, else 2. But not matter what, ...
0
votes
1answer
273 views

Show/Hide in New form based on dropdown selection jQuery

I have a dropdown list contain values, last value is called "Others" when its selected i want to show a new textbox under the field and if its not selected it should be hidden. I have followed this ...
0
votes
1answer
147 views

Powershell script to update list column from another column Conditional

Any help is greatly appreciated. Here is the scenario: I have a powershell script which I am using from another post on stackexchange. I have two fields in a list, the script copies the value from ...
0
votes
1answer
124 views

Conditional validation of SharePoint Online column

I am trying to validate a SharePoint online task list column, in the way that the column "Assigned" (People column) must be populated for the user to be allowed to save with info in "Due date" (Date/...
0
votes
0answers
88 views

Reset column to default value

Given is a list with a yes/no column. Default value of this column is "no". What is the most efficient way to reset all items in the column to "no". I definitely don't want to solve the problem by ...
0
votes
2answers
22 views

Calculated Column with IF ISBLANK, else if “ABC”, then return “XYX”

If [OH:Subsample ID] is blank, OR if it contains "ABC", then the calculated field should return result "XYZ". No idea how to put that into syntax. I can get two separate lines, but can't get them ...
0
votes
1answer
21 views

Delete column from content type doesn't work

This is the code I use: Add-PSSnapin "Microsoft.SharePoint.PowerShell" $web = Get-SPWeb "Myshareointsite/Projects/Test" $list = $web.Lists["Risks"] $ContentType = $list.ContentTypes["Item"] $...
0
votes
0answers
78 views

Managed metadata columns show numbers instead of terms in document libraries

In Sharepoint Online, when I open a document library that has managed metadata columns, everything looks fine. However, when I preview a document and close the preview, the managed metadata terms are ...
1
vote
1answer
25 views

Is there the capability to store a number range within a column?

I am trying to identify the best column type to store a selection of number values and ranges of number, e.g. 10,000-20,000. A majority of the values will be individual numbers but some need to ...
0
votes
1answer
79 views

Referencing 'Version' Column

Hi there, I am relatively new to using SharePoint as well as JSON and as mentioned in the subject, I am having issues in trying to reference the Version column (set by the approval status). What I ...
0
votes
1answer
68 views

Get List Column configuration using pnp.js

I want to fetch the List column configuation to check if a field is required or not. But I am not able to figure out which function to use by looking at the documentation.
0
votes
1answer
52 views

How to create a lookup field from another lookup column

I have one lookup column. I need to create another lookup column to look up the existing lookup column in different lists. I am notable to do this, Could you please suggest some idea to implement the ...
0
votes
1answer
79 views

mandatory lookup column doesn't work

So I have a pretty basic scenario. Two lists (Projects and Clients). In the Projects list I have a mandatory lookup field that aims at the Clients Title column. Now when I fill out the form for ...
1
vote
1answer
17 views

Adding columns to an existing list on Sharepoint 2010 intranet

I am trying to add two new columns to an existing list on an intranet page (on SharePoint 2010). I've used the guidance here and seem to be able to only get so far. I've found the list I want to add ...
0
votes
0answers
62 views

Set dynamic default values for SPO list with custom new form

I have a SP Online list with custom new form. I want to update default values for 3 columns dynamically using the URL and make the columns ready only. For Eg, I have the below URL: https://company....
0
votes
1answer
29 views

How to programatically get the status value of a Content Type column using C#?

I am attempting to read the property of the Item content type which shows the Required, Hidden or Optional property for a particular column. if (spList.TryFindContentType("Item", out SPContentType ...
0
votes
2answers
45 views

Hide items in a form

Recently, I see this function broken in SharePoint, I do not set it. Please help me. To begin, Go to List Settings. Click on Advanced Settings. Select Yes on Allow management of content types. ...
1
vote
0answers
8 views

SharePoint default Column values are added to all documents of a library even if the specific contenttype does not includes the column

in our document libraries documents are assigned to different contenttypes. These contenttypes share some columns but not all. If we now define default values for a managed metadata column, all ...
1
vote
0answers
23 views

Add “Select All” (similar to “clear all filter”) option from the column header

I need to click "Select All" under any column (similar to "Clear all" button on Column Header menu ). It should select all values of column. Can it be done using Script Editor? What script would it ...
1
vote
2answers
138 views

Call a flow if a Date column is null

I would like to use a If condition to execute a different flow. Everytime the column "Aprovado Interno" is null calls one flow, else calls the other. However I am having difficulties to apply the ...
0
votes
0answers
39 views

SharePont 2016: How to make “Creator” column UNIQUE

I want to enforce unique values for "Created by" column. the "Created By" column unique. When I have to add a new element and an item really exist in the same "Created By" list - it shows an error ...
1
vote
2answers
87 views

SPFX rest call response seen in network tab but I cant read it on console

I got an issue I'm doing a rest call to get columns of a list, the call success because I can see the response in the network tab of the developer tools, here is a picture: for some reason when I try ...
1
vote
1answer
400 views

Display a calculated Timestamp when a particular choice is selected (Sharepoint list)

I would like to create a calculated column that displays the timestamp (mm/dd/yyyy) when a choice was picked from another column. The column in question is named Assessment Status and the choice that ...
0
votes
1answer
13 views

Change Column Type On Move

I'm working on creating an auto-archive process with the information management policy settings. I managed to get it to work for the most part but hit a snag when trying to move a document set which ...
1
vote
2answers
108 views

Error while hiding field in Edit form SharePoint Online document library

I am getting error message like : Exception calling "ExecuteQuery" with "0" argument(s): "The node to be inserted is from a different document context." Can anyone suggest what I am missing here......
0
votes
1answer
61 views

Get a document modifiedBy in JAVA with RestApi

As you can see in images, I have some folder in my document library. I wanna reach the files in the folder and take the "modifiedby" column and change it with java-rest api. I can reach the file ...
1
vote
1answer
42 views

Mutiple Choises in Custom Coulmn

I want to create a custom column that has the option to check/mark two or more options. Example Column Name : Sorting_Files: ,Department ,Planning ...
0
votes
2answers
492 views

What will be the rest api query to get field values from site content type using rest api?

How will I fetch choice field values from site content type directly> This is what I have tried: http://<sitecollection>/<site>/_api/web/contenttypes
0
votes
2answers
74 views

Formatting Lost When Creating List Item

I'm trying to create a list item but the most basic formating is being removed from the input. Field type is Multiple lines of text and I've tried using Plain, Rick and Enhanced. Script to create ...

1
2
3 4 5
21