I was wondering if anyone could tell me a way to get a script to run automatically after a field gets modified.

The script is designed to look-up a value in a different record in the same table and paste that value into the new record.

Cheers!

I believe there is a free event script plug in around that will do what you need. Try looking in the plug-in section.

Thanks!

I went and got the EventScript plug-in and am trying to get it to do want I want... However, I'm confused as to what the "Get(FileName)" part of the script is supposed to be doing.

Is it something I leave blank if the data is in the file that I am running the script it?

Cheers!

However, I'm confused as to what the "Get(FileName)" part of the script is supposed to be doing.

I guess you mean, "part of the calculation" ?

If so, the Get(FileName) part is the built-in function of FileMaker that returns the name of the current file.

You can also use an hard-coded 'absolute filename' as per example "YourDatabase.fp7" but if someone is later renaming the file, then the trigger won't be fired anymore.

The parameters accepted by EventScript are :

1. The name of the file where the target-script is placed

2. The exact name of the target-script itself

3. The optional script parameters if you want to run this target-script with special parameters.

Each of the EventScript parameters can also be provided through the content of predefined fields. This is the 'relative' approach.

HTH