If you’ve ever wanted to generate specific FileMaker 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).

As it turned out the solution was very simple and easy to implement.  We just had to add one table (for the report names), a global field (with a related value list) and a script with  just 3 steps.  Now all the client has to do in order to add new reports is to add a new layout and make sure that the name of the layout is the same as the name of the report and then select who can read that report.

Problem solved; mission accomplished; happy client.  What could be better? Download this FREE PDF.