3 Replies Latest reply on Mar 10, 2011 11:07 AM by mgores

    Data locking Issues



      Data locking Issues


      I wish to make an invoice database with 2 users (one as data input and one as authorizer). Wondering if there is any tools ready in FileMakerPro so that the data will be locked (no modification allowed) after confirmation by authorizer (say clicking a confirmation button). Appreciate any suggestion/idea.

        • 1. Re: Data locking Issues

          Sophia,  I have done something similar using two copies of a layout, one for entering data and one that has all the data fields set to not allow data entry/modification.  Then write a script that checks a lock field that if true sends the user to the locked layout, if false sends the user to the data entry layout.  Set the script trigger on layout entry for both of those layouts and the user is automatically sent to the layout you want.  You can use your confirmation button to set the value.

          If (IsEmpty(table::Lockfield)

          GoTo Layout ["entry"(table)]

          Else GoTo Layout["entrylocked"(table)]

          End If

          • 2. Re: Data locking Issues

            We use settings in Manage | Security... to keep users from modifying invoices on our system that have the text "printed" in a status field. This avoids the need for a second layout with script triggers and also permits users with full access privileges to modify them on the rare occasion when this is necessary.

            See "Editing record access privileges" in FileMaker Help and check out this particular sub section: "Entering a formula for limiting access on a record-by-record basis" for a detailed description of how to set this up.

            • 3. Re: Data locking Issues

              I haven't looked into that until now.  A much more elegant way to do it.  Will have to go back and clean out all those unnecessary layouts and scripts now.