Jump to content

Help with viewing data to specific users


JohnTheFileMaker
 Share

This topic is 2825 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi , Does anyone know of a recommended way of display data specific to one user login. Simple example there's a FM database with 100 records 5 users accounts . Each users can only view 10 records that specific to their login. Anyway to set this up with out have to create 5 different database and get it to work with one FM DB?

 

users   no of records

A         10 records

B         20 records

C          5 records

D          5 records

E        60 records    

Link to comment
Share on other sites

  • 4 weeks later...

The simplest way to do this is to make a field on the records that is set to put the account name on creation in the field (Unless you are using some other method of deciding who can see what record). Then I would just do an on record load script trigger to omit any records that don't belong to the account name that is currently logged in. 

Link to comment
Share on other sites

Does anyone know of a recommended way of display data specific to one user login.  Each users can only view 10 records that specific to their login.

 

Hi John,

 

This is precisely the purpose of Security - control User access according to their login.  You can create a privilege set which restricts records to custom setting according to your criteria, such as 'who created the record' as Voltron suggests.  In this way, FM will do the work for you - restricting records produced when performing a find, restricting records displayed in a portal ...

 

You need to also control Show All Records and Show Omitted (which you would need to control anyway).  You can read up on the various techniques in the Security Concepts forum.

Link to comment
Share on other sites

This topic is 2825 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.