We have several functions that insert records into a form.  The form that the record is inserted into has many formulas fields in it.  After inserting a record none of these formulas initially have calculated as expected. When viewing the record in an html view the formula fields are null. When I edit the record and change one of the values that the formula in calculating based on, the formula recalculates to display the proper value.

How can i get these formula fields to calculate properly after the record is inserted?

Currently we need to go into ever record and change a value back and forth to get the formula to calculate.  

Although I would like to give edit access to support I have a feeling it will take an hour to explain how all the functions work and to demonstrate the problem. 

In general what normally leads to this kind of problem?

What might be wrong in my function to cause this? is there something wrong in my formula?

Does the sequence of a formula field change how its calculated and could this be causing the problem?

Thanks

Matthew