With help from Howard Schlossberg (Copy/paste two find parameters,
10/19/05), I was able to complete a script that updates the Balance
Forward field in my accounting database.

Now I'd like to trigger the script whenever the contents of a specific
field change. For example, if the companyID is changed, the script
returns the correct Balance Forward for the new company. If the month is
changed, the script returns the correct Balance Forward for the new month.

Both the companyID and the month are pop-ups, using value lists.

The user could launch the script by clicking a button -- "Refresh
Balance Forward" -- but is there any way to trigger it without any
additional user input? I think I'm looking for an onChange event
handler, but I can't find one.

Thanks.

Dave McCullough wrote on (10/20/2005):

Assuming you're in 7/8, EventScript (FREE plugin) from
http://www.softs4humans.com will do it nicely.

Seems to me I heard of one somebody put together for 6, but I don't
remember the name.

Matt

Matt Wills wrote:
EventScript provides exactly the functionality I was looking for.

If you decide to use it, you should know that the faq's on the web site
provide relatively simple examples, one of which worked perfectly for
me. The sample file provided by the developer is much more complex --
well beyond my comprehension.

Thanks for steering me towards this solution.

Troi activator plugin does this too...

and so does also the oAzium Events plugin.
Remi-Noel


"fm-training" <googlegroups (AT) fm-training (DOT) co.uk> a écrit : ...

Dave McCullough wrote on (10/20/2005):

No prob.

I've incorporated ES pretty heavily into a sales leads / client tracking
solution I've built for myself and colleagues. I use it for triggering
windows opening on creation of an order, menus from dropdowns and popups,
all sorts of stuff.

One thing to be aware of if you're in FM8:

Don't put both an EventScript trigger and a mouseover ToolTip on the same
field. Gaston (the developer) told me he had discovered that the tooltip
apparently gets interpreted as a change to the field, and the trigger fires.

You might be able to build a trap into a script to work around that
behavior, but otherwise it looks dangerous, triggering scripts by mousing
around on a layout. Might be useful for a game, though.

Matt

fm-training wrote on (10/20/2005):

and

Remi-Noel Menegaux wrote on (10/20/2005):


I have no experience with oAzium Events, but Activator is cool, sending
signals to and executing scripts in FM files on the other side of the
planet.

They could both probably handle Dave's requirement, but all other
considerations being equaL, why would you pay for either, if the job can
be done quite well for free?

Matt

And we all prefer to pay (oAzium = $129; Troi = $89) when there's a free
solution available.

Bill

"Remi-Noel Menegaux" <rnmenegaux (AT) free (DOT) fr> wrote