Event Trigger - triggers too often

[Steverino]

I'm having trouble -- the auto-enter calc with Event Trigger triggers the script too often. I want the script to trigger only when I change a field (and not when I'm running other scripts that don't touch that field). I tried the validation method, but that doesn't work -- it doesn't perform the script until I exit the record, and by then I'm in a new record, and it will perform the end of the script on the new record. What can be done? (I already have a condition in the calc that it won't be executed when a record is new and a field is blank...but this doesn't solve my main problem.)

[flapjacks]

I solved a similar problem by testing for the current layout with an if statement. Could this be your answer?

John

[mr_vodka]

Which Event Plugin are you using? Why dont you post your calculation as well.

[SteveB]

I had a similar problem...drove me crazy. It may be on the wrong tab. Move the calc and trigger to the calc on the validation tab from the auto enter tab.

Steve

[Steverino]

I can't use the validation tab for the reasons I explained above -- the validation in 8 does not take place until the record is committed.

Here's my calc:

If(callername ≠ ""; Status & S4HU_EventScript( Get ( FileName ) ; "Set Status" ; Callsheet); "")

Where callername is a field that is filled in after record creation (and before the script should be activated) and Status is the field that when changed should activate the script "Set Status." As you can see, I'm using the S4HU Event Script plug-in.

[Vaughan]

callername ≠ ""

A better syntax for this is

not Isempty( callername )

[Peter Wagemans]

Put

If ( IsEmpty ( Get ( ScriptName ) ) ; ... )

around your calculation, and it will only trigger when no script is running.