Hi,

Is there any way for filemaker to run a script at exactly 12am or any other set time?

Thanks

Hi 'Ed1',

YES... and... NO!

- In FMPro... Yes & No... Yes, with a plug-in (3rd party stuff)!

- In FMP Server... Yes!

- In FMP Unlimited (Web)... Yes & No... depending on how you do things with Java, Lasso, etc. (3rd party stuff)!

Hope this helps!

Bob Kundinger

[email protected]

Hi Ed:

One third party plug in that Bob is talking about is called Troi Activator. Keep in mind that this plug in won't work unless FileMaker is at the front. For example, if you have a screen password it will not execute until FileMaker is brought to the "front." There is another plug in called Oazium Events. I haven't tried it.

Ken

You haven't said what platform you're on and whether you need cross platform capability. You can do it without a plugin on Windows. Create an FP5 file that contains only the script you want to run, and use the Windows scheduler to run start the file. Assign the script in the Document Preferences to run on start up.

Steve

You can also schedule an AppleScript to open a file using a product such as ScriptScheduler or as a Chron Job (OS X).

As an alternative, you can use a continuously running looping script in FM to execute a script.

Loop

Pause (for some convient time (say one minute or 10 minutes)

If (Status (CurrentTime) = Time 8, 0, 0)

Perform Script (bla bla bla)

End Loop

-bd

Don't forget that you can also schedule actions with iCal; it doesn't have to be running to work.