Daily Script

[ABC]

Looking for a way to create a script that runs daily, without having to restart my database file every day. Want to review a date field, and prompt an alert when certain conditions are met and a date field equals the current date.

Only idea I have is a start-up script, but that requires quitting the file every day.

Something easy I am missing?

Thanks!!

[Fitch]

One option is to create a separate file that has one script, which you set as the startup script. This script will have two steps: 1. run the daily script in your target database, and 2. close itself. You could then use a scheduling utility such as iCal or CronX to launch this file once a day.

[ABC]

Ah, creative! That is certainly a workaround I can use if there is no internal Filemaker solution. Thanks for the idea, I can make that work.

marK

[Fitch]

You could also use a script trigger plugin such as zippScript. It doesn't do triggers at intervals like some of the commercial plugins, but you can schedule scripts to run at a specific day and time. So each time the script runs, one script step would tell itself when to run again.

[bruceR]

If you have scripts that users commonly use, you don't need any separate files or plugins. You need a single record Resource table, with a date field for last updated. You create your updater script and modify it so that at the end, it updates the new date field.

In your common navigation scripts you add the following:

IF ( Resource::LastUpdated < get( CurrentDate ) )

Perform script [YourUpdateScript]

End If