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

learn more… | top users | synonyms (1)

2
votes
0answers
68 views

How do you validate a column only if it's new item being added?

I recently added validation to a field which works great. =[Arrival Date]>=TODAY()-5 However, I ran into an issue when an employee is editing an older item to update the "Status" but it's not ...
2
votes
0answers
171 views

Filter.aspx and GetDistinctValues

We found an issue, that filters on columns are stop working. Error message is: Cannot show the value of the filter. The field may not be filterable, or the number of items returned exceeds the ...
2
votes
0answers
288 views

Sharepoint Designer Set Task Field drop-down is showing empty

Using SPD 2010 I created an Approval process. I have added few custom field to my task list and now under "Before Task is assigned", the action "Set Task field" is not showing anything on the ...
2
votes
0answers
71 views

Why the Required property of field is changing to false?

I created site column with Required="true". Then I created site content type and added my column to it . Then I created list, selected "Allow management of content types?" to "Yes" and added my ...
1
vote
0answers
25 views

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

Remove-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue Add-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue #To which site u want to create the list ...
1
vote
0answers
18 views

Setting Required Managed Metadata Column to hidden with default value?

In a Content Type, I have one managed metadata column (which is required) I want to set it with default value and set it to hidden using powershell. I want to clarify if it possible to hide a required ...
1
vote
0answers
42 views

How to associate an existing site column to a list using the REST API

In SharePoint 2013, I have a site column that already exists and I'm trying to associate it to an existing list using the REST API. I found examples on adding a new column to a list using the REST API ...
1
vote
0answers
12 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
0answers
20 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
46 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
0answers
15 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
7 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
13 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
122 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
146 views

Upload pdf file and automatically create list columns in a SharePoint list

My requirement is : When a user uploads a pdf file into a document library. There is a table in a pdf file which two columns. The SharePoint should understand and create list columns from the first ...
1
vote
0answers
93 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
0answers
175 views

Field's TitleResource.SetValueForUICulture() does not work for the web's default language

I have a site column in my site collection whose title I change / translate with following PowerShell statement: $w = Get-SPWeb "URL to the site collection" $f = ...
1
vote
0answers
279 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
0answers
59 views

Is there a setting on SPField that would prevent it from being included in a CAML query?

I'm trying to build a CAML query for a managed metadata column. I'm following the guidelines provided here by Microsoft. Essentially they say to query for the term's Wssid. No problem, I can do ...
1
vote
0answers
172 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
0answers
172 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 ...
1
vote
0answers
25 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
0answers
96 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
1k 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
0answers
192 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
12 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
123 views

Best way to create a list with hidden columns with Data pulling from InfoPath form

So I have been working on this for a little bit here is what I am trying to accomplish: Using OOTB SharePoint 2010 Functionality I want to create an HR Referral System. Basically an InfoPath Form ...
1
vote
0answers
222 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
402 views

Updated = calculated field based on Modified shows 1899 last update

Working with SP 2010 and had to remove the time stamp from modified. Tried at system level - no joy. Used a calculated field (=TEXT(Modified,"mm/dd/yyyy")). This works well but occasionally shows the ...
1
vote
0answers
481 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 ...
1
vote
0answers
309 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
77 views

Using resx file in Calculated Field

Is it possible to use resource file (.resx) in tag? I made a calculated field and want to show the result in some different languages.
1
vote
0answers
323 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
84 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 ...
0
votes
0answers
13 views

Changes to ShowInEditForm not applying

I hid some list level fields from the edit form of a Document Set by setting ShowInEditForm to false via the management shell. I now want to add them back to the edit form. I've changed ShowInEditForm ...
0
votes
0answers
10 views

Managed Metadata field each value to display on a new line

I have added a managed metadata column to my content type and have proceeded to add it to the page layout. It is set to multi-value and is working fine with the delimiter as ";". The results appear ...
0
votes
0answers
15 views

Validation for column choice

I am creating an event registration list using Sharepoint and have a column with the choices session 1, session 2, session 3 etc. How do I set a validation rule to limit the number of items for a ...
0
votes
0answers
23 views

SharePoint 2013 multilingual libraries

I have created custom SharePoint web template. It contains custom libraries, events, site columns, content types, etc... Now I need to implement it to multilingual, so I can use English and German. ...
0
votes
0answers
20 views

Validate Number Column not to accept comma

I want to use ootb column validation to not accept the comma in number field. Can anyone suggest to me what a formula would look like?
0
votes
0answers
28 views

Prevent SharePoint from rendering email address as hyperlink

I try to render a simple text field value (e.g.: i:w#!|adfs|user@domain.local) as string (plain text) on a list with XSL. By default SharePoint converts everything he thinks that is an email address ...
0
votes
0answers
46 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; ...
0
votes
0answers
26 views

How to set default value to CT column using powershell

I want to set the default value to a Content Type managed metadata column, I want to set the default value using powershell and want to set it to hidden. How to accomplish this?
0
votes
0answers
16 views

SP2010: How to enforce unique field values for title but only for list items of particular list content types

Given a SharePoint ListA which contains ContentTypeB, ContentTypeC and ContentTypeD, I would like to enforce unique values only for title fields of ContentTypeB, but not for title fields of ...
0
votes
0answers
20 views

How to get and set column from type “number” by powershell

I am using sp 2010. I have a library with documents. There is a column "CalcultatedWeekNumber" from type "Calculated". I have another column Week from type "Number". I try to get the value of the ...
0
votes
0answers
15 views

External Data Field - check if item exists

I am using this code to set a external data field programmatically XmlDocument xmlData = new XmlDocument(); xmlData.LoadXml(myBCSField.SchemaXml); String bdcEntityName = ...
0
votes
0answers
52 views

People or group type columns are not displaying values

I have a list where columns that are people or group type do not display any values. Only users with Site Collection Administration access can see the values. Users with contribute access can't see ...
0
votes
0answers
14 views

Workflow to make all fields as mandatory after first change

I have more than 40 fields on my SharePoint list. Out of which, only 5-6 fields will be updated by me and rest all will be updated by different team. What I want is, once the first 5-6 fields are ...
0
votes
0answers
42 views

SharePoint Online, Change Column Widths On Custom List

I have created a Custom List via Importing Excel Spreadsheet. How do I adjust the column widths? I tried to follow the below link, (my view is AllItems.aspx) and it never shows me the menu outlined ...
0
votes
0answers
10 views

Creating a Recurrance with the Date and Time column in standard Sharepoint 2010 list

I have a standard SharePoint 2010 list, not a calendar list, and it has a date and time column in it. I want to add in an option to have that column have the recurrence option like the calendar list ...
0
votes
0answers
36 views

SP13: Linking Document URL to Line Item

I am not sure if this can be done or how, but I created a Custom list that has a column for URL's to link to a particular document associated with that particular line item. Each line item is unique ...