Questions tagged [column]

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

314 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
1answer
102 views

Lookup Column of a List Column

I have a requirement for a project site in SharePoint. The Site will have: 1st List: a Stakeholders List with the names of people involved (people/group type) in the project and their Project Role (...
1
vote
2answers
337 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
321 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
753 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
81 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
298 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
220 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
820 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
203 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
903 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
286 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
237 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
458 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
383 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
286 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
39 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
480 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
192 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
827 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
148 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
70 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
298 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
289 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
589 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
586 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
5 views

Hide Recurrence Field on Calendar With Several Content Types

I'm having trouble removing the recurrence field from my calendar. I've done it before with a similar PowerShell script as below. It's been modified by selecting the content type instead of the whole ...
0
votes
0answers
15 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
14 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
40 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
13 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
51 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
17 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
28 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
22 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
27 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
15 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 ...