I have a layout that has multiple portals with fields that are based on calculations. I need to force FM to refresh the calculations so that my portal filters work as expected with the recalculated field values. Once the user changes a field value on the layout, I need to refresh the layout so that the filters work correctly. If i manually refresh the window using Records --> Refresh Window from the FM menu, the refresh works as expected.
But if I script this and use a field trigger and the "Refresh Window" script command, it does not work and the portals don't refresh as it does via the manual menu command. I have tried the "Refresh Window" command with all its options to flush the cache and it still does not work.
Can anyone tell me what the menu command does that is different than the "Refresh Window" script step? How else can I force the refresh/recalculations so that the portal filtering works correctly?
Any help will be greatly appreciated!