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

learn more… | top users | synonyms (1)

1
vote
3answers
3k 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
848 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
817 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" ...
5
votes
3answers
992 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 ...
1
vote
3answers
456 views

Limiting permissions to list-items and library files without using folders

I have some files in a flat library, i.e., no subfolders, that need to have access restricted to a couple usergroups. I understand that one way to do this is by placing items in a subfolder in the ...
3
votes
0answers
328 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
52 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
47 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 ...
1
vote
1answer
44 views

Existing values of some columns are not displayed in QuickEdit view?

If I use QuickEdit in a document library, some of the custom columns seem to be empty. In fact, they already contain values. Is this a known bug? Does anybody have an idea, what could be the ...
0
votes
1answer
1k 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
893 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
3k views

Create Lookup Field Powershell

I am using SharePoint 2013, I need to create a lookup field through PowerShell. I tried this code but is not working: $SiteUrl = "http://mySite" $WebObj = Get-SPWeb -identity $SiteUrl ...
1
vote
1answer
320 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 ...
3
votes
1answer
269 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 ...
0
votes
2answers
1k 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
1k views

sp2013: Column with link to the displayform like on the title column?

I'm using SharePoint 2013. I have a custom list and a custom Content Type. I have edited the view and deactivated the title column because I don't use it. I now miss a column with a link to the ...
1
vote
1answer
431 views

SharePoint 2013 - Reverse Lookup

I am trying to achieve the following in SharePoint 2013. I have two (2) lists a server list and an application list. Each list contains a lookup column which a user can select which applications are ...
0
votes
1answer
49 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
252 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
4k 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 ...
0
votes
1answer
103 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
94 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 ...
1
vote
1answer
182 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
1answer
1k views

SharePoint 2013 sp.js Getting the column names of custom list

*Edit* I have figured out how come the data returned for the columns was showing the wrong labels. The issue occurs when the list columns are created using the quick edit mode, as it allows you to ...
2
votes
2answers
301 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
157 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 ...
0
votes
0answers
224 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: ...
2
votes
1answer
239 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
1answer
114 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 ...
2
votes
2answers
352 views

Using field/column in html Page Layout but in CSS — Sharepoint 2013

I know you can use fields to define the content in a page, for instance, <div id="titleField"> <!--MS:<PageFieldTextField:TextField runat="server" ControlMode="Display" ...
1
vote
0answers
339 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 ...
0
votes
1answer
469 views

SharePoint 2007: Get the average of a list column and display it on a page

I have a list with a column filled with values from 0 to 10. I need to take the average of this column and display it (maybe rounded to 1 decimal place) on another page as a kind of big, bold, ...
1
vote
0answers
61 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 ...
2
votes
1answer
2k views

Anything other than username in Person or Group column will not resolve only in quick edit mode

This is a SharePoint 2013 environment migrated from SharePoint 2010 (this works properly in the old 2010 environment). There's a “Person or Group” column present in a document library. When using ...
1
vote
2answers
799 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 ...
1
vote
1answer
100 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
2answers
113 views

Get all values of a specific column of a specific content type

I have a custom content type. In this content type, I have a text column (Mycolumn). In a site collection, I have several instances of list bound to this content type. Is there a way to retrieve all ...
1
vote
3answers
1k views

Custom Field - Hide field on Item Edit and Add (ShowInEditForm, ShowInNewForm )

Im using SharePoint 2007. Created a custom field for a SharePoint list, which should not be displayed during Item Add or Edit. I have used SharePoint WSP Builder Project in Visual Studio 2008. Created ...
1
vote
0answers
259 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 ...
0
votes
2answers
190 views

Field is not displayed in new form of list

I have created a field to add it in the content type and that content type is used in the list. My field's declarative part is: <!--Field Type of project--> <Field ...
0
votes
1answer
548 views

Submitting data from Infopath 2010 to SharePoint 2010?

I have published a Infopath form as Document Template of the document library, the Infopath form has so many fields(~200) however I would like to map few fields(~5) to SharePoint List columns on the ...
0
votes
2answers
266 views

Display GUID column of document in the XML Api request

Before I start, let me just say that I have no experience with Sharepoint. Because of this I do not have the necessary knowledge of the different terminology, so bare with me. That said, I'm currently ...
0
votes
1answer
31 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 ...
0
votes
1answer
38 views

How to get column headers to wordwrap in SP2010

I have read the postings on this site (actually read every posting I could find on the internet) concerning how to get long, column headers to wordwrap in SP 2010 with no success. I've tried to insert ...
2
votes
2answers
138 views

Date Format Modifcation in List

I would like to format a new column with the Month and Day of another column. Is there a way to accomplish this? I tried adding this =TEXT([Date of Birth],"MM/DD") in column validation but it gives me ...
1
vote
1answer
123 views

Column Validation

I got 8 columns in my List(calendar reservation). I want to have one column(Approval: YES/NO) only visible to a user("testuser"). How can we use column validation *expressions* to archive this. ...
1
vote
3answers
640 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 - ...
1
vote
1answer
224 views

Text Layouts and customization and difference web part zones

I know what is different between "Page Layouts" and "Text Layouts". But what about web part zones? How web part zones fit in this picture? Is web part zone just one small part inside Text Layout, ...
0
votes
1answer
109 views

How to add clickable and filterable user field for users not in site

I have users in string like "Mikhail Pushin" and I want to add clickable links to users in a column of list item. Also I should be able to use filtering on this user column. Unfortunately, I can't do ...
1
vote
0answers
227 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 ...