This is called a robot file or robot client.
We do this all the time to schedule a script that can't run correctly as a server side script.
I created a simple file with no tables--just a script set to run when the file is opened.
The script has two lines:
Perform Script [//specifies a script in the hosted file on the server]
When you set up the Perform Script step, you can select "add filemaker datasource" from the drop down and select the file from the server (just like using open remote).
Note: be careful of infinite loops in the hosted file's script. If you trap yourself in such a loop, the only way to terminate the loop (and you may not notice that the script is still running), is to close and re-open the hosted file.
So I have a very basic file called "Trigger" set up with no tables, just a script set to run when the file is opened.
I'm probably missing something very simple here... but how do I tell Filemaker when it opens on that computer, to open this specific file as it opens? That is the step I'm missing at the moment. Is this possible?
We're wanting this to run in the middle of the night while noone is here, so all of the machines would generally be logged off.
Make a shortcut similar to this:
what does the script do that you are trying to trigger?
Where would I make this shortcut?
We are trying to trigger a script that imports and exports, from our SQL server, data from our website.
Set up Scheduled tasts to open (run) the file instead of the filemaker application.
Would it work as a server side script?
The whole point of this thread is to run a script that runs correctly from a client session but would fail if run from a server scheduled script.
Server scheduled scripts have some major limitations and this is an old, oft used work around to solve that problem.
Thanks Guys! Phil I really appreciate your help! That nailed exactly what we wanted to do.