Hi all,

sorry if this has been visited, I have tried searching but can't seem to be able to find the solution.

I am trying to do 2 things.

The first thing that I would like to do is have it so file maker logs in to the database as a guest if there has been no 'activity' 5 minutes (assuming that it is opened by a user other than guest).

2. The second I would like to do is for the system to lock a record (this is normally done by manually changing a field to Lock from unlock) if it hasn't been modified after x amount of days.

Would this possible for someone without too much experience?

THX!

Edited October 19, 200718 yr by Guest

Hey Justakid;

There is no mechanism directly in filemaker to execute a script after x minutes of idle time. That is to say, if you opened filemaker and then sat there waiting for it to execute a script, this can't be done.

However; I do this very succesfully using TROI activator. www.troi.com have a look at their website.

As for your other question about locking a record after a period of time; you could also use troi activator to execute a script after xx mins/hours/days and have it lock a record or a found set.

Hope thats helpful.

S

Hi,

If you're using filemaker server 9, you can use a server script for your second request.

About your first request, note that iddle Mode is something a bit hard to determine, as ( for 8.5, I doubt it has changed ), the user is iddle when closing a file, clicking a button even when it changes field data.

HTH

To time out users, I would use zippScript

To lock a record, why don't you do a find and mark as part of the user login script?

Jerry