script triggered by field content

[Harald]

Dear all,

is it possible to trigger a script (Perform script [...]) based on a current field content?

The idea is to have all desired script names in a separate table; based on the entries = names of scripts I would like to

* copy that special script name from the table and

* pass it over to the Perform Script-Step so that this script step just performs the script which was copied before...

Maybe there is a solution based on parameters/variables but I am not able to figure it out....

Any ideas?

Brgds Harald

[Raybaudi]

Yes, you can ... but not with FM6 (or so I think) !

And even with FM7/8 you have to use a plugin such EventScript or ZippScript

For example you may define two fields:

The first is a calc (result text) field:

ScriptNames

with calc:

[color:green]ScriptNames ( Get(FileName ))

The second is a text field with option AutoEnter/Replace, with list coming from field ScriptNames:

ScriptToFire

with calc (for AutoEnter)

[color:green]Case(

not IsEmpty ( ScriptToFire );ScriptToFire & S4HU_EventScript( Get(FileName) ; ScriptToFire ; "" );

ScriptToFire)

[drossi]

There is actually an plugin that comes with FM 8 Advanced that is supposed to be an example of how to create a plugin that will trigger a script when a field changes. I think you can find it at http://www.databasepros.com/. It is called MacExample.fmplugin. There is an example database included. I think this also existed in FM 7 Developer also but I never had that version so I'm not sure.