How to create Calculated field in list Schema

Advertisement
            I want to create Calculated field in list schema, Formula SP"&(TEXT([Created],”yyyy”)) the following code help you to create this formula in Schema

"SP"& (TEXT([Created],”yy”))  
"SP"& (TEXT([Created],”yy”))  

 <Field Type="Calculated" ID="{CG453ACF-2131-4836-AGJ9-3EF894A57225}"        EnforceUniqueValues="FALSE" Indexed="FALSE" LCID="1033" ResultType="Text"  DisplayName="CalID" StaticName="CalID" Name="CalID" Required="FALSE" >
       <Formula>="SP"&amp;TEXT(Created,"yyyy")</Formula>
           <FieldRefs>
                <FieldRef Name="Created"/>
       </FieldRefs>
 </Field>

In Previous article we can check  How to create Calculated Fields in SharePoint List &  with some Date and Time Formulas.
Advertisements
SHARE

Unknown

  • Image
  • Image
  • Image
  • Image
  • Image
    Blogger Comment
    Facebook Comment

1 comments: