multiple user script execution

[ejpvi]

I have a layout, which is pretty basic. By choosing some global variables, then clicking "save" it will increment a count in the table for that day.

Multiple users will be using this... where I am seeing some issues, is if 2 or more people click the "save" button at the same time... it will still execute, but give them an error message about locked record, until the other person finishes.

Is there a command or step in the script that can accomodate if multiple users try to run the script at the same time, without flagging any errors?

[IdealData]

The Open Record step is probably what you are looking for. You will need to combine this with setting ErrorCapture to ON in your script.

Basically if you try to Open the record and it yields an error then the record is already locked by another user. Display a dialog box to advise the user.

Don't forget to Commit Record at the end of your script.

[comment]

See:

http://forum-en.filemaker.com/fm/board/message?board.id=FM-en-4&thread.id=27297