Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 7330 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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.

Posted

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.

  • 2 weeks later...
  • Newbies
Posted

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.

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.