DFW SharePoint User Group / SharePoint Users Group / Development / What is the best way to add calculated fields to a list? / Latest PostsInstantForum.NET v4.1.3DFW SharePoint User Grouphttp://www.dfwsharepoint.com/forum/skocurek@isi85.comTue, 06 Jan 2009 02:34:49 GMT20RE: What is the best way to add calculated fields to a list?http://www.dfwsharepoint.com/forum/Topic137-4-1.aspxYes, that was my first approach but since I had zero experience with sharepoint programming I thought I'd try out of the box workflows in Designer, but the calculations are too involved for the options that this provides. Later I found some articles on adding a custom event handler to a list item and have been trying to get an itemadded event handler to work ever since. I can post my code if this is something you are familiar with?Fri, 01 Feb 2008 10:54:55 GMTanyam_99RE: What is the best way to add calculated fields to a list?http://www.dfwsharepoint.com/forum/Topic137-4-1.aspxA.</P><P>I'm not sure you want to go the route of adding code to the onChange event of the column. While not a bad solution, you would need to write a custom field type for that. It seems that a workflow solution that initiated each time an item was added or changed would suit the problem. I'm not sure what dates you need to get for the calculation, so I'm not sure if the workflow wizard in SharePoint Designer would work. There are some great samples for creating workflows in Visual Studio out there.</P><P>Good Luck!</P><P>Neal BarkerFri, 01 Feb 2008 10:01:29 GMTknbarkerWhat is the best way to add calculated fields to a list?http://www.dfwsharepoint.com/forum/Topic137-4-1.aspxI have a pretty simple task to complete. I have a custom list in MOSS 2007 with a date field. I need to calculate a bunch of other dates based on the value of the date field entered and the values of other fields in the list. The standard 'calculated' field type for a column can not accomodate what I am trying to do. I need to add some code to execute every time the date field changes to preform the calculation and write back to the appropriate list columns. </P><P>What is the best way to do this? I've tried looking at Sharepoint Designer but do not see an onChange event for a data bound list field control. I've also been struggling trying to write an event handler for the list where I could do the necessary calculations. Can't get it to work so far. Am I missing something in Sharepoint Designer, can I attach code to a change action on a list field?</P><P>Thanks so much for any help.</P><P>A.Fri, 01 Feb 2008 09:36:25 GMTanyam_99