3 Replies Latest reply on Jul 28, 2009 1:08 PM by TSGal

    Problems with Setting up Accounts

    TSADesign

      Title

      Problems with Setting up Accounts & Privileges

      Post

      I have set up a database that will be accessed via Instant Web Publishing by outside sales people. There are three layouts in the database, but only one will be accessible to the sales people. Of that layout there are approximately 20 fields, some of which will be able to viewed, some that won't be viewable. There is only one field that can be modified.

       

      Somehow I have broken the ability to enter data into the modifiable field.  When attempting to enter data into this field I receive the same alert that I would receive if I tried to enter data into a field that was set up for view only. I have gone through the Accounts and Privilege Sets numerous times, but cannot find what I have done to prevent this field from being modified.

       

      By the way, when I open the database in my admin role where all fields are accessible I can enter data into this field.

       

      Your help is greatly appreciated. 

        • 1. Re: Problems with Setting up Accounts & Privileges
          etripoli
            

          Check that the field is not a calculation, and that modification is allowed.

          Check that the user's privilege set Records Modifiable priv. on the Layout, Edit privilege on the Records, and any Field Access Limited... settings allow modification to the fields.

          Finally, check that the Field Behavior on the layout for the field has 'Allow field to be entered: In Browse mode'

          • 2. Re: Problems with Setting up Accounts & Privileges
            TSADesign
              

            Thank you for your post. All privileges have been set correctly - as you have outlined in your post. Also I verified that the Field Behavior was set to "Allow field to be entered: in Browse mode".

             

            At this point I have contacted Filemaker directly and have sent them a sampling of the database for them to take a look at to see if they can determine where the problem may lie.

             

            They ran me through several steps: 1. Run Permissions Repair, 2. Save to Compacted 3. Recovered, etc. 

             

            I would still be interested in any other suggestions the forum may have. 

            • 3. Re: Problems with Setting up Accounts & Privileges
              TSGal

              TSADesign:

               

              Thank you for your post, and although I don't have access to your file, here are some things to check.

               

              Startup script - Does it set any global variables that are used in Limited access calculations?  If so, what is it?

               

              Have you tried setting up a second account with permissions?  Since you are only accessing one field for modification, this is what I have done for my test file that contains four different layouts, and I only want to modify one field on one layout.

               

              1. I created a new Account Name and password (TSGal), made the Account Status as "Active", and select "New Privilege Set..."

               

              2. I select Layouts and selected "Custom privileges..."

               

              3. I selected the third of four layouts, and set the Layout to modifiable and Records to modifiable.  All other information was set to "no access".  Click OK.

               

              4. For Records, I selected "Custom privileges..."

               

              5. For the table name associated with the third layout, I set View privileges to Yes, Edit privileges to Yes, and for Field Access I selected "Limited".

               

              6. I selected the one field to "modifiable" and all others to "view only"

               

              7. I clicked OK five times and exited out.

               

              I closed the file and opened it again with the new username and password.  I'm able to edit information in the one field.  All other fields give me an error message.

               

              I closed the file and opened it again with full privileges.  I pulled down the File menu and selected "Sharing -> Instant Web Publishing...".  I turned on Instant Web Publishing, selected the file, and set access for all users.

               

              I switched to another machine, launched a browser, entered the limited name and password, and I'm immediately taken to the one layout.  I am not able to click on any field except for the one field in question.  I can then modify the information and save it.

               

              Please let me know if you are doing something differently, and I'll try to duplicate the problem here.

               

              TSGal

              FileMaker, Inc. 

               

               

              I have set up a database that will be accessed via Instant Web Publishing by outside sales people. There are three layouts in the database, but only one will be accessible to the sales people. Of that layout there are approximately 20 fields, some of which will be able to viewed, some that won't be viewable. There is only one field that can be modified.

               

              Somehow I have broken the ability to enter data into the modifiable field.  When attempting to enter data into this field I receive the same alert that I would receive if I tried to enter data into a field that was set up for view only. I have gone through the Accounts and Privilege Sets numerous times, but cannot find what I have done to prevent this field from being modified.

               

              By the way, when I open the database in my admin role where all fields are accessible I can enter data into this field.

               

              Your help is greatly appreciated.