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

learn more… | top users | synonyms (1)

0
votes
0answers
51 views

Filter Document Libraries based on a column name

Get-SPWeb http://sharepoint/sites/training | Select -ExpandProperty Lists | Where { $_.GetType().Name -eq "SPDocumentLibrary" } | Select Title I have this code which outputs all of the document ...
0
votes
0answers
22 views

Changing Field Type of a column

Is it possible to change Field Type of a column from TaxonomyField to Single Line of Text? It is a SharePoint online solution.
1
vote
0answers
84 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
2answers
243 views

Calculated column to retrieve total number of ID

I have a SharePoint list which all has a unique ID to identify the items, so I want to create a calculated column that counts how many ID are there, like a count! Any help is appreciated
0
votes
0answers
18 views

Where can I find documentation for the Existing Site Columns available in Sharepoint 2010?

The content in my team's Sharepoint 2010 site collection has reached that critical mass where we need an enforceable method of organization and life cycle management. I read in several blogs that ...
4
votes
1answer
177 views

Add a user profile property as a library column

I have a few properties stored against user profiles (both standard and custom properties) that I would like to show, based on the user that created an item, in library views. For example, if the ...
0
votes
1answer
172 views

Cannot edit column type and set it as URL

I'm using SharePoint 2013. I have a list with custom columns. One column is text type, and I want to set it as URL type. In SharePoint Designer, I can change the type, but I can't choose "URL" type. ...
0
votes
0answers
106 views

Hyperlink with formatting and constraints for publishing

I created a site column of type Hyperlink with formatting and constraints for publishing. when I added this column to my list it does not disply the correct hyperlink to my file but it display an ...
0
votes
0answers
58 views

Url column fill with powershell how to disable link on a item

I have a list with custom columns. One column type is URL. I create an item like that : $new = $list.Items.Add() $new["Client"] = "http://google.fr/, $($i.client)" Is that possible to disable the ...
0
votes
2answers
178 views

Document Library add file with custom column (SharePoint 2013)

I have a document library with a custom column. I want to add a file programatically, as well as a value for the custom column(lookup column). SPFile file = ...
0
votes
0answers
57 views

Save properties in a custom field

