Anyone have any ideas.

Hey Kevin, I have a few thoughts, but I wanted to understand more about the calculation formula. Also, what is the actual trigger you need for the recalculation, is it the date change? I assume the formula would account for that. There is a jQuery way to trigger the calculation if programmatically necessary, but I don't think you will have to do that right away.

As a best practice, don't store important historical data in a calculated field. Use a static field instead. You could even have a workflow perform the calculation and update a field and have it read only at all times to the user if necessary. One of these method could be a better alternative than manipulating control functionality.

Hi Kevin,

I agree with Andrew on the calculation fields.  You can probably work with normal fields

One way of achieving conditional calculation is the following.  You will probably have to add a field to your form that is hidden on NewForm mode. On EditForm this field can be shown with one of two options.  If they select option two for instance you can start the workflow on edit with a conditional start

Just ignore the values here...this is just screenshots of an existing workflow of mine

Then only do certain calculations otherwise do nothing.

Let me know if I need to explain anything in more detail