Jump to content

modification reports.....


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

Recommended Posts

Hi guys,

I have been working on a script that reports any changes made to records.

I.e the number of modifications done to a record by a user.

I have been quite successful in achieving this, problem is the most recent change replaces the one that was there before, making it hard to track the original values.

I would like to make it possible to store all modification values.

say.

Modification(a) name-"john"

(B) name-"jahn"

© name-"jhn"

Any ideas?

anita

Link to comment
Share on other sites

I presume you are storing the user name in a text field and that this was achieved using 'set field'.

If so make the calculation read something like;

Set Field,User History,User History&^&Current UserID

[^=Carriage return]

All this does is add a carriage return and the name of the new user to the existing data.

Link to comment
Share on other sites

If you want to track all changes made to a database, you may want to try creating a separate "log" database to do this for you. This would require some creative scripting.

The basic idea is that each of the scripts in your current database that create, delete or modify a record will call a script in the log database which will create a new record and fill in the unique record id from the original record, the details of what was modified, by whom, when, etc.

Hope this gives you some ideas!

Link to comment
Share on other sites

This topic is 7190 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
 Share

×
×
  • Create New...

Important Information

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