AnsweredAssumed Answered

How do you organize scripts/reports layouts?

Question asked by user14967 on Aug 18, 2015
Latest reply on Aug 23, 2015 by taylorsharpe

I'm looking for advice on how to arrange reporting scripts. In the dark ages, I created a "reports" layout in the primary FMP file, threw in a bunch of buttons and attached scripts to them. It's a mess.



Screen Shot 2015-08-18 at 9.36.11 AM.png


I have a few complaints about how I did this before:


  1. It's hard for people to remember which report does what.
  2. Some scripts open other files with their own reports layout (e.g., "Worklog Reports" opens the Worklog file).
  3. Some scripts perform actions on the found set, while others create a new found set. Even I can't remember which does which, so people often end up repeating a search query.


Add to that the fact that some of these reports haven't been used in 5 years... like I said, it's a mess.


Some ideas I'm considering:

  • Use drop-down menus to select reports and show a preview image
  • Provide a workflow to running reports (select the report you want to run, enter parameters, ...)


Before I dig too deep, I'd like to see examples of how others organize reporting scripts. What has worked for you in the past?