Running Script when dropdown list accessed

[brycare]

Hi. I'm not sure if this is the correct forum for this but here goes...

I have an Invoice Status field which the user can change by means of a dropdown box. What I need to do, is to write to a log file every time the user chooses a new status. How do I do this?

I've been trying out a test script (I set the field as a button which performs the script) as follows...

Allow User Abort(Off)

Go To Field[select/Perform, "Status"]

# add to log file using the new value of the "Status" field

Exit Script

However, when trying to add the new status value to the log it doesn't work.

It applies the addition to the log using the old value of the "Status" field and not the new value (i.e. if the user is changing the Status from "Awaiting Payment" to "Paid", then the value added to the log is "Awaiting Payment" and not "Paid").

Anyone have an idea how I could accomplish this?

[DykstrL]

It sounds like you need an Audit Trail solution.

Do a search on the forum for "audit trail" and "CobaltSky". He has an excellent one that will work for V6. It also does not require any scripting.