There are a couple of instances in the solution I'm building where some unstored calculated fields don't update when expected. The issue only seems to be a problem when I'm running a script, because if I manually manipulate the data using a separate window on table view, the calculations update instantly.
I've tried using the Refresh Window (with all combinations of options) in my script, as well as committing the record right after making a change but nothing seems to work. What am I missing? Is there a way to trigger the fields to update?
A few other notes about my solution:
- My solution is in the data separated model
- The calculated fields use the aggregate functions to find data across relationships