Post
Ask Question

How to get the formula for the calculated field in SharePoint 2010 using Client Object Model

I have a list named "CustomList" which contains a calculated field called "Calculated". I am going to get the formula for the calculated column using Client Object model.

 
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SharePoint.Client;
 
namespace COM
{
    class Program
    {
        static void Main(string[] args)
        {
            // siteURL is the string that contains the site URL 
            string siteUrl = "http://serverName:50000/sites/Testing";   
            // ClientContext object is used to get the context for the SharePoint objects
            ClientContext clientContext = new ClientContext(siteUrl);
            Web web = clientContext.Web;            
            List list = web.Lists.GetByTitle("CustomList");
            Field field = list.Fields.GetByTitle("Calculated");
            FieldCalculated calculatedField = clientContext.CastTo<FieldCalculated>(field);
            clientContext.Load(calculatedField);
            clientContext.ExecuteQuery();
            Console.WriteLine(calculatedField.Formula);   
            Console.ReadLine()
        }
    }
}