Flag True Modification

[bcooney]

Is there any way to set a flag on a record when a certain field is modified, without a script? I want to flag a date change. When I use flag=Evaluate( "1", dateField), it'll set the one if I enter the field, but do not change the value. I need to capture only a true modification.

[bcooney]

Well, I realized that I can compare my line item date to the parent date and if they do not match anymore, then set the flag:

Evaluate (

"If(Date_Due ≠ lnli_LN::Date_Due ; 1; flag_DueDateEdited)"; Date_Due)

Anywho, it would be interesting to know if capturing a true modification can be done if a comparison field is not available. I was thinking of creating a calc field and checking to see if the results of the calc changed.

[comment]

I would suggest not to use Evaluate() for triggering. Still, I don't see why merely entering the watched field should trigger the evaluation. Is it an unstored calc? I believe a number/text field with auto-entered =

Let ( trigger = Datefield ; 1 )

should work fine - provided you can keep it at 0/empty when Datefield is filled for the first time.