Sharepoint – Custom Integer Column – Remove thousand separator in EditForm

integersharepoint-2010

I created a new column definition in Sharepoint 2010 of type integer and with Commas set to false.
A content type uses this column.
When I create a list based on the content type, the "View Item" form will display the field correctly: 2010.
The EditForm however will display it as 2,010: with a comma although commas is set to false.

This is a new integer field (not a number field converted to integer)

Any ideas how to display 2,010 as 2010 in the EditForm?

 <Field
  ID="{FF3B3FA8-AF33-4691-AD7E-1463DC024B99}"
  Name="studyYear"
  StaticName="studyYear"
  DisplayName="Study year"
  Title="Year"
  Description="Study year"
  Required="FALSE"
  Group="Custom Columns"
  Type="Integer"
  Commas="FALSE"
  Min="1900"
  Max="2300"
  MaxLength="4">
 </Field>

Best Answer

I wanted to group list items by Year based the Created field, but needed to covert number to text to avoid 1000 separator (,)

So I created a calculated field with formula of =LEFT(YEAR(Created),1)&RIGHT(YEAR(Created),3)

Related Solutions

Field not displaying on list with Content types Inherits=”False”

Ok so was on my way up the garden path...

The issue why 'Link Category' Field was not being created on the 'Related Links' list wasn't related to setting Inherits="False", it was because I had not defined it in the list schema even though I'd defined it in the content type. As mentioned here:

http://msdn.microsoft.com/en-us/library/aa543576.aspx

When SharePoint Foundation creates a list instance, it includes only those columns that are declared in the base type schema of the list or in the list schema. If you reference a site content type in the list schema, and that content type references site columns that are not included in the base type schema of the list or in the list schema, those columns are not included. You must declare those columns in the list schema for SharePoint Foundation to include them on the list.

And here:

http://stefan-stanev-sharepoint-blog.blogspot.com/2010/03/contenttypebinding-vs-contenttyperef.html

One ugly thing about it is that you specify a site content type to be attached to the list based on that list definition but the framework doesn’t provision the fields in the content type if they are missing in the list – so you need to add manually all content type’s fields in the Fields element of the list schema file. This is actually what I called the fields’ redefinition issue...

So duplicated Field element below from the content type definition to list schema:

    <Fields>
        <Field DisplayName="Link Category"
               Name="LinkCategory"
               ID="{654EAC00-342B-4176-9D91-613AD724F684}"
               Group="Custom"
               Overwrite="True"
               Type="Lookup"
               ShowField="Title"
               List="Lists/LinkCategoryList"
               WedId="~sitecollection" />
    </Fields>

I can confirm that using Inherits="False" & <RemoveFieldRef ID="{fa564e0f-0c70-4ab9-b863-0177e6ddd247}" /> does remove the title field.

Here's another good link about Inherits="False" for those who stumble upon this post.

https://sharepoint.stackexchange.com/questions/2995/mysteries-of-the-contenttype-inherits-attribute

SharePoint Title Column DisplayName

I finally found that if I explicitly include the LinkTitle in the Fields element of the MetaData element in the list definition and set the DisplayName attribute of the Field to "Name", that does what I was looking to do.

<Field Name="LinkTitle"
       ID="{82642ec8-ef9b-478f-acf9-31f7d45fbc31}"
       DisplayName="Name"/>

Best Answer

Related Solutions

Field not displaying on list with Content types Inherits=”False”

SharePoint Title Column DisplayName

Related Topic