Jump to content

tracking modifications


This topic is 6295 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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) & "
Link to comment
Share on other sites

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) & "
Link to comment
Share on other sites

  • 6 years later...

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!

Link to comment
Share on other sites

This topic is 6295 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.