Modify a Calculated Field

[Robbydobbs]

Someone posted a way to modify a calculated field once, but I don't remember who. I tried to use the [Number Field] Option - Auto Enter - Calculated Value - but this didn't calculate the field. It just stayed the same. So when I go and use the (Calculation Field], the calculation works, but then I can't go back and modify the field if I want to. Is there something I'm missing or is this possible at all?

[jasonwood]

set your calculation field so that it does not allow entry into field. Then put a new field "override" behind it. When you click in the calculation field, the cursor will go into the field behind, and you will see its contents.

Then change your calculation field where "originalCalc" is the calculation that was previously in the field...

If (IsEmpty(override), originalCalc, override)

This checks to see if override is empty. If it is, it will use the normal calculation, otherwise it will use the contents of the field. Note that even a space will be considered enough to override the field with this setup.

[RussBaker]

Here is the sample file that you refer to, which I posted a few days ago. This one was in response to a specific question, so it also has a hard-coded "minimum" order cost of $75 in it.

Test Cost OverRide.fp5.zip

[Robbydobbs]

This is absolutely great. Thanks alot guys. I really appreciate it.