increment a counter field when another field is modified?

[g.bevan]

Hi, I'm trying to define a calculation field that will count the number of times another field is modified. For example if field "Trigger" is modified, field "Counter" is incremented by 1. Any ideas?

Thanks - Grahame.

[BobWeaver]

There's also the self-modifying field trick which uses a self-join relationship, a calculated field and a look-up field to update whenever a change is made.

[Kurt Knippel]

quote:

---

Originally posted by Grahame:

Hi, I'm trying to define a calculation field that will count the number of times another field is modified. For example if field "Trigger" is modified, field "Counter" is incremented by 1. Any ideas?

---

Either control editing of that field via scripting or use one of the various script scheduling plug-ins (Azium Events or Troi Activator) to run a script that does the incrementation after you exit from that field.

[Anatoli]

I am not incrementing the counter, there is the function:

Status (CurrentRecordModificationCount) The number of times changes to the current record have been committed.

Copyright

[Kundinger]

Hello Grahame,

You can do this by creating a 'log' field to keep track of every change to the field. Then create a 'count' field to count the number of items in the 'log' field:

"LogField" (calc, text result)

<< GetField("LogField") & GetField("DataField") & "