You are here:

Filemaker/monitor what is done by the user on filemaker

Advertisement


Question
QUESTION: Hello, i am Yoland want to ask how to make report about what is done by the user.

I have 6 tables that are interconnected call it (source) (alamat) (Print) (rekapan) (History alamat) (history FIFO). On each table there field called it modified by and created by auto containing each user account name.

my question is how in the layout can create a report that contains what has been done including user delete a record, making the record

This view that I want to apply on the layout

example:
user     Date       Time    decription
Jodi     12/26/2012 10:15   delete records in the table rekapan, recapan layout view,


What should I do? script how should I use? Give me an example sriptnya too.

Thank you for its support

ANSWER: Hi Yolanda;

I am sorry for taking so long to get back to you.

This is something a lot of Filemaker users want to do, but there is no easy way.   You will have to make a separate table just for this report.   Then anytime someone deletes or creates a record, it will have to be done with a script, and the script will go to the other table and create a new record and document the action.

Do you understand?

Jamey

---------- FOLLOW-UP ----------

QUESTION: yes i am understand... which condition of formula or value how should i use??

Answer
First, create a separate table called Events

Then go back to each of your original tables and create scripts that will log the information to Events and attach them to buttons.  The events will only be captured if the user clicks the button.   For example;

Set Variable "Variable A" (Field A)
Set Variable "Variable B" (Field B)
Go to Layout (Events)
Set Field (User;User)
Set Field (Field A; "Variable A")
Set Field (Field B; "Variable B")
Go to Layout (Original layout)

And so on.   Do you see what this does?

Email me directly at jameykey@jkat.com

Jamey

Filemaker

All Answers


Answers by Expert:


Ask Experts

Volunteer


Jamey Key

Expertise

NEW and INTERMEDIATE USERS. WHAT CAN FILEMAKER PRO DO FOR ME? I have been using FileMaker products for over 10 years and have basic knowledge in all areas of FileMaker database set up and use. I`m not prepared to answer questions about complex situations or calculations but can help beginners and intermediate users set up and use FileMaker databases.

Experience

Have been using FileMaker since 1989 in our business. We have 10 users on the network who use these databases every day. Our largest databases have had over 30,000 records at one time. In 1995 one of my files was chosen as "Most Unique Database" in a contest sponsored by Claris, maker of FileMaker. Recently I have developed a set of files for new computer system installed at our church.

©2016 About.com. All rights reserved.