Calculation not triggering modification

[arndbr]

Hello,

I have a simple calculation that changes a field based on a difference between current date and the creation date of the record. The calculation evaluates some fields in the record, and if those fields contain a certain value AND the date difference is greater than x, another field is changed. However, when this calculation changes the field, the modification time and date of the record are not changed.

This is an issue for me, as I need to export records that have been changed since the previous export. The records that were changed by this calculation don't get exported, because the modification was not triggered.

I have searched the forum for a solution, but I couldn't find the solution to this particular issue. Any help would be greatly appreciated.

Thanks, Arnd

[comment]

The records are modified when the referenced fields are modified. A mere passage of time will not modify a record.

Perhaps you should make a stored calculation to track the modification time of certain fields. Then you can find records that were either modified since the last export, or didn't qualify for the last export but do now.

[arndbr]

Can you clarify what you mean? I am not sure I get it, or actually, I am sure I don't get it...

[comment]

Which part?

[arndbr]

This part: "Perhaps you should make a stored calculation to track the modification time of certain fields." How to create that calculation.

[comment]

Define a new timestamp field and make it auto-enter a calculated value (replacing existing value) =

Let (

trigger = FieldA & FieldB & FieldC

;

Get (CurrentTimeStamp)

)

[arndbr]

Thanks! Will try.