Sub-Table for Equipment?

[SFD CERT]

Not sure how many people use the Equipment section heavily, but our team is considering it to provide our agency with a 'one stop shop' to find out the status of our team and gear.

The equipment table has the user-defined fields (awesome), but our Logistics officer is asking for a way to track equipment in groups.  The example we have is:
We have X number of <insert your medical supply here>...some are in our cache, others are distributed to our 5 equipment trailers inside of bins numbered 1-20.

She'd like to see a way to pull just the items in a sub group - be it in the equipment trailer, or even a specific bin within that trailer.  The idea being she can show our FD a "full" report (what MM does now), but she'd also like to be able to pull and either print or export a sub-set of equipment, say located in Trailer 10732 or in Bin 1, Trailer 10732.

My idea was maybe something as simple as adding a Location drop down field, similar to Status (where you populate the values in the Configuration tab, then have that field be a "permanent" field).  Then on the back side, maybe the ability to run reports...either a full report, or one filtered by that Location field.  To get what she wants, I can see Location needing two or three fields...so Location 1 would be maybe what agency or a site within the agency...Location 2  would be what area within Location 1, etc.

Not sure if this is a monster ask or not, but now that we've shown them we can track our items on line, they are seeing all kinds of ways they want to parse the data.

[SFD CERT]

Maybe a way to do the reports would be to use the 'find' feature of Equipment, then at the top, put drop down fields or filters (almost as there is in the Equipment Import process) to narrow down the list...then just put an 'export' button at the bottom that would export only the filtered results?  That to me (someone who has no idea how MM works in this area) sounds like it could be less coding...

...or not?

[Radishworks]

Maybe a way to do the reports would be to use the 'find' feature of Equipment, then at the top, put drop down fields or filters

Good idea, I will add this to the wish list.

[Andy Vuong]

Now on the equipment search result page, you have the ability to sort equipment by name, category... by clicking on the name header of the table.

[jenkinsd@tampabay.rr.com]

We were wanting that as well. We have our 'comm box' that is one item, but inside the box are radios, gps units, etc. If we had it where we inputted 'comm 18' as the master location and say 'comm box LE751' as a location and then subforms underneath to add each piece of equipment in the comm box, that would be helpful.

Right now, we just have the comm box named as LE751 and everything within the comm box is named starting with LE751 (item name).

Good idea.

Dawn