Hi,

I would like to create a pop-up window with a message on a given date.

For instance: At the date of "contract expires" in the database, I would like to have the message to appear the day before.

Thanks in advance.

Nicolas (Newbie)

You must create Standart Open Script which works when you open file and Shows dialog about "contract expires"

More precisely, the open script would check the current date against the "contract expires" field and pop up a warning if the latter equals the former plus 1.

Thanks Guys, the question is , How do I write the script to have the date checked and compare to "Contract Expires" etc..

Two part question seems to me.

1) Do you want checked upon opening file or do you want a script to run on the day prior to contract expiration? Plugins exist for scheduling script running on a database that is currently open, check filemaker.com

2) Do you need help on how to write scripts?

if ( contract_date ? get ( currentdate ) + 1 )

Show Custom Dialog "Do your contract"

end if

Thanks for the tip.

What I would appreciate is a transcript of the full script since I'm not familiar with scripting.

My Idea is, when I open my customer Database to have my records cheked in the field "Contract Expires" and have an alert message saying that "Customers' 1, 4, 7, etc... Contracts expire in ... Days. I figure out there is a "loop" script that can do that in association with "If" but I can't handle it.

Thanks again for any help.

Nicolas

How about a script that finds all records with Contract Expires and then create a layout that presents the information in a reasonable fashion upon startup? This would much easier for your users than dealing with alert messages on each and every customer with a contract deadline coming up. And a bit easier. First create a layout with a header stating something like "Contracts about to expire". Then in the body but a few necessary fields such as contract date expiration, Customer name... Create a script that goes like this:

GoToLayout "Name of above layout"

Enter find mode ---don't pause or remember find's

Set field contract expiration date "< " & getastext ( get ( currentdate ) + 1 )

Perform find

Then call this script when you open the file. Above written for FM7 so you may have to interpret a bit for 6.

How about a script that finds all records with Contract Expires and then create a layout that presents the information in a reasonable fashion upon startup? This would much easier for your users than dealing with alert messages on each and every customer with a contract deadline coming up. And a bit easier. First create a layout with a header stating something like "Contracts about to expire". Then in the body but a few necessary fields such as contract date expiration, Customer name... Create a script that goes like this:

GoToLayout "Name of above layout"

Enter find mode ---don't pause or remember find's

Set field contract expiration date "< " & getastext ( get ( currentdate ) + 1 )

Perform find

Then call this script when you open the file. Above written for FM7 so you may have to interpret a bit for 6.

How about a script that finds all records with Contract Expires and then create a layout that presents the information in a reasonable fashion upon startup? This would much easier for your users than dealing with alert messages on each and every customer with a contract deadline coming up. And a bit easier. First create a layout with a header stating something like "Contracts about to expire". Then in the body but a few necessary fields such as contract date expiration, Customer name... Create a script that goes like this:

GoToLayout "Name of above layout"

Enter find mode ---don't pause or remember find's

Set field contract expiration date "< " & getastext ( get ( currentdate ) + 1 )

Perform find

Then call this script when you open the file. Above written for FM7 so you may have to interpret a bit for 6.