tracking modifications

[Mr Nic]

Howdy folks!

Can't seem to get this one to work for me.

I need to create a history of record modifications that are accessible to users.

I know repeating fields are a bane and with a "Modification date" it just rolls over and I just keep falling over with my script - maybe I've been staring at the screen too long.

What I am after is capture of duplicate Modification date entries ( I tried setting a portal but it always rolls over the top entry) and I want to keep atleast 10 of them.

I have a unique serial number (calculated not FMP generated) and repeated need to update a record.

All thoughts appreciated.

thanks in advance

Nic

[BobWeaver]

I didn't really think this would be possible without a script, but I started playing around with this and discovered a really bizarre trick to make a field modify itself.

Anyway, here is what you need for fields:

code:

---

SerNo, Number, Autoenter Serial Number

ModTime, Time, Autoenter Modification Time

ModDate, Date, Autoenter Modification Date

SerLkp, Calculation (Number) =(ModTime * 0)+SerNo

cModHistTemp, Calculation (Text)

=ModHistory & DateToText(SelfBySerLkp::ModDate)

& " - " & TimeToText(SelfBySerLkp::ModTime) &

" - " & Status(CurrentUserName) & "

[Mr Nic]

Originally posted by BobWeaver:

I didn't really think this would be possible without a script, but I started playing around with this and discovered a really bizarre trick to make a field modify itself.

Anyway, here is what you need for fields:

code:

---

SerNo, Number, Autoenter Serial Number

ModTime, Time, Autoenter Modification Time

ModDate, Date, Autoenter Modification Date

SerLkp, Calculation (Number) =(ModTime * 0)+SerNo

cModHistTemp, Calculation (Text)

=ModHistory & DateToText(SelfBySerLkp::ModDate)

& " - " & TimeToText(SelfBySerLkp::ModTime) &

" - " & Status(CurrentUserName) & "

[Steverino]

This is genius!!

[Steverino]

I'm playing around with this, and I realized that you can even get a history if one particular field in the record is updated (but not when others are updated).

All you need is a time field with an auto-enter calc of the time when the field is updated (I used If(field ≠ ""; Get(CurrentTime); "").

Then you use this field (rather than the general time updated) for the relationship key (SerLkp). The cModHistTemp can contain any information for the history.

I'm so thrilled!

[comment]

Which version do you need this for? Because starting with version 7, there are much better methods available:

by Bob Weaver

by Ray Cologon

[Steverino]

I'm on 8.5. What better method? (It seems to work well.)

[comment]

What better method?

My first post has links to two of them.

[Steverino]

Sorry. Thanks, I'll check these out.

[AudioFreak]

I just took a look at Rays Demo and must say that is pretty slick.

I like it :P