Newbies Csquared Posted October 21, 2004 Newbies Posted October 21, 2004 I am trying to write a script to do the following: Find all employee records with expiration dates (drivers license, car registration, car insurance, etc.) within the next month or so. I would like to make the expiration date a user defined input (can I use a dialog box for the user to input a date?). Then print a report that lists each employee's name with upcoming expirations and whichever fields and expiration dates meet the criteria. I have experience w/ other programming and database design, but I'm really having a hard time with Filemaker (and the books I'm using don't have good examples to follow.) These forums have better information than the books, but I'm having difficulty putting it all together. Thanks in advance for any assistance.
transpower Posted October 21, 2004 Posted October 21, 2004 You will need to create a script to find records which have an expiration date between some beginning date (perhaps Get ( CurrentDate ) ) and some ending date (perhaps Get ( CurrentDate ) + 31. The report with the employees' names, upcoming expirations, etc. would then print for your found set. The design of the report would be up to you--it wouldn't necessarily have to resemble any of your input layouts.
Newbies Csquared Posted November 1, 2004 Author Newbies Posted November 1, 2004 Thanks for the help Transpower. It took two packages of Chocolate Hersheys Kisses and 2 six packs of diet coke (in 48 hours), but I got the dialog box and script written for the find operation. Can anyone point me in the right direction to only print those fields with upcoming expirations? I have 12-15 fields that have to be tracked with expiration dates for each employee and only want those applicable fields which are about to expire to print next to the employee name on my report. Any hints? Thanks much.
Recommended Posts
This topic is 7330 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now