Jump to content

Script to see what items each location has


This topic is 6104 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I'm new, so be gentle. Database created from the asset management template in FMP Advanced 9 to keep track of computer installations at 9 locations. The View Inventory script works fine. But I want to modify it to be able to click and have it present me with an inventory list as each location.

Where the script says "Perform Script ["Sort by Category Ascending"], I changed it to ["Find"; Parameter: Asset Management::Site] I can't figure out how to tell it which site I want to find the records for.

It could be that I'm going about this in an entirely backwards or awkward way, so enlightenment is encouraged.

Thanks.

Link to comment
Share on other sites

Do you want to find and report on one site at a time, or do you want to just have the found set sub-grouped by site (or have both options)? They are different operations.

In any case, I don't think changing your Sort subscript to a Find would be appropriate. You might want a Find in addition to a Sort though.

Link to comment
Share on other sites

  • Newbies

I more concerned with reporting on one site at a time. When someone from one location calls, I would like to be able to just pop up those computers instead of sorting though everything else. There will be several hundred computers.

So how would I go about that?

Link to comment
Share on other sites

Create a table with just the fields you would Normaly search for. (Make them globals if this is multi user, you might get a message about the relationship but it will have the functionality needed) Create relationships to the Table you want to search based on the fields in your new table. (You can even define the sort order). Create Layout and value lists for your new table. Create Button that uses the Goto Related Records Script step. (You can define what layout to display it with.) This method seems to work alot faster than a Find and Sort.

Link to comment
Share on other sites

This topic is 6104 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.