Clock out script efficiency

[gilbenl]

This is my first, what I would call, complex script and was hoping to get some feedback on its' efficiency. It is used in a timeclock solution for a filemaker GO "app." It is intended to perform the following actions (same order as in script attached):

 

1) Verify all records from that date are marked as complete. (eg: Cases::Complete=1)

 

2) If okay, go to time clock, sort based on "time out," making sure the most recent record is empty. If not empty-->display error, unsort

 

3) If empty, time out as current time

 

4) Email copy of entire DB.

 

It performs all of these actions without error, but I'm sure there's a way to make it better. Thanks in advance for the input.

 

Clockout.tiff