Questions tagged [column]

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

306 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
2answers
320 views

Site column validation - not allow to use slash / backslash / questionmark / \?

Got a script that creates new site collection based on a template (clone site collection). Problem is that some users type in slash / backslash in the title site column, that makes the url wrong. ...
1
vote
0answers
320 views

Create document library with look up and multi line text box feilds using powershell

Create document library with look up and multi-line text box fields using the below PowerShell Remove-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue Add-PSSnapin Microsoft....
1
vote
0answers
745 views

CSOM retrieve List Item doesn't show some Lookup Key Value pairs

I try to load a ListItemCollection from my SiteCollection using CSOM C#. Therefore I use the following List rr = web.Lists.GetByTitle("MyTitle"); context.Load(rr); FieldCollection fcol = rr.Fields; ...
1
vote
0answers
53 views

Forced Library Column Value

In our Community Site (2013), We have a library that will allow the users to upload documents by category. Below is our requirement. Users Select a Category from the home page. Category page will ...
1
vote
0answers
78 views

Transform list item in Create New Item workflow

I have a workflow that creates a new list item in List B when a new item is added to Liast A. I use a simple Create Item in ____ (Output to Variable: Create) workflow. I want to change the value of ...
1
vote
1answer
80 views

column validation syntax

Trying to compare 4 fields (only if populated) against one another so that no data is duplicated? I've tried something like this but gets too long. =IF(LEN(f1=1), IF(LEN(f2=1),f1<>f2,FALSE),...
1
vote
2answers
61 views

I need help writing a formula that concatenates fields (and adds text) but displays blank if all fields are blank

