Filemaker pro experts,
I've created a reasonably complex database but with very little knowledge of FMP11. I have a rudimentary background in programming but I have to admit it was a long time ago although bits are coming back quicker than I expected.
I have created a report that effectively produces a job sheet for employees. It works really well in find mode in the browser but I want to create a script to automatically save each individual employees work for the month to a predetermined location.
Rather than bombard you with loads of code, I've explained in simple terms what I've done.
TABLE A - Booking_items includes two critical fields:
bkit_date ( so this is the booking date )
Bkit_employee ( this is the person doing the job on that date )
In browser mode, I click find, type in the '*/3/2012' and 'Matt' in the employee field and click on perform find and sure enough all of the jobs for matt in the month of march appear. I then subsequently save the list as a PDF or Excel spreadsheet.
What I want to do is this:
-Set up a script that checks if all employees have work in a given period
-Then perform the above operation for each employee that has work
I just don't know how to do it. Do I use loops? do I use filters, perform finds? I'm completely lost and out of my depth. Any help would be greatly appreciated.