No photos are visible. Did you upload a gif, png or jpg file? Those are the only file formats you can upload.
If you search this forum for "bar code" you should find a number of threads on this subject. Some include sample scripts and a discussion of how to use a barcode scanner to trip script triggers in order to fully automate the scanning process.
The first part depends on your scanner. You'll have to consult the techical info that comes with your scanner or the tech support folks for your scanner, but it should be possible to configure the scanner to put some text at the beginning and end of the data scanned from the bar code. The initial characters--such as shift-capslock-~ that i've used in some of my solutions can trip the OnLayoutKeystroke trigger. The script can use Get ( TriggerKeystroke) and Get ( TriggerModifierKeys ) to detect that the programmed character combination was pressed. If so, it can use go to field or go to object to put the cursor in the correct field for receiving the scanned data. Exit Script [False] can then keep the ~ or other such triggering text from actually being input into a field on the layout.
The second step is to use that same configuration set up for your scanner to have it put a tab, return or enter key character at the end of the scanned data. You can then set up field behavior on your field to respond to that character to exit the field and then the OnObjectExit trigger can then be used to detect the fact that the data has been fully scanned in and thus can process the data thus scanned--such as using it to perform a find for records with that bar code.
The added benefit to this approach is that if the scanner breaks down or you have a label that won't scan, you can click into the field, type in the data and press tab, enter, or return and the system will process the data just as though you had scanned it.
Sorry about that, i meant to upload but forgot in the process, I just uploaded now. As for the 1st answer it is a scanner that replicates keyboard key strokes as if you were going to type in barcode #'s manually so for instance if i were to scan a barcode and underneath the barcode it stated 000167 that 000167 would be populated into the field asset tag field.
Looking at your response it looks to be as if maybe my best bet would just to create a script so that the cursor will default to its location and when bar code is scanned then the info will autopopulate with the given script at hand.
My only and very major problem is..... I do not know how to script in filemaker pro or even script for that matter. Is there some kind of script i can manipulate to do exactly what id like to do? THanks again
If you plan on using FileMaker and don't know how to create scripts, you need to learn as scripts are a major way to automate behavior.
it is a scanner that replicates keyboard key strokes as if you were going to type in barcode #'s manually
That's called "keyboard emulation" and almost all scanners function in that mode. Almost all can be configured to include additional data at the beginning and end of the scanned data. How to configure them to do that depends on the scanner. Some scanners are configured by scanning special bar codes included with the scanners user manual--others come with software for doing the configuring. You'll need to check the techincal info that came with your scanner to learn how to do this if you want to automate the scanning process.
BTW, any settings you select in Manage | Database | Fields do not affect the tab order for fields on a given layout. To change those settings, enter layout mode and select "set tab order..." from the Layouts menu.
Sweet I just got my curser to finally go where it needs to go. Now all i need to do is get my scanner to press "enter" after each scan of a bar code. and from what I am understading this is only possible by creating a script?
and also configuring your scanner to add that character to the scan data.
Wait I'd have to create a script into the scanner as well as FileMaker
Why would you need to do that?
I thought you said in order to autopulate I'd have to create a script?
Yes, but you do not need to "script into the scanner", unless I am misunderstanding what you mean by that phrase.
There is no need to control the scanner from a script, provided it is configured properly to send the necessary "control characters" at each end of the string of data scanned in from the bar code label.
Hey Phil just want to thank you for all your help and response. So let me recap here, On the first post where the first field is "Asset Tag" I scan that with my barcode scanner which puts in ex 000167, and in order for the rest of the fields to generate the information to populate the rest of the fields id have to create a script into the scanner that states, "when scanning this barcode i then want you to press enter so that it searches the DB and fills in the proper info"
The reason for the re-cap is because I just am trying to undestand how i would script into a barcode scanner, but i guess that would have to be done with the manufacturer of the scanner. But my other question would be cant i just program that field to say "when info has been inputed into this field look in the DB to populate the below?" Sorry for the lack of knowledge i am just trying to grasp this and try and understand it. Thanks again in advance.
That is not what I meant.
You configure the scanner so that when you scan a barcode with 000167, text such as ~000167<enterKeyCharacter> is input. An OnLayoutKeystroke script trigger set on this layout detects the ~ and puts the cursor into the correct field and uses Exit Script [False] to keep the ~ from being entered into the field. The field is set up with a field behavior setting that responds to the enter key as the signal to exit the field. An OnObjectExit trigger set on this field then performs a second script, if needed to pull up your data.
What that script does depends on the design of your database. You can scan into a global text field and this script can then perform a find to find the record matching that barcode or it can create a new record and copy the value in the global field into a field in this new reord with a relationship that then matches to a record for that asset in a related table and thus the other fields on the layout--taken from that related table will display the correct data.
With this set up correctly, all you have to do is scan barcodes and everything else happens automatically.
Ok so I am finally getting somewhere, I got my scanner utility installed on my computer and programmed it to input ~ and send an enter after, but heres thes problem I am currently facing, I cannot get my scanner to inpute the information that I have scanned. This is where I am lost, will it be configured on the filemaker pro side or the scanner side?
If you click into a text field or just open a word processor and scan a barcode, does the data appear in the field?
If it does, then have you set up the layout based script trigger for selecting your field?
If it hasn't you'll need to consult your scanner's tech support to find out why. (Make sure that it's functioning in "Keyboard emulation mode".)
Right now i am just working on getting it to scan and then just input the text on the specific field, below are my fields when i scan it puts in ~ but does not enter the text from the barcod. This is what happens when i scan ~ < no text > Enter, when i want it to do ~ < asset tag # > Enter that way it performs the find and inputes the data in the fields such as username, dept etc