We are using the API to update fields within our jobs (potentials) records.

There are also some custom formula fields that use the fields we are updating.

When the fields are updated, the evaluated values on the formula fields vanish. To get them to show up again, the potentials record must be re-saved, which is not ideal.

For example, we have 2 custom fields on the potentials records:

- Hours Logged

- Hours remaining

We then have a custom formula field with the following formula:

= Hours logged + Hours remaining

Our scheduled application updates the [Hours Logged] and [Hours remaining] fields every midnight. The next day, the formula field does not show any value. The record must be re-saved to evaluate it again.

There are several custom formula fields that have this problem, but this one is the easiest example to explain.

Please could somebody explain what is happening here, whether this is a bug, or whether we are missing something.

Thanks in advance,

Simon R