1 Reply Latest reply on Apr 18, 2012 10:56 AM by philmodjunk

    Using Filemaker as an Inventory/Stock


      Using Filemaker as an Inventory/Stock


      Hey, I am pretty new to this and have a question. I work with 4 other guys and we are a small team in a big company. We have a lot of products we use (bags/bottles/filters) and a rather large inventory of it all. We want to be able to go to our Stockroom with say an iPad and scan items outs that we are removing, or if a new stock has come in we would wan tto add them in. The key points are that we all have access to the same inventory, and that when we scan something out it is taken out of the inventory on the iPad and the inventory on the computer. Also the idea of using an iPad for scanning barcodes would need to be possible with this system. We currently use Google Docs for our inventory but it becomes confusing and a hassel when we remove things and then have to go on a computer and edit the changes. Is it possible to have something like this made? Or is there something else we would need to do?

      I have searched quite a bit, I found computer programs with scanners. And I found some on the iPad but they do not "automaticallly sync" to a computer, you would have to edit the inventory when something is removed or added. We want to be able to scan with the iPad, with the option of adding or subtracting, and then it automatically edits the inventory to eliminate the step of us having to do it.


      Thank you. And sorry, again I am very new to this. :/

        • 1. Re: Using Filemaker as an Inventory/Stock

          You have a number of issues to research. Some are best asked about/researched in the FM Go Forum as that's the section for FM Go--the iPad/iPhone version of FileMaker. If you can set up reliable wireless connections (WiFi, 3G or 4G) a filemaker database can be hosted with Filemaker Pro or Filemaker server and your iOS users can connect to it in order to log items in and out of inventory.

          I've seen several discussions of using barcode readers with such a device that indicate such an option can be made to work, but the implementation is not as simple as a scanner hooked directly up to a regular computer. I suggest searching out and reviewing posts on barcode scanning and Filemaker Go to learn more.

          Then you'll need to figure out and create a database design that works for both you on both the computer and your iOS devices.