Scheduling Scripts

[arbelbedak]

Hello,

 

I have created a task list for our company and I created fields that allow the users to enter a date on which they would like to receive an email reminder for that task (i.e. meeting scheduled, call so and so, etc.) 

 

I had everything set in place, and originally used various triggers to set off the script. First, I had a button that needed to be pressed daily (quite annoying). Then I had it set as a script trigger for when the first person opened the database on a given day. That still wasn't working out well. 

 

Any ideas or guidance for setting a scheduled script to go off at certain times of the day? Is that possible?

 

I am working in FileMaker Pro 11.

 

Thank you!

[Lee Smith]

Automatic message

This topic has been moved from "Advanced & Developer Features" to "Managing Scripts".

[Wim Decorte]

If your file is hosted on FileMaker Server you can create a server-side script schedule to loop through the records every x minutes and send out the emails

[arbelbedak]

I saw something about server side scripts and was a bit confused about how to set them up. Do I need a separate program? I saw something about ScriptMaker or something like that. Could you provide a bit more info? I appreciate the help!

[dansmith65]

Server side scripts require FileMaker Server. If you are only using FileMaker Pro, then you can use a plug-in that runs a script periodically. This can interfere with what the current user is doing, though. Here is a plug-in function you could use: https://github.com/dansmith65/ooScriptMaster/wiki/Functions#oosm_scriptcronadd-scriptname-parameter-schedule-options

[arbelbedak]

Sorry for being unclear. I'm on a FileMaker Pro license on my computer, but the databases I built are on a server on FM Server 11. I'm just not familiar with setting up server side scripts.

[dansmith65]

I hate to say it, but I think the answer is to RTFM: http://www.filemaker.com/support/product/docs/fms/fms11_help.pdf