If ( NOT Mod( Get ( RecordNumber ) ; 50 ) )
Sent from miPhone
@beverly, Does your script step pause at the 50th record, or every 50 records...just curious.
The Get ( RecordNumber ) if inside a loop which goes to the next record, would give you the 50th row/record. Do what you need inside the IF test.
PS. The Mod ( ?? ; 50 ) returns 0 for EVERY multiple of 50, so 50 & 100 & 150, etc. The NOT just turns the 0 to 1 (or TRUE) to trigger what's inside the IF.
Sent from miPhone
to add ... inside the IF statement just place a Pause Script script step set for 30 seconds.
Thanks @beverly for the detail description.
I should have guessed that Beverly would come up with the solution. I used something very similar:
If[ Mod($counter; 50) = 0]
Same result. I could have used the Get(RecordNumber) but I was already setting the $counter variable for each record to show a result at the end. The process runs on a different layout, so the end user has no idea how many records are being processed.
The frustrating part was that the client was sitting with me and I had explained that it was probably going to be a complex process to set up. The end result looked really simple which was somewhat embarrassing.
The end result looked really simple which was somewhat embarrassing.
You need to tell them that great works of art always only *look* simple to the simple-minded uninitiated layperson beholder.
Even better, try to never let a client look over your shoulder.
We do the exact opposite. We have a special room called FTAC (FileMaker Technical Assistance Centre) (think MTAC from NCIS) which has a 65" TV and a comfy sofa. We actively encourage clients to come in and watch us work on their solutions. They see everything, including our mistakes. Clients get a better understanding of how their database works. They get input into how it looks and it pretty much eliminates the need for training. Plus, they never query their bills because they were there watching it happen.