3 Replies Latest reply on Sep 15, 2009 6:01 AM by ninja

    Locking a field

    sly_1

      Title

      Locking a field

      Post

      Here is my layout

       

      Month (date type) hours hourly rate total billable program

       

      say for month date = 01/12/2009

      but after this date 29/12/2009 I no longer what people to play with these fields. This would go for any month and any year between the dates of the 1st of the month and the 29th of every month

      I have a way to lock as soon as a date is entered but this will need to be changed through the month.

      I just don't want people going back and playing with this to screw the totals for that month.

       

      thanx sly

        • 1. Re: Locking a field
          TSGal

          slyomega:

           

          Thank you for your post.

           

          With Accounts and Privileges, you can set a user to have the ability to add records, but not edit or delete them.  This way, once the record has been added, no changes can be made to that field (or fields).

           

          If you need clarification how to do this, please let me know.

           

          TSGal

          FileMaker, Inc. 

          • 2. Re: Locking a field
            sly_1
              

            TSGal i would love clarification how to do this. Any help would be awsome.

             

             

            Sly

            • 3. Re: Locking a field
              ninja
                

              Howdy sly,

               

              In accounts&Privileges, under records, choose "custom privileges..."  This will pop up a window with many various selections.  Choose the table you want to restrict and choose "limited.." under the EDIT header.

               

              A calculation window will pop up in which you will describe the conditions under which someone can edit the record.

               

              Assuming you have a field with the date after which the record should not be modified, the calc can take the form of:

               

              Get(CurrentDate) < Table1::LockOutDate

               

              or something like:

               

              Get(CurrentDate) < (Table1::CreationDate + 15)

               

              You'll need to determine how to describe the lockout criteria to meet your needs...after that, it should be pretty direct.

               

              Keep notes, playtest it yourself before launching, always keep backups... ;)