I am trying to figure out a way to test a record for modification.

I have a record that contains perhaps 20 fields, including an auto enter Modification date timestamp field. What I wanted to be able to do was check the timestamp. If the record was modified from when they entered it, give them an option to save it or revert the changes to what existed when they got there. I can't seem to get it to tell me if the record was modified, or if it was, to be able to revert the record to what was there before the user entered the record. Is there an easy way to do this?

Thanks,

Mike

If the record has been modified then you cannot revert the record. The last modification has taken place and the previous record state is now the current. FM does not hold historical data like this.

When reading about the revert record script step, if you have not left the record or committed the record, it says it should be revert-able. Am I understanding that incorrectly?

Also, with the modify timestamp field, won't the contents change only when the contents of a field has been modified on the record?

Ideally if I can't revert, I'd still like to know if a change has actually been made to the file, and if so, perform and action via a script.

Do a search for Audit, or +Field +Modification and you will find a lot of information about this.

Take a look at this file SuperAudit

HTH

Lee

Check out the Get(RecordOpenState) function.

You can also look into FM Dataguard.

http://www.worldsync.com/fmdataguard/faq.html

While audit trail methods seem to be what I need, I work for a notoriously cheap department who want things free, and done yesterday. Some of the audit trails methods are free, but are going to require me to create complex calculations based on the fields in the database. Looks like that will have to be a phase 2 of the project, as I would not be able to implement by end of week for testing.

Oh well, at least it puts me in the area I need to look.

Thanks all......

Well I had 1 idea but it didn't work out...

2nd idea is if there aren't to many fields set up a duplicate table..

Start in table1 all fields locked

Export (or something) to table2 matching fields

If commit - export back to table1

If revert clear fields return to table 1

3rd idea.... although not the best way what about opening the file via FMP Instant Web Publishing? As I recall when playing with it it did have the ability to revert and commit.

Wish I had time to play but I have to drive 3 hrs. to install some cabinets.

Oh Joy!

Mike

check out Matt Petrowsky Suoer Audit Trail. For a subscription of $29.95 for three months. His is as ready to go as they come out of the box. You get to watch a video of how it works .

Hope this helps

Actually, that one is Free for the taking. Link

BTW, it also includes a link to the File I link in my last Reply.

Lee

[color:red]Update

You might be correct, I tried to download it and it won't let me unless I log in. Also the previous Audit Modification technique is also locked, I'm not sure that this is what Matt wants, so I'll drop him a note and see what he has to say.

Edited September 30, 200817 yr by Guest

You could write a script to duplicate a given record, then delete the altered record if the changes are no longer required - or delete the duplicate if they are - if that makes sense!

You could - but you'd be well advised not to:

http://fmforums.com/forum/showtopic.php?tid/181617/post/227590/#227590