Use an $$ variable, something like:
Set Variable [ $$count ; $$count + 1 ]
The count will restart each DB opening.
A couple of quick questions:
Where do I place the "Set Variable [$$count; $$count + 1]" ? Does it go in the script? And how does this information get saved into a field for the record?
Thank you for your help.
Where do I place the "Set Variable [$$count; $$count + 1]" ? Does it go in the script?
And how does this information get saved into a field for the record?
May be that it it better for you to create a global field (gCount) and then the script:
Set Field [gCount; gCount + 1]"
If you dont want it reset or you want to track the users that execute it you could keep the value in an actual table by storing it via a DB close script
Im sure by doing this kind of thing you could also stop the script from generating email based on the count
By storing the data in an actual table you could also restrict the generation based on date and or user as well.
All you need to do is store some information in some global fields then relate the tracking table to the global fields
I use whole tables of global fields for things like this. (Be sure to create one record in the global table because it wont work right otherwise. It can be blank it just has to be there. Cant tell you the amount of frustration that Ive had when Ive forgotten to create the record)