I am extremely new to Filemaker. I've been trying to learn it but time always dictates. I am trying to create what I believe is a simple database. What I am trying to do is to have a very basic system to track parts usage by our mechanics by either barcode or part number. Basically the mechanic would come up to the computer. Enter a unit #, worker order #, date, part #(either by manual entry or upc.) and qty. Then I would like to be able to print a report in the morning that will display Unit #, work order #, date, part # and qty. I can then take this information and enter it into our system. The problem I have is our system doesn't allow bar coding. Also some of our parts don't have barcodes such as tires and brass fittings so I need a manual part entry. I can't have the report show a upc number. So I need to have a way for the database to take the upc and switch to show the part # it is related to. I can get the system to work fine and show the repor that I want. The only problem I have is I can't get it to switch the upc to the part #. I was wondering if some one could take a look at what I have done and inform me on what I could do. I am not looking for someone to do it for me. Just give me some guiding information. I wanted to say thank you in advance for any information you can supply.
I developed a solution which utilises the barcode reader function. This worked perfectly in FMGo 14 on an iPhone 6 Plus. I upgraded to FMGo 15 but at the same time made a few programming changes, although not to the script containing the 'Insert from Device function'. On activating the script, the camera would activate and the barcode would be read successfully but, on a later occasion, the camera would activate, but not trigger on the same barcode as before and the camera would remain in scan mode unless cancelled. Thinking this was due to the changes I made, I spent hours trying to overcome the problem. Eventually, I deleted FMGo 15 and downloaded it again. It worked. However, the problem resurfaced. When it does, quitting the app restores the functionality. The 'Insert from Device' step I have scripted writes to a global field which I have placed off the layout. Again, sometimes it works, other times not, even when activated from the same layout using the same script. Could this be a bug in FMGo 15? Also, sometimes when clicking on an image in a container field, instead of going to the app extensions, FMGo 15 quits. Relaunching, on the same layout and photo, it works as expected. Again a bug?
By Budi Hananto Seto
i have a script to find and add barcode if not available, but, the problem is, it is not automatically add new barcode, if the find result is not available, any suggestion about this script?
i want to to find barcode through iphone camera, if not available, it will automatically add the new barcode. thank you
I am gonna describe a scenario where total automation needed using only barcode scan, please bear with me:
I am creating operator timesheet layout for product lifecycle in list-view.
Each operator has a list of unique barcodes(printed sheet) for each production function.
Every activity(function) of print production is assigned code (barcode) that represents function type as well as operator name: For eg. if John is working on new plates function for Press he'd scan barcode 301-1 but if Marc is working on the same function , he'd scan 301-2 , Now '301' represents new plates function and number after hyphen(-) represents operator. In John's case 1 and Marc 2.
So, on the interface(list view of functions) , when an operator scans barcode of function it will set time-in field value and name of operator in their fields based on calculation from code.
I don't want STOP button for each function to set value of time-out (because it requires user interaction), rather, I want it automated.
I am looking for some sort of script trigger that runs on every new code scan and search for last record with similar operator name and set time-out value as current time in that record and set the same value as time-in for new function record.
By Kurt Hansen
We have for many years (of forgotten and unknown reasons) put a zero in front of all 12-digit bar codes so that all bar codes in our FileMaker database appears as a 13-digit code.
Our products in the database are from suppliers from all parts of the world and some are using EAN, while others use UPC.
I need to separate them, so they will reflect the original barcodes (UPC (12) / EAN (13)). We have approximately 33,500 items in the database.
How do I do it?