One Database Affecting Another

[lonesomejubilee]

I don't know if this is the right place for this topic, but here goes. I have a database hosted and multiple people using them at once. I want to know if there is a way for a user to perform an action that will then make my local database perform a script. For instance, if a user selects a certain drop down box category, it will set in motion a script that will notify my immediately. Currently I do this through a combination of apple script / mail. I just wanted to be able to do it all inside filemaker.

I was thinking about doing it based on ip so the "warning" would only run if the computer's IP would be "X" so everyone would not see the warning i want to see...

thanks...

[bcooney]

I have [color:blue]a database hosted and multiple people using [color:blue]them at once.

It's not clear whether you have one file hosted and used by many users, or several files hosted and used by many users.

that will then make my local database perform a script.

A "local file" is a file that is not hosted, and is on your workstation. Is this what you have? If so, why is this file local and not on the FMS?

Currently I do this through a combination of apple script / mail

Maybe if you describe what "this" is in more detail, we can offer alternate techniques.

[lonesomejubilee]

Sorry i wasn't very clear. Basically I have a database hosted in FMS 11 and about 30 users. When a person makes a specific entry, say "Fire" (chosen from a drop down box of possible events), it automatically sends the server an email, which arrives in my inbox and the computer actually announces, "There has been a fire reported".

This is done through scripts / mail / apple script. It's dandy because I have multiple things going on and I don't have to actively monitor one machine, it will announce an important event like that.

I also use iCal / Applescript combinations to run automated reports every 24 hours, or I can email the system itself and it causes an applescript to run a report and email a pdf back to me.

My question is this...

I do all this stuff through the combined programming of filemaker, applescript, and apple mail.. But I would like to do more of this type of stuff through filemaker alone. How could i scheme a thing where if a person were to select "Fire" from a drop down box, it could trigger a pop up or a script but only appear on one machine, not all 30 users. I use Mail/Applescript because that "Fire" warning will then only go to me, and no one else. I want to do it all in FileMaker.

I hope that was a little clearer.

LJ

[bcooney]

OK. I would investigate server-side scripting. By setting flags in records, a server script, scheduled to run as often as you need, would find those records and do whatever you want (email you, create other records, run other scripts).

EDIT: On further consideration, it seems like you want much more than an email sent (which simply could be part of a OnRecordCommit script trigger). The "announce" part stumps me.

Edited September 25, 2010 by Guest

[Vaughan]

I want to know if there is a way for a user to perform an action that will then make my local database perform a script.

No.

That's not the way to go about what you want to do anyway. You're trying to push and FMP only pulls.

Set the local database up to run a "check" script every n minutes. This check script looks for record with "fire" and issues a warning accordingly.

Something like this can only really be done with script triggers and for that you'll need FMP 10 and later.

[Fitch]

You may want to check out the Troi Activator plugin. It has a feature that allows a FileMaker client to trigger events on other FileMaker clients on the network.