[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 275
  • Last Modified:

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!


0
kcassone
Asked:
kcassone
  • 3
  • 3
  • 2
2 Solutions
 
lesouefCommented:
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
 
rogierCommented:
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now