Need help locking records to whomever logged on

General support questions.
Posts: 1
Joined: Fri Jul 25, 2014 6:38 am
PostPosted: Fri Jul 25, 2014 6:53 am
I've been asked to create a script where if the user starts to fill out a portion of a layout in Filemaker and then exits out of the application, whatever information they had started to fill out would still be there waiting for them when they log back in.

However, because Filemaker commits records automatically and because I can only use the Get(Account Name) function after a Create New Record line in the scripts, the best I've been able to do is have a fresh record every time a user logs in, or present the last record of the last person who logged in (which may not be the person who logged in, completed half the layout, and logged out).

I'm wondering, if we're planning on implementing GoZync, do I even need to try and work on this script or will GoZync already have such a functionality in place?
SeedCode Staff
SeedCode Staff
Posts: 96
Joined: Mon Aug 13, 2012 7:43 am
PostPosted: Fri Jul 25, 2014 9:29 am
I think the important thing here is how is a record marked complete. I would probably set up a field that is an auto-enter calc that get's populated with the account name Get (AccountName). I would also have a field for marking as complete (if you don't have criteria already). Then you could set up a script to run as a on layout load script trigger or if you wanted it to run when the file opens you could run the script from an "OnFirstWindowOpen" script trigger found in the "File Options..." under the file menu.

The script would then navigate to the proper layout run a find for the account name and not complete.

GoZync allows users to check out records so nobody else can edit them while the user has it checked out. You can also sync found sets. ... OutRecords ... gFoundSets

Both of those are part of a sync process though and it sounds like you want this to be something a bit more automatic.

Hope that helps,


Return to General Support

Who is online

Users browsing this forum: No registered users and 1 guest

Follow us: