I am trying to change the way we do inventory at my company. 

I need to have a scanner connected to FMGO, that we can scan and then move numbers up and down, or set a variable in the data. 

How do I make it search?

Scan WP310 > Bring up one items with unique identifier > Change STOCK Amount > Save.

 

I know with the app you can scan when looking at a certain field, but how can I make this all automatic?

Unfortunately, you can't make it automatic. You can script it and start that script with a button. You can scan into a global field, then process the scan, do your search and end up on a layout or popover where you can mark the quantity.

Whether you use a linear barcode or QR code that would depend on how much data you want to store in your barcode. If you have space for a barcode—at a readable size— then you can use barcode. Even in wet environments you can use coated labels. If you have equipment that't better equipped with a chip in a wristband or  you just want to touch that equipment to a reader then you'd want RFID.

We sell a wide variety of readers and scanners. Check out our store at http://store.zerobluetech.com and email me if you have specific pre-sales questions.

 

Edited November 9, 20178 yr by Agnes Riley

35 minutes ago, Agnes Riley said:

Unfortunately, you can't make it automatic. You can script it and start that script with a button. You can scan into a global field, then process the scan, do your search and end up on a layout or popover where you can mark the quantity.

Whether you use a linear barcode or QR code that would depend on how much data you want to store in your barcode. If you have space for a barcode—at a readable size— then you can use barcode. Even in wet environments you can use coated labels. If you have equipment that't better equipped with a chip in a wristband or  you just want to touch that equipment to a reader then you'd want RFID.

We sell a wide variety of readers and scanners. Check out our store at http://store.zerobluetech.com and email me if you have specific pre-sales questions.

 

 

So I guess what I'd like is 

Button > Scan > Automatically Search for the text that is included in the barcode > and then they can change the quantity.

You will have automate it. You will have to create a script that does what you need: search for the item in the barcode. Then bring up a field on a layout where you can change quantity then take you back to the main screen where your button is.

15 minutes ago, Agnes Riley said:

You will have automate it. You will have to create a script that does what you need: search for the item in the barcode. Then bring up a field on a layout where you can change quantity then take you back to the main screen where your button is.

Where can I read about how to get this to script properly?

You can just write out in English what you want to accomplish step by step and try to find the matching script steps. But it helps to learn some FileMaker development the right way.

http://www.filemaker.com/learning/

I recommend the FileMaker Training Series or get a few books or Lynda.com videos. Or you can hire someone to do it for you. 

1 hour ago, Agnes Riley said:

You can just write out in English what you want to accomplish step by step and try to find the matching script steps. But it helps to learn some FileMaker development the right way.

http://www.filemaker.com/learning/

I recommend the FileMaker Training Series or get a few books or Lynda.com videos. Or you can hire someone to do it for you. 

I have to figure this one out myself because they hired me to do it for them. haha.

Congrats! And good luck!

2 hours ago, Kyrie said:

because they hired me to do it for them

So you won't fill alone, take a look at this topic https://fmforums.com/topic/57970-does-anyone-takes-us-seriously/ and see just how normal it is to have developing a FileMaker file solution dropped on you.

 

Lee

14 hours ago, Lee Smith said:

So you won't fill alone, take a look at this topic https://fmforums.com/topic/57970-does-anyone-takes-us-seriously/ and see just how normal it is to have developing a FileMaker file solution dropped on you.

 

Lee

Thanks!

I do know how to program and script for a variety of programs.. and thankfully making a real developer salary.  

 

That does make me feel better.

Please complete your profile.

Lee

52 minutes ago, Lee Smith said:

Please complete your profile.

Lee

Thanks for the reminder again, Lee.

 

All settled.