4 Replies Latest reply on Jul 6, 2017 8:55 AM by gofmp15

    Database help

    thekops

      Hey guys, I am new to FM (4 weeks old), I am planning to make a database. Having accounts with different privileges.

      Having accounts with different privileges.

      1)Normal account: can only view their profile

      2)Super account: can view his profile including all profiles 

       

      I have tried setting the View Layout privilege in the individual accounts, as my login database (table layout)  requires it. However, because I enabled the View Layout for the login system, the normal account users are able to access and view the table. Hence they can see all the information of other users.

       

      Is there a way to get around it?? Like hiding the toolbar in FM Go??

       

      Thanks in advance friends:)

        • 1. Re: Database help
          bigtom

          You need to control this with relationships and privilege sets. Hiding the tool bar is not the best way.

           

          Record level access behavior in FileMaker Pro | FileMaker

          1 of 1 people found this helpful
          • 2. Re: Database help
            beverly

            You may be confusing accounts with privilege sets. Design the privilege then assign accounts that can use it.

            Starting here may help:

             

            Beverly

            Sent from miPhone

            1 of 1 people found this helpful
            • 3. Re: Database help
              gofmp15

              The best way to stop users from viewing the layouts using the View Layout menu is to uncheck the layouts in the layout editor. This lets you control what the users can access via a menu selection.

               

              Next, you can write scripts for reports, forms, etc.

               

              To restrict a list of records

              You can add one field that can be used to designate the privilege sets to view the record and then create a find script step for each privilege set which restricts what people see

               

              if(get(privilegeset) = Full acces

                 perform find for full access

              else if get(privilegeset) = Warehouse

                 perform find for warehouse

              ....

              end if

               

              Go To Form  (used via a button on a list or report to send the user to the form for that record.)

              if(get(privilegeset) = Full acces

              go to layout [Form] full access

              else if get(privilegeset) = Warehouse

              go to layout [Form] warehouse

              ....

              end if

               

              There's a few loopholes here but this will get your started. You will need to create custom menus to limit user access to records.

              • 4. Re: Database help
                gofmp15

                thekops wrote:

                 

                Is there a way to get around it?? Like hiding the toolbar in FM Go??

                 

                Thanks in advance friends:)

                In the layout editor uncheck the box for any layout you do not want a user to see when selecting the View:Go to Layout menu option. Only checked items show up here.