Filemaker 6 auto print changes

Hello,

I am looking for a way to automatically document if a record changes  or
 when a record is added or deleted.
It can be in a form of a report a record being printed with changes anything that can be documented automatically.

I do not want documentation if a record it just opened and value is not changed in a field.(viewed only)

What I am trying to accompish is to no longer have to get handwritten forms from our client when they change something in a database, it can automatically be tracked.

Thanks in advance!


kcassoneAsked:
Who is Participating?
 
lesouefConnect With a Mentor Commented:
tracking records changed is quite easy, a simple modification date can do this.
but tracking which record has been changed means to remember the previous value of each record...
I think I would write a script to edit records; it would
- export the record to change to a 2nd temp database
- compare the edited record with the external record, field per field, then store the changes in a field called "last_change",
- delete the external record.
0
 
rogierConnect With a Mentor Commented:
I understand you just need a report when a record is changed. Here is another solution:

1. in "field behavior" disable editing for all fields in browse mode
2. make a button in the layout that triggers a script (see 4.) and switches to a layout that you call "modify_records"
3. on the new "modify_records" layout, put only global fields. Make sufficient global fields, one for each "normal" field
4. make a script that pastes all info from the "normal" fields into the global fields
5. let the user modify the fields according to their liking
6. make a button (call it "update!") that prints the "normal" fields next to the global fields in a report (or email or pdf)
7. continue the same print script with the steps needed to paste the global values into the "normal fields"

This way you will get a hard copy or email every time someone changes a record. The printout nicely shows the original data next to the new data. Of course, you can add additional data like record ID, name of the one who modifies, etcetera.

If you need real syntax let me know.

Rogier.
0
 
lesouefCommented:
tremendous work if you have a hundred fields... ok if you have 10 or so!
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
rogierCommented:
he might have just a few ;-)
0
 
rogierCommented:
0
 
kcassoneAuthor Commented:
I will be taking a look this week.
Thanks
0
 
kcassoneAuthor Commented:
still pending...
0
 
kcassoneAuthor Commented:
have not forgotten question.still pending
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.