Our Preferred Hosting Provider - Award Wining FileMaker Pro Hosting
Results 1 to 2 of 2
  1. #1
    Junior Member
    Join Date
    Oct 2012
    Posts
    4
    Downloads
    0
    Uploads
    0

    Privilege control for certain records

    The Scarpetta Group- our preferred FMT Forum Consultants
    I am a FMP newbie and have made a contacts database for following up sales leads. I have created a field on each record which names the salesman responsible for following up that lead/contact. I want to be able to create a privilege or permission to allow each salesman (with their own unique login) to only view/edit the records which I have named as theirs and not be able to access other salesman's leads at all. I realise this may be complex but a few pointer/ideas would be gratefully received. So far I have not been able to spot any way of restricting certain records to specific users but allowing the administrator to view all. Thank you
    Warning: This is an Old Thread
    This discussion is older than 420 days. information contained in it may no longer be current

  2. #2
    Senior Moderator - FMT Preferred Developer Consultant - New York - Worldwide AHunter3's Avatar
    Join Date
    Aug 2006
    Posts
    11,375
    Location
    New York and Nassau County, NY, USA
    FileMaker Version
    FM 9 Developer, FM 9 Server, FM 10 Developer, FM 10 Server, FM 11 Server, FM 12 Developer, FM 12 Server, Older Versions 2-8
    OS
    Windows & Mac
    Skill Level
    Developer
    Downloads
    0
    Uploads
    0

    Re: Privilege control for certain records

    You do it in privilege sets, under Manage ——> Security.

    Create a custom privilege set and then Edit it. Under the records dropdown where it defaults to "Create, edit, and delete in all tables", select Custom Privileges. Then pick your table in the list of tables. Go to the View dropdown, which should default to "Yes" and change it to Limited. It will prompt you to enter a formula. Put this (or equivalent, using your actual field name):


    Get (AccountName) = SalesmanResponsible


    Then assign all salespeople's accounts to that privilege set.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Filter records by privilege.
    By AlanChu in forum FileMaker 11 Advanced
    Replies: 4
    Last Post: 02-12-2013, 05:33 AM
  2. PHP get privilege set name ?
    By powerslave in forum FileMaker Pro 11
    Replies: 1
    Last Post: 01-11-2013, 11:26 AM
  3. privilege set script
    By Mschmidt in forum FileMaker Pro 11
    Replies: 9
    Last Post: 01-20-2011, 10:14 PM
  4. Replies: 3
    Last Post: 05-08-2010, 01:44 PM
  5. Privilege Set Issues
    By crandell in forum FileMaker Pro 7.0
    Replies: 2
    Last Post: 08-23-2005, 06:57 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Welcome to the Original FileMaker Forum
With designated forums for almost every FileMaker topic...FileMaker Today is a free-to-join community where you can boost your FileMaker expertise, build better solutions and solve your technical challenges. If you're building FileMaker solutions, this is the place for you.
Follow FMT
We Are FMT
FMT is home of The World's leading FileMaker News Site, Worldwide Developer Directory, FileMaker Connect Community and so much more.