If you’ve ever wanted to generate specific reports for different groups of users, but are intimidated by FileMaker’s, somewhat complicated security schema, this PDF shows you an alternative methodology that is very simple and easy to implement, using FileMaker Pro privilege sets.
Recently a client, a large bail bond company, wanted to be able to add reports easily, that could only be viewed by specific employees, and without having to go anywhere near FileMaker’s security schema.
This got me thinking outside the box, which is where many good FileMaker solutions come from, and I started to play a game of ‘What If? What if we could use a related value list to populate a field, listing all the reports that were available for the user, and then use a script trigger to generate the report? Once I’d finished playing ‘What If?’, I started a different game; ‘Why Not?” (Both of these are fun games that I love playing and which FileMaker is particularly adept at). More…Creating User Specific Reports Using FileMaker Pro Privilege Sets.