Hi Comment Thanks for this. Ive now added the extra elements and its all working well.
Thats perfect.. Thanks for your help.
Hi jbante the problems I found with just having my script reducing the total stock level by one every time a user scans a code is sometimes they might want to reduce the amount by up to 6 or if stock is being added then we can have 50+ items added at one time. ive now changed the script to forward to a layout with a in and out field so they can enter a amount this seems to work better. i have found logging in to the FM Solution slow on a iPhone when sharing from the demo application on my laptop. im not sure what software I should purchase to roll it out. FM Server? If so how many users or should I just have FileMaker Pro sharing it on my network. i will have 5 or 6 users but probably maximum of 2 at anyone time using it. And I would like to automate a script to run at a certain time to check levels to email suppliers to replenish stock levels. Better still if I could open up a list view to supplies so they can check on stock levels via the web so they can control it. would I need a copy of your barcode creator per user or just one for me who would create any new products.
Thanks for your help. I will give it a go.
Hi Im looking at introducing QR codes to the demo Inventory database supplied with Filemaker Pro 15. This will enable me to generate a code per item/record. I will then print off the code to a DYMO label and stick it to the actual stock item. I then would like to be able to have employees scan a code every time they use one of the products so that Filemaker then reduces the stock level by 1. I would like to be able to open the Inventory DB and then activate a script that scans a QR code then searches for the code/record and enters a new record in the stock transactions file adding a number one to the units out field. I plan to use Filemaker Go v15 for this on either iphones or ipads. Im ok with generating the codes its just the script that scans the QR code I’m stuck on. any help would much appreciated or Is there a demo file available that I can download to see how I need to set this up.
Its ok now. I copied the 'server.pem' file from the 'Show package contents' of Filemaker Pro v9.03 on another networked mac and placed it in my Filemaker Pro Advanced packaged contents and it work. Filemaker Pro.app --> Show Package Contents --> Contents --> Mac OS / server.pem Thanks for your help.