Trim ScriptTrigger that will work for any field

[geraldh]

I know that there has to be a way to do this; and I don't want to make a Script Trigger for every field that needs this.

 

I thought that a Script Trigger OnObjectExit like this would work, but I am getting an error (102: Field is missing ).

 

Set Field By Name [  Get ( ActiveFieldName ) ; Trim ( Get ( ActiveFieldContents ) ) ] 

 

 

Am I doing something wrong, or am I misunderstanding Set Field By Name, or is there a better way to go about this?

 

Thank you

[comment]

I don't want to make a Script Trigger for every field that needs this.

 

Why don't you use the option to auto-enter a calculated value (replacing existing value) =

Trim ( Self )

As for your question, Set Field By Name[] requires a fully qualified field name, which can be calculated as =

Get ( ActiveFieldTableName ) & ":" & Get ( ActiveFieldName )

[geraldh]

Thank you comment. Works like a charm, and simple enough!