First, I have very minimal formula writing skills (I'm trying to learn). I was able to create a SharePoint list and have a calculated column titled [Shipment Date Summary] with the following formula: ...
1
vote
0answers
63 views

Will checking “multiple value field” when editing a site column have side effects?

SharePoint 2013 non-dev here. I have a page content type with a column we are using to indicate a location that managed metadata. I want that field to allow multiple values to be added in from the ...
1
vote
0answers
292 views

Read field data of hidden column, sharepoint 2013

Am doing some coding on JSlink to implement conditional formatting on SharePoint lists. We are using SharePoint 2013 online (office 365). The format of the given field(s) are changed based on other ...
1
vote
1answer
214 views

Unable to get “Description” into SharePoint 2010 search results XML

I'm failing terribly at adding a field to my search results. The fields (external) name is "description" and is, to my knowledge, not custom made but out of the box. The Webpart settings already ...
1
vote
0answers
811 views

SP2013 Column Validation Length without spaces

I have a Column Title, and need to get its length but not counting any spaces. This is a test should give me the length of 11 With LEN I can get the length of a string, but with the spaces. After ...
1
vote
0answers
40 views

How to find files by typing a column property?

I'd like to know how to find documents inside all SharePoint libraries ("all folders") by typing a property name inside a custom column. Is it possible? For example, I create I column called "project ...
1
vote
0answers
195 views

Add an additional column to just a subfolder view (not for all library views)

I would like to add an extra column to one of the subfolder views I'm working with. Basically, I have a large document library with 10 or so top-level folders. A few layers down, I would like to be ...
1
vote
0answers
22 views

My Webpart does not see Field in a list

I am writing a webpart for SharePoint 2007 and have 1 problem with accessing list by a webpart. I have a list with lets say 10 fields and I am using this fields by a webpart without problem. But ...
1
vote
0answers
899 views

Column Visible in Standard View but not in Datasheet View or Edit Document Properties

I customized the standard Shared Documents library in the following ways: Renamed the "Title" column to "Description" Added new columns to the default view ("All Documents") The Description column ...
1
vote
0answers
283 views

column validation across survey questions

I want to validate responses to a question in a survey using information from a previous question and I just can't get the survey to take the validation formula. Basically: Q1 = How many hours do ...
1
vote
1answer
236 views

Column Validation Formula works in Excel but not in SharePoint

It seems like the tip was to create your formula in Excel and then just copy it to sharepoint. So I did and it doesn't work so I was just wondering if someone could tell me why. I've trying to ...
1
vote
0answers
457 views

Gantt Chart Web Part: '[Column]' already belongs to this DataTable

I ran into an issue in vanilla Sharepoint 2010 where I had a gantt chart set up on a page and another user modified it, forcing me to recreate the chart. I went to connect the new chart to data ...
1
vote
1answer
147 views

Modified column's value

I experienced that when I make some changes in a document without checking out the document, the value in Modified column won't change/update, this value changes/gets updated only when i check the ...
1
vote
0answers
382 views

Content Type Columns not showing for Image Library

I have created the following 2 Site Column Definitions and a Content Type that incorporates both of the site columns A List Definition of type Picture Library that utilizes the Content type. however ...
1
vote
1answer
40 views

Column Data Calculations - Default

Working in SP2013...I want to have a default number appear in the column. However, the number will change every two weeks by 1. For instance, the default value is 23, but in two weeks it will be 24 (...
1
vote
0answers
285 views

How to set custom list's column order declaratively

So basically what I want to achieve is to find a way to set column order on my custom lists declaratively (I'm using list definitions to create my custom Lists). One way of setting column order is to ...
1
vote
1answer
38 views

how do i add a column that shows what people/groups have access to that file?

I have many documents that have different permissions, I would like to have my users be able to see who else can see/edit the documents. I don't want them to be able to change the permissions just be ...
1
vote
1answer
478 views

SharePoint 2010 - Create related hierarchical fields from external source

Is there a way to create two related columns as a custom field type in SharePoint? For example, can you develop a custom field type named CustomerOrder that consists of two related lookup columns ...
1
vote
1answer
190 views

maximum length of the Name field in document set

the maximum length of the Name column in document sets is not sufficient for my purpose and it seems that it is not possible to increase its length. perhaps I can create another column as my name. ...
1
vote
1answer
817 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 ...
1
vote
0answers
146 views

JavaScript function in URL field value

Is it possible to set the value for the URL field so that when clicked it runs a JavaScript function? I have created a field which stores links to files in SharePoint, but when clicked, the file is ...
1
vote
0answers
3k views

Column width in SharePoint

I would like to customize the width ( make them narrow, with 2 lines of headline ) of the columns in my SharePoint library. As far as I searched it can be done in SharePoint Designer with codes. Yet, ...
1
vote
1answer
66 views

Remove comma in radio selected numbers

My apologies if this has been asked already but I do not know what to reference. When a column is created and the radio selection Number (1, 1.0, 100) is selected and a work order number, such as ...
1
vote
0answers
297 views

Change column type from “Lookup (information already on this site)” to Person or Group

I have an issue after migration SharePoint 2007 to 2010. We had “Person or Group” which now somehow has transformed to “Lookup (information already on this site)”. This creates lots of troubles for ...
1
vote
0answers
16 views

Creating a report from a list that exceeds the number of viewable columns set by the admin

The SP admin has restricted views to 14 columns however the workflows used by the list will max at 24 columns. Is the admin throttle applicable to my report or is it only applicable to views?
1
vote
0answers
282 views

Week number formula for date and time column

What calculated field formula would show me the week number for a date and time like this: 5/27/2012 6:00 AM All the formulas I found are only for dates.
1
vote
0answers
585 views

How to create HTML column in Sharepoint?

Today one of are lab tech deleted the Java Script that would take the HTML in a list and display it. Dose anyone know what script it is? What im trying to display: <span style='position:relative;...
1
vote
0answers
339 views

Rules for Transforming List Column Names into XML Element Names

I am using the ListData.svc service to pull data from several lists. Many of the column names have punctuation and spaces, so their names are transformed as they're rendered as Atom in the ListData ...
1
vote
0answers
576 views

Change the default “Name” column in a Form Library

Is it possible to change the default "Name" column that is created in a form library. One method I saw is creating a content type that inherits from this column. Could someone provide instructions on ...
1
vote
0answers
122 views

Document List Indexed Column goes missing

We are currently trying to troubleshoot a problem in Sharepoint 2007 where a custom column loses the "indexed column" setting. We are trying to track this down, but has been mostly a reactive ...
1
vote
1answer
29 views

Icon Column deletion

Hi I added my custom list an "Icon" column, but I'm not able to delete it from now on: Like here in SharePoint Designer its grayed out: and via the List Settings the "Delete" Button is not displayed:...
0
votes
0answers
23 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
11 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
12 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
1answer
23 views

Updating Site Columns on SharePoint online

We have a document library with thousands of files that are not properly categorized. On of the main reasons this happened is because the columns are not required to contain information. Is it ...
0
votes
0answers
27 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
45 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
0answers
20 views

Can the hard-coded column name in a custom display form be dynamic instead?

I have a column in a list: “C” is the external column name and “x0043” is the internal column name. For some reason, in a custom display form, the external column name that is displayed is hard-coded ...
0
votes
1answer
22 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
0answers
17 views

Custom display form is showing old column names

Situation: I created columns A, B, and C. I created a custom display form with SharePoint Designer 2013 that displays A, B, and C. I renamed columns A, B, and C to X, Y, and Z, respectfully. Problem:...
0
votes
1answer
32 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
0answers
9 views

Queried Images to Display in Word Document

I am on SharePoint 2016 and Nintex 2013. Requirement: The team wants a Microsoft Word document that allows spellcheck and other formatting options that are limited or unavailable in InfoPath. I am ...
0
votes
0answers
25 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
189 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 ...