Filemaker Pro 11 :: Asset Tracking

Posted on 2012-03-19
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
Question by:berserkerror08
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
LVL 12

Assisted Solution

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.

Author Comment

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

Expert Comment

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.
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  


Author Comment

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:

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?
LVL 12

Assisted Solution

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.

Author Comment

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.
LVL 12

Accepted Solution

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

Another great example of a well developed sample, is the folks at

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!  :-)

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

630 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