Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Filemaker Pro 11 :: Asset Tracking

Posted on 2012-03-19
Medium Priority
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 2000 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.
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


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 2000 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 2000 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

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

660 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