FileMaker 12 - Restrict users to see only their own records

Posted on 2014-09-02
Last Modified: 2014-09-06
In fileMaker I have a table,


a table for activities, where they log their hours and it gets multiplied by the rate..

but I don't  want other users to see the rates of others. How can I accomplish this?
Question by:Iammontoya
    LVL 24

    Accepted Solution

    There are a lot of ways to solve this using File -> Manage… -> Security and setting option in various privilege sets. The simplest way to do it is to create a field in each table where you want the restriction to apply. You can call the field "CreatedBy" or "RecordOwner" or whatever you want but it needs to be set to auto-enter the account name of the creator. That's the Account Name, not the user name, and it requires that you have accounts setup for all your users and have them assigned to a Privilege set that restricts there view. To do that, to into the Privilege Set definitions restrict viewing records to only those records where CreatedBy matches the Get(AccountName) of the current active account.

    Select "Data Access and Design" and Records: and choose "Custom Privileges". Select all (or some) and under View, select "Limited". Then enter the calculation   CreatedBy = Get ( AccountName ) )
    LVL 19

    Author Comment

    I will look into this. Thank you.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
    Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    how to add IIS SMTP to handle application/Scanner relays into office 365.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now