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

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) & "

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) & "

This is genius!!

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!

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

by Bob Weaver

by Ray Cologon

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

What better method?

My first post has links to two of them.

Sorry. Thanks, I'll check these out.

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

I like it :P