How to get FileMaker to Update Field with loop counter in loop?
I was doing some script benchmarking using a test file with 500,000 names to run a script. Naturally, I wanted to get some kind of update on how far FM has gotten in a record list this large so I created a field to update the loop counter from inside the script's loop.
Yet, regardless of what I try (refresh object, refresh window, etc.), FM will NOT update the loop counter field during the script execution.
In the debugger it works fine.
I also tried, as you can see in the script below to only have FM update the value every 1,000 loop iterations, but FM won't work then either.
Putting a Refresh Window just before End Loop should work. Might need to also commit records since this is a field that you are changing.
You can even set up a repeating field (gasp) with conditional formatting to serve as a progress bar...