Record load causes endless loop

[john9210]

FM 12 Adv. I'm trying to use a layout trigger on record load. The script goes to related records on another layout to perform some operations and then returns to the layout. So, when I load a record, the script triggers, goes to another layout, returns to the original layout, and the script fires again. An endless loop! Any suggestions on how I can get around this?

[doughemi]

At the beginning of the script, check for $$flag being set to 1; if it is,  then set it to 0 and exit script. While on the second layout, set $$flag to 1.

[comment]

38 minutes ago, john9210 said:

The script goes to related records on another layout to perform some operations and then returns to the layout.

You could add the 'Show in new window' option to the GTRR step and close the window when done.

[john9210]

A solution example is attached. On the Meeting layout a trigger on the Response field runs the script "Count responses". It updates the data in the box under Response Summary. The button beneath the Summary also updates the data. I need to use the button when changing records because the summary data does not automatically update. I would like to run the script when I change records and I thought that attaching a layout trigger on Record load would do the trick. However, this creates a endless loop because the script changes layouts and returns to the original layout firing the script again. I've tried the "Show in new window" and the "$$Flag" suggestions, but neither works. Is what I'm trying to do possible?

[john9210]

Oops. I forgot to attach the file. It's attached here.

Example.fmp12

[schamblee]

You do not need script triggers or script to count records. You need script trigger to commit record and refresh the screen and you also need 4 Summary Fields.  

Example.fmp12

Edited July 4, 2016 by schamblee