AnsweredAssumed Answered

Buttons and sort Scripts

Question asked by eldoonmad on Apr 5, 2012
Latest reply on Apr 5, 2012 by philmodjunk


Buttons and sort Scripts


Here is what I have :

A database for tracking invenotry and assets including tables for the assets as well as users they will be assigned to. 

This is for a school district so assets are assigned to users as well as classrooms. School sites are listed under a value list that can be selected in form view of the Assets table. Room numbers are enetered in manually in a text field.

What I would like to do :

I am trying to make this database as easy as possible for my end users that will be doing the inventory. So I am trying to include all actions they might need to perform in buttons. I do not want them to have to touch any of the FMP controls.

This last section I am trying to make has to do with reports. Basically I would like one layout full of buttons for the most common reports. One report being a list of all items assigned to a specific classroom. Now I know I can do a script for the button that will take the user to the "Asset" list layout, then sort by a classroom and then sort by a room, however, I am not sure how I would make those variables available for the user to manually select and then click the button, print report.

So I would like the user's experience to be like this. 

They click a button at the top of the page that would take them to the Reports layout (No problem, i can do that)

They would see a dropdown menu (my value list) and select the School site (The value list is already set up)

They would then type in a text field the room number

They would then click the button print reports and out it comes. (I know how to create buttons and assign scripts)


My main questions:

1) What type of layout would be best for this, since they wont be creating records in it just clicking buttons?

2) What would be the best way to create fields for the variables, Site and Classroom

3) What would be the best way to incorporate those variable's values into the script


Thank you for any help