Mr Nic Posted February 22, 2001 Share Posted February 22, 2001 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 More sharing options...
BobWeaver Posted February 22, 2001 Share Posted February 22, 2001 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 More sharing options...
Mr Nic Posted February 23, 2001 Author Share Posted February 23, 2001 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 More sharing options...
Steverino Posted March 1, 2007 Share Posted March 1, 2007 This is genius!! Link to comment Share on other sites More sharing options...
Steverino Posted March 1, 2007 Share Posted March 1, 2007 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 More sharing options...
comment Posted March 1, 2007 Share Posted March 1, 2007 Which version do you need this for? Because starting with version 7, there are much better methods available: by Bob Weaver by Ray Cologon Link to comment Share on other sites More sharing options...
Steverino Posted March 1, 2007 Share Posted March 1, 2007 I'm on 8.5. What better method? (It seems to work well.) Link to comment Share on other sites More sharing options...
comment Posted March 1, 2007 Share Posted March 1, 2007 What better method? My first post has links to two of them. Link to comment Share on other sites More sharing options...
Steverino Posted March 1, 2007 Share Posted March 1, 2007 Sorry. Thanks, I'll check these out. Link to comment Share on other sites More sharing options...
AudioFreak Posted March 2, 2007 Share Posted March 2, 2007 I just took a look at Rays Demo and must say that is pretty slick. I like it :P Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6440 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 accountSign in
Already have an account? Sign in here.
Sign In Now