AnsweredAssumed Answered

How To: Update a number field when calc in record changes?

Question asked by mr_scott on May 18, 2012
Latest reply on May 19, 2012 by BruceHerbach



My question is on how to ensure that a plain number field (CountCasesResult) is displaying the result of a calculated field (CountCasesCalc ) whenever changes occur to that calculated field - automatically. I'm trying to speed up a list-based summary report that I created with the help of Matt-squared (Matt Navarre, Matt Petrowsky).


I was manually running a replace command, but ended up creating a new calculated field, which is becoming a real drag.


I'd like this to be automatic, like FileMaker's indexing of fields for calculation purposes.


Currently, I have a self-join in the data file, along with these 3 fields:

CountCasesCalc - count of "case id" within the chosen analysis for the selected issue

uniqueCasesCalc - count of unique cases on a selected issue

CountCasesResult - Just a number field to hold the result.


I also tried this as auto-enter, like my HostTimeStamp, but it is not updating when the referenced calc (CountCasesCalc) changes:


Let (

~trigger = CountCasesCalc ; Case ( uniqueCasesCalc > 0 and CountCasesResult ≠ CountCasesCalc ; CountCasesCalc ; CountCasesResult )



The report seems much faster with the number field result compared to the unstored calculation I have now.


Does this require a trigger in the data file? Am I looking for the impossible? Any suggestions will be very welcome.


Thanks in advance.

- - Scott