December 2, 201015 yr I have a filemaker solution hosted on a server, but I cannot run server side scripts. I need something in my filemaker database that will run every 24 hours regardless of wether it is open or not by a client. My goal is to have a script that will run every 24 hours and produce an email with an attachment of my current stock for about 12 items. The email and attachment I have created, but I don't know a way to run the script automatically. Any ideas?
December 2, 201015 yr Author it's hosted by online by a 3rd party service and I don't have access to run a server side script on their side. I can of course run as many and I want within my database, but not on their server.
December 2, 201015 yr Create a new database that performs a script when it opens. That script should perform your email script in the hosted database, then close the current database. You can use a scheduled task in your OS to open the new database every 24 hours.
December 2, 201015 yr Author I don't think that would work since many employees open it a couple times a day.
December 2, 201015 yr I don't think that would work since many employees open it a couple times a day. I don't think you understand the process, because that's not a valid argument. The concept is similar to an "opener" file: http://help.filemaker.com/app/answers/detail/a_id/5296/~/how-to-create-a-way-to-quickly-open-networked-files-in-filemaker-pro Instead of just opening the database, this file performs a script, then closes. Also, it's opened via a scheduled task. Since you only want the script to run every 24 hours, schedule it to run at night when nobody is using the computer that runs the task.
Create an account or sign in to comment