Has a field value changed?

[John Hamill]

Hello,

I am using JavaScript and I have a situation where I need to reset a particular field to null if another field in a record has “changed value” (been amended by the user).

My understanding is that in a field level script, the script will only be executed if a getFieldValue command is included in the script – this is the trigger to execute the script. Once the script is executed, the script will then reference the *new* values that the user has entered.

Considering this, how can I determine if a user has amended a particular field in a record. I have the information that the user has definitely changed some of the data in the record, but how can I determine if he has changed a value in a particular field?

Thanks for any assistance.

• This topic was modified 1 day, 4 hours ago by John Hamill.
• This topic was modified 1 day, 4 hours ago by John Hamill.

[John Hamill]

Addendum:

I am thinking that the only way to achieve this will be to create a new field in the table that contains the previous value of the field that I wish to monitor. Then compare the previous value with the current value.

Any comments gratefully received.

[Brendan]

Hi John,

Ya, I think you’re right. There’s no mechanism to get a value from a field before it’s changed.

Thanks,

Brendan

[Author]

Posts