Formula field not updating?
Hi,
I wanted to display the number of confirmations for a bug in my bugtracker application in a view. I have two Forms, "Bug_Submission" and "Bug_Confirmation". In the "Bug_Confirmation" form there a lookup field for an ID in "Bug_Submission" called "Lookup_Bug_ID".
So I created a Formula in my "Bug_Submission" form with a value: countConfirmations(ID)
with the function countConfirmations like so:
int countConfirmations(int id) {
return count(Bug_Confirmation[Lookup_Bug_ID==id])
}
which works fine.
When I now submit a new entry to Bug_Confirmation for a bug and then check the Bug_Submission View the confirmation count for that bug (the formula value) is not updated. I figured that the formula value is saved when submitting the bug, and is not updated thereafter. When I edit and save the record, then the formula will show the correct value. (I solved the problem by updating the record, when a confirmation is submitted.) However I would consider that a bug.
I hope it is understandable, what the problem is. Is it right, that formula values are saved with the submission of an entry and not reevaluated when the entry is shown in a view? In this case the value of a formula that is displayed in a view is not garanteed to be correct anymore.
Will you introduce a possibility to display truly evaluated results in a view? I would love a calculated column in a view, without using a formula in the form.
Greetings, Mathias
P.S.: why is the fontsize of my post changing after the code section?