Programmatically create calculated field in SharePoint 2010

By Vijai Anand Dec 04, 2012
In this blog you will see how to create calculated field in SharePoint 2010 using SharePoint Object Model.

I have a custom list named “Custom”. I need to create a calculated field to this list using SharePoint Object Model.

In this blog we will see how to create calculated field in the custom list using SharePoint Object Model.

Code Snippet:

 

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using Microsoft.SharePoint;

using System.Collections;

 

namespace CalculatedField

{

    class Program

    {

        static void Main(string[] args)

        {

            using (SPSite site = new SPSite("http://serverName/sites/Vijai/"))

            {

                using (SPWeb web = site.OpenWeb())

                {

                    SPList list = web.Lists.TryGetList("Custom");

                    if (list != null)

                    {

                        ////Create a calculated field

                        string calculatedColumn = list.Fields.Add("CalculatedColumn", SPFieldType.Calculated, false);

                        ////Get the newly created calculated field

                        SPFieldCalculated calculatedField = list.Fields[calculatedColumn] as SPFieldCalculated;

                        ////Set the calculated field formula

                        calculatedField.Formula = "=[Title]";

                        ////Set the data type returned from this formula

                        calculatedField.OutputType = SPFieldType.Text;

                        ////Update the calculated field

                        calculatedField.Update();

                    }

                }

            }

        }

    }

}



Calculated Field created successfully:



CalculatedField.png
Vijai Anand

Vijai Anand has been working in IT industry for over 5 years. He holds Bachelor's degree in Electronics and Communication Engineering. Vijai write articles and blogs related to SharePoint 2013, SharePoint 2010, Silv... Read more

COMMENT USING

PREMIUM SPONSORS

Hire Mobile & Web Developer on demand. 100% satisfaction. Try for 1 week or Money Back. Local and remote developers available all over USA.

Latest Blogs