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?
Thanks so much for any help.
A.
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.
Good Luck!
Neal Barker