Is there a way to cause a script to run based upon some pre-determined value in a field.

What I would like is if the field value = (X), run script (X)

and if the field value = (Y), run script (Y).

If the field value = something other than (X) or (Y), do nothing.

Is this do-able? [

Hello Jarvis,

What you are describing is not (at least not yet) a native feature of FileMaker as such.

There are a few ways to simulate this kind of functionality within certain limits, and there are a number of demo files around that show variations on ways it can be done. One such is the demo available at my web site at:

http://www.nightwing.com.au/FileMaker/demos3.html#d7

You'll find other demos with related approaches (variations on the same general theme) on numerous other sites around the web.

Beyond that, much more flexible ways to trigger a script on exiting or on modifying a field can be implemented with the addition of any of a number of third party plug-ins. Several of the better known of these are Troi Activator, SCRIPTit and oAzium Events:

Troi Activator:

http://www.troi.com/software/activatorplugin.html

oAzium Events:

http://wmotion.com/events.html

Comm-Unity Networking Systems:

http://scriptit.cnsplug-ins.com/

There are various others, but the above three are well known well supported, are available as free demo downloads and are fully x-plat. Each of them offers other features as well as a range of script triggering options, including the kind of thing you're currently looking for.

Isn't this enough?

If [state = "CA"]

Perform Script ["Compute CA Tax and Total"]

Else

Perform Script ["Compute Total"]

End If

Copyright