I have a cross site custom field. with user control to save properties like WebId ListId and FieldID. class CustomLookup : SPFieldUrl{ public Guid WebSourceId { get { ...
0
votes
1answer
105 views

Add new button to a column with “single line of text data type” in SharePoint

I am trying to create a "Add new" button to a column called "other Passengers" which has a "Single line of text data type". Such that I can add up "0 to n" numbers of passengers not in our LDAP i.e ...
0
votes
3answers
732 views

Character limit on Title column

I would like to know if there is a way to increase the character limit of 255 chars on the Title column of a list. If not, is there any way to bypass the Title (is a required field by default) and ...
0
votes
1answer
378 views

How to create custom site column with type File

Reading MSDN documentation I see that we can define a type File for custom columns. When I define the site column in Elements.xml using element and type file, the column does not get rendered. THe ...
0
votes
1answer
192 views

How to configure Currency field?

How to set currency symbol for a field (in list definition)? <Field ID="{1706A5C3-AC44-4685-A075-6019FAF9D940}" Name="Budget" DisplayName="Volumen (in €)" Type="Currency" /> SharePoint is in ...
1
vote
1answer
304 views

The element cannot contain child element because the parent element's content model is text only Error

I want to provision the field using feature. I have a field which is of type Calculated and the xml for the column is like below: <Field Type="Calculated" ...
3
votes
1answer
110 views

Where does SPFolder store it's “Created By” information?

Here's an odd one: I have a content type derived from SPFolder, that I am creating through code. As part of the creation process, I am trying to set the "Created By" information to be the user who ...
1
vote
0answers
126 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 = ...
0
votes
1answer
42 views

Cascading Column Selections

I am trying to find a way to make it so that when a User selects from a drop down option of "Category", based on their response, specific options will appear in the drop down for the next column ...
0
votes
0answers
27 views

First Modified Date

I need to capture the date that each row in a list is first modified. Not the date that the row is created, but the the date that the row is first modified after creation (effectively the date ...
0
votes
0answers
124 views

Folder content Type and document sets

Can you add a External Content type column to either a folder content type or a document set? It doesn't appear to be available for either one. Update You can create columns with external data but ...
5
votes
3answers
2k views

Show Modified and Created columns with Date only

I'm looking for the best way (if there is one) to show the Modified and Created columns in a list/library with the date only, so without the time. For example, instead of 1/12/2011 8:37 PM it should ...
0
votes
1answer
247 views

SharePoint Column Formula Validation

I need to check if a column (type Number) is an Integer (no decimal). I added this formula to the list validation: =mod([MyField],1)=0 But I get this error: The formula contains a syntax error ...
0
votes
1answer
312 views

SharePoint Powershell Number and User columns

I need to create two list fields by powershell. One that accept only Integer (type Number with no decimal) and the other User (multiple selection). I can create Number field and Single User field ...
0
votes
2answers
856 views

Create Lookup Field Powershell

I am using SharePoint 2013, I need to create a lookup field throw PowerShell. I tried this code but is not working: $SiteUrl = "http://mySite" $WebObj = Get-SPWeb -identity $SiteUrl $myCustomList = ...
1
vote
3answers
370 views

how do you update a taxonomy metadata field where the fields Name contains a space in it

Here is the following specifics in question. I have the following taxonomy field and its associated Note field. The taxonomy field is defined with a space value in it. Taxonomy Field - ...
0
votes
0answers
20 views

Translations from resources appearing in list view but now in new or edit forms

I have a really weird problem with .resx files that I use in my solution that has been driving me nuts the past couple of days. I have two resource files: MyContentType.resx (english) and ...
1
vote
1answer
163 views

creating custom field type to upload video files and store it in asset library

I have a requirement below. my custom page layout should have a column which should accept video files and on saving the page, it should save the video to the asset library. if the user uploads the ...
0
votes
2answers
535 views

Sharepoint tasks - ASSIGNED TO value is empty

I created custom view in sharepoint 2013 for tasks. So users can see only tasks which are created by them or assigned by them. They all have contribute rights, and I remove abillity to create custom ...
1
vote
2answers
919 views

Remove Select column in xslt web part

I have an xslt web part that I want to connect to another list. When I connect it to another list I get the select column that I don't want to see. How can I remove it? More info Originally I was ...
0
votes
0answers
87 views

SharePoint yes/no showing as true/false, will changing to Choice break my meta data?

As the questions suggests. Will changing my Yes/No to Choice break it. Are there any risks that may impact future use? I could test sure but I'm more concerned with any possible filter or ...
0
votes
1answer
45 views

I want to change a column type but don't want to lose my data

I have a column using the "Currency" format. Since it only allows one type of currency I need to change the column type to single line of text. I will be using radio buttons to select the different ...
2
votes
0answers
149 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 ...
0
votes
1answer
478 views

Auto-Set a Sharepoint list field upon submittal of a form

I created an Infopath form and would like to have a particular field to be set to some default value every time this form is submitted (the field is not shown on the form, user should not have to ...
0
votes
1answer
249 views

Sharepoint 2013: changing column order is not refleted in the list

I changed the column order on a list item. These changes are reflected in the "column ordering" view. However, the changes are NOT reflected in the actual list layout. I tried emptying the browser ...
1
vote
2answers
495 views

add a new value to a lookup field

I have a custom list in SharePoint 2013. This list contains text and lookup fields. While I do not have an issue populating the text fields, the lookups are giving me trouble. I found and tried ...
0
votes
1answer
61 views

sp2013: set datetime column + 3 year in some condition, how?

I have a sharepoint 2013 site. I have a custom documentlibrary with 4 custom contenttypes. When I upload a document I can select a contenttype and see 1 datetime column. I would like to set the ...
0
votes
2answers
65 views

Q: Can I update values of an entire column from a workflow?

I'm using VBA to gather info based on their status. What I'd like to do is reset their status after the VBA operation is done. From my understanding, there is no way to update via Excel VBA. My only ...
0
votes
0answers
154 views

MultiChoice Default value from resorces

I have a multichoice field that get the choices from resource file. And I read that a multi default value could be set using DefaultFormula and ;# seperation. So I defined my feild like this: ...
1
vote
1answer
97 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 ...
2
votes
5answers
3k views

Image column on document library

I have a requirement to add a thumbnail image column into an existing document library on my SharePoint 2010 site. Thumbnail images for each document are uploaded to the images document library. ...
1
vote
1answer
2k views

Ordering Stacked Column Chart Series SSRS 2008

I am working with SQL Server Reporting 2008. I have a stacked column chart.There are around 8-10 series stacked on each other. I want my series to come in a defined order from Top to bottom. I have ...
2
votes
1answer
110 views

Calculated Column needs left alignment

I have the same exact problem as related here Calculated Column left align header However, the solution suggested is inadequate. This would require me to manual add the web part to each list that I ...
0
votes
1answer
74 views

How to hide specific column header in a list WebPart?

I created a webpart with URL column header, but i want to hide it for users...i know i can hide it using CSS but it hides all the colum headers in other webparts, Any solution to hide only the URL ...
2
votes
1answer
61 views

How to store “stream” and “fields” paramters properly

I'm trying to use the GetItem method to use for copying documents, but I'm not having luck with the field or stream parameters. Below is an example of how I attempted to store each of them. When I ...
0
votes
4answers
809 views

How to fix width of column in SpGridView?

I have a spgridview with dynamic column. I want fix width and if the content is a part of it is displayed. I use this code but don't work for me . BoundField col = new BoundField(); col.HeaderText ...
2
votes
1answer
147 views

Popup confirmation on 'status' column change

I'm looking to create a popup dialogue box when a column called 'Status' is set to 'Complete'. I want a popup box to ask "Confirm Complete?" with Yes or Cancel choices. Obviously Yes will update the ...
2
votes
3answers
1k views

What is the best way to provision Content Types and managed metadata columns in SharePoint 2010

What is the best way of provisioning ContentTypes, Columns and Metadata columns in SharePoint. Keeping in mind that we have two approaches of 1) SP object Model and CAML (declarative way). Which ...
1
vote
0answers
253 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
53 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 ...