Questions tagged [column]

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

318 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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
4answers
51 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
26 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, ...
0
votes
0answers
19 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
2answers
111 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
0answers
57 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
20 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
0answers
70 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 ...
0
votes
0answers
14 views

How to only show specific columns in external list picker

How would one use an external list containing several columns to map each column in the external list to a drop-down control in a SharePoint List item? In the picture attached, how does one take each ...
0
votes
1answer
68 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 ...
0
votes
0answers
48 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
0answers
78 views

Custom List Grouped Columns - Default Collapsed Not Working

I hope someone can help with the following: I have created two separate custom lists. Both lists are grouped by individual columns, with the groupings set to 'collapsed' by default. The first list ...
0
votes
0answers
32 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 ...
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 ...
0
votes
1answer
43 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 ...
0
votes
0answers
149 views

Cant Delete Field in SP Online List

The event content type was added to my list, I've removed it and disabled content type management on the list. I was able to remove all columns brought in with the event content type, except the "...
0
votes
2answers
376 views

Make a column auto update by Parent Folder Value

I am setting up a new Document Library to organize several different types of Documents. I have a Folder View and a Metadata view. I am using a column named "Section" to sort the metadata view. I ...
0
votes
1answer
28 views

Fields are in different language in view vs in new/edit/display form

I have very strange SharePoint 2010 behaviour. Basically I have SharePoint site in 2 languages, default is English and there is German. So when I change my language to German then there is everything ...
0
votes
1answer
43 views

Content type fields marked as “hidden” aren't being hidden in the form?

I have a SharePoint Online list library which allows users to create a list item by using a simple form. In the backend of this site I've configured some hidden columns which are needed for some ...
0
votes
1answer
17 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
85 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
76 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 "...
0
votes
1answer
220 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 ...
0
votes
1answer
347 views

Invalid Field Name error when creating Sharepoint page

I'm trying to create a new Sharepoint page but I am getting the following error: Invalid field name. {50631c24-1371-4ecf-a5ae-ed41b03f4499} .../Pages TECHNICAL DETAILS Troubleshoot issues ...
0
votes
1answer
156 views

Verify Date Selected Is atleast 3 Business Days Away

We have a SharePoint site that we use to schedule customer appointments. These appointments need to be scheduled on a weekday and need to be at least three business days away, but no more than 45 ...
0
votes
2answers
26 views

SP Folder Status Indicator

Would it be possible to create a column on a SP folder as a status indicator i.e. review completed. Thank you.
0
votes
1answer
37 views

Cannot Remove Field from Sharepoint AddIn

I have a provider-hosted SharePoint Online add-in project. In this project I have added a lookup field with name CaseLawyer and deployed the app in the site. After that, I have deleted this field form ...
0
votes
1answer
473 views

Using JSON data bars Column formatting for text (stages)

I am looking at using column formatting to allow us to easily identify which stage a project is in. In SharePoint online using modern views. We have 4 stages and would like to have a 25%, 50% 75%, ...
0
votes
1answer
27 views

Bring list Column headers back

Following a great tip from How can I get rid of the columns header when the style 'Boxed' was selected? I was able to hide all the column headers and everyone was happy! Until of course ...
0
votes
2answers
17 views

What validation code should I use such that if any Column entry is changed it shows an error ?

I'm basically trying to keep 5 columns of my list locked(uneditable) while the last column editable. I'm a beginner and thought this would be the easiest way to achieve this. Do kindly suggest any ...
0
votes
1answer
15 views

Truncate with a twist

I've been browsing this site for two days now with no avail to my problem. I have a SharePoint 2013 on premise site with Designer Workflows only. This site for reasons I cannot go into is very ...
0
votes
2answers
199 views

sharepoint API rest custom column http 400

I have a list in sharepoint, where I have put the totals of the columns I am interested in. ID Count=50 Certification Count=9 I want to display these counts on another page. I have found a code to ...
0
votes
1answer
273 views

Disable fields based on choice *that may have multiple choices*

Is the title weird-sounding? It is to me. But, here's my situation: I would like to disable (in some way, greying out, or whatever) certain fields in a list based upon a CHOICE field I've got at the ...
0
votes
2answers
35 views

Creating fields that are automatically populated based on the value in a Lookup column

I have two SharePoint lists. List #1 contains "static" information such as project number, geographic location, region, and planned inspection type. List #2 is a list that I want to use as a way to ...
0
votes
1answer
80 views

JavaScript on SharePoint list

hope you're well; What is javaScript code to add on SharePoint list for showing a few lines of text per row so they all the same size where reams of text have been written this is via scroll or ...
0
votes
1answer
62 views

Missing Lookup Column Including Search Form

I was trying to create new lookup column with search form in sharepoint online (365), but the lookup column with search form is missing. i want to ask, how to add lookup column with search form? as ...
0
votes
1answer
25 views

Conditionally Trigger Column when creating Calendar Events

When creating an event in a calendar, I list 4 standards for the creator to choose from. I want the chosen standard to then trigger a drop down of locations for that standard. Can I do this? For ...
0
votes
1answer
660 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
77 views

How to change like column for list layout Sharepoint

I implemented the like feature on a test column I have but I noticed the icon linked to the like is a little hart. I want to change that hart to a thumbsup or another icon. How can i do that? I would ...
0
votes
1answer
28 views

Sharepoint Email

I want a daily email to be sent that contains either the items contained on particular list view on that day, or that contains items that has a date format field set as that days' date. (Note that ...
0
votes
1answer
176 views

How to create a lookup column with Site Design for modern sites

As per the MS article i have created site design file and uploaded to SharePoint which is working fine. But I want to create a lookup column with the site design approach. I am using below code to ...
0
votes
0answers
240 views

SharePoint Online rename list column title

I am trying to figure out how to rename a list column on SharePoint Online, for example I would like to rename the column "Category2" to "Category". I have seen JS examples of doing this on SP2013 ...
0
votes
1answer
33 views

People and Groups List Column Not Appearing in List Web Part

I have one main list called "Employees". A field on the new item form is a people and groups field. On one site page I have added 2 of the employee list web parts, one is filtered. My issue is that ...
0
votes
1answer
61 views

Document Library “Modified By” metadata disappears after 2-3 seconds

I have a SharePoint Online site with one Document Library and would like to see who last modified files/folders. Once the page loads, all the metadata displays properly but 2-3 seconds later, the ...
0
votes
1answer
31 views

Hiding fields in Sharepoint list view no longer working since a few days

Several months ago I've implemented a solution to show icons instead of textual status values and it's been working fine since. However, since a few days, I still see the icon instead of the text, but ...
0
votes
0answers
754 views

Formatting column making the column text to disappear in latest Sharepoint online

Formatting column with JSON makes the column text to disappear in latest Sharepoint online. E.g. if I try to use something like that: { "elmType": "div", "txtContent": "@currentField" } saddenly I ...
0
votes
2answers
456 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 ...
0
votes
1answer
274 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
27 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 2 3
4
5
7