Solved

Filemaker Pro 11 :: Asset Tracking

Posted on 2012-03-19
7
1,496 Views
Last Modified: 2012-03-20
I would like to know if it is possible to use Filemaker Pro 11 to "check out" assets (e.g. computers, printers, etc.) to users.

I would like to be able to scan user's badges and pull up their information, what assets they've had checked out to them in the past, what they have now, etc. And Id like to be able to pull up a particular asset and see who has used it in the past, who has it now, etc.

So far I have a table with my user's names and their barcode numbers, and I have a table of my assets, but I dont know how to create a layout to link them together (for the purposes of checking in and out).

Any assistance  would be greatly appreciated. Thanks
0
Comment
Question by:berserkerror08
  • 4
  • 3
7 Comments
 
LVL 12

Assisted Solution

by:North2Alaska
North2Alaska earned 500 total points
ID: 37739905
Possible, Yes!  To scan their badge, you would have to setup the scanner to run a script or you would have setup the "Find" layout first.  Then the scanner would need to place data in the correct field.  Hit enter and it should pull up a found set.  Of couse, this is all off the top of my head.  Bottom line, with the scanner and FM coordinated, you should be able to accomplish the query.

As far as building the relationship, you will need a table in between the users table and assets table, call it UserAssets.  This table will have two columns, the key field of the users table and the key field of the assets table.  In addition, you will want fields to hold information about what happened when they "joined", i.e.;  CheckOutDate, ReturnDate, CheckOutPurpose, etc...

Then on either table layout you can display the list of the other table.  For example, on the Users table layout, you could have a portal that displayed all the users assets, past and present.  From the Assets table, you could see all the users that checked out that asset.
0
 

Author Comment

by:berserkerror08
ID: 37742131
How would I make Check ins and Check Outs?
0
 
LVL 12

Expert Comment

by:North2Alaska
ID: 37742196
Put a button on the screen where the text will change.  If it's available for check out the text reads Check Out.  If it is already checked out it reads Check In.

When the button is pressed, handle the scan (whatever that means) and store the results in FM.
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:berserkerror08
ID: 37742874
Im less concerned with the scanner at this point, and more so with setting up just the layouts. I know how to make a button but i dont know how to actually "check out" or assign a device to a user. I have three layouts and tables right now. Employees, Devices, and UserDevices.

The screen shot here may offer some clarity: http://screencast.com/t/8GzLBUdW

How do I design the layout/button so that I can pull up a user and select/add a device for them to check out? How do I design a layout/button to look up a device and show me who has had it before? How do I create a way to keep track of which users have had the devices when?
0
 
LVL 12

Assisted Solution

by:North2Alaska
North2Alaska earned 500 total points
ID: 37742959
Are you comfortable with the Relationship Graph (RG) and Table Occurrence (TO)?  Are you comfortable with Portals? How about Value Lists that are related to tables?  Scripting in FM?

You will need to be intimate with all of these things and more.

Let's start simple.  A layout of one employee record.  Using a portal on the same layout you can display a list of Devices associated to that user.  The list would have the check in and check out dates and you would be able to see, if there were no check in date, that the item was still out.  In this list there is a popup that will display all devices.  So when you create a new entry in the Portal, you select this popup and pick a device, enter a check out date and you're done.

There are many, many design methods you could select to build your interface.  Some use simple techniques as above and there are complex methods.  Your comfort level will determine which you use.
0
 

Author Comment

by:berserkerror08
ID: 37743105
Im new to FileMaker; where would you point me to get more familiar with the program? I read through the user guide but found it glazed over more complex topics.
0
 
LVL 12

Accepted Solution

by:
North2Alaska earned 500 total points
ID: 37743194
Some time ago I found a great sample that you could use to tear apart and figure things out.  Or you could just use it.  Check out http://fmstartingpoint.com/

Another great example of a well developed sample, is the folks at http://Excelisys.com

I've used both of these to learn new techniques and a better understanding of FM.  It's been an enjoyable journey.  I invite you to come along and hope that you can have fun too!  :-)
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now