Looking for help writing a script and report/layout to an existing Filemaker 6 database for the Macintosh.
Script will need to sort through records, flag them (based on start date, end date, or action date), and be able to create a report sorting these records based upon values for several of the fields, by time, and by zip code or location. The goal is to create a delivery log for any given day's jobs.
We will also need to be able to mark that job completed with a person's name and have it disappear from an alternate view (or alternate report) of the deliver log so that we can see all of the day's orders and those left to complete. A requested feature (but don't know if this is possible) would be to list jobs coming up within 2 hours of the current time to be shown in Red or somehow highlighted.