Here's a thread on barcode scanners and script to automate them: Need help writing script to integrate barcode scanning
Here's a thread with numerous examples on how to set up a scripted find that works from find criteria entered into a global field: Scripted Find Examples
Appreciate for your reply. Is the OnLayoutKeystroke enable for client that sharing from a Host via Instant Web Publishing?
Script Triggers cannot be directly tripped from user interactions with the database when using a web browser to access it. So this does not work from a web client.
Thanks for your reply. Now im understand that Script Trigger does not work from a web client. And at last i decided to use Remote Open from Host. But now i would like to let you know my situation and get advice from you as per below.
I certainly understand on your reply and it seem to be able to apply on my question with a little bit modify with the script. But still need your guidance.
Here is my situation. I had an excel database of 100 person details. With some column that name of Confirmation Code ( Unique # ), Full Name, Date & Time Stamp, Check Box. I created a layout in Filemaker Pro Advanced 12 with these 4 column and imported the database into filemaker pro. Now i wish FM to run a script that Confirmation Code always in ready find mode for a Barcode to be scan. Those barcode to be scan are Confirmation Code. Whenever a Barcode being scanned in find mode, FM automatically will perform find, Date and Time Stamp, Check Box and Save records. And then back to find mode and ready for another barcode to be scanned and the rest of the step. If same Barcode being scanned before, FM will promp and error by saying " Duplicate Check ". And back to Find Mode.
Possible to have all field not able to edit by a User? If is not, any other possibility?
Things that im not understand on your reply in the link above is. How can i set a field that content of " Set Field [YourTable::DataField ; YourTable::ScannedData ]---> ScannedData must have global storage speciifed or this script won't work ". If the file is global storage, it will use one value for entire record. But my Barcode content of Unique Confirmation Code. Please advice, and many appreciate on your help sir.
There seems to be something missing from your description of what you want to see happen when a barcode is scanned. You describe finding the record but do not describe what should happen after that record is found.
How can i set a field that content of " Set Field [YourTable::DataField ; YourTable::ScannedData ]---> ScannedData must have global storage speciifed or this script won't work ". If the file is global storage, it will use one value for entire record. But my Barcode content of Unique Confirmation Code.
You would not store your confirmation numbers in the global field. Only the scannedData field needs the global storage designation. Rewriting the above script step to use your field name:
Set Field [YourTable::ConfrimationNumber ; YourTable::GlobalScannedData ]
Basiccaly im using FM as a event registration system. Participants pre-register before the event, and a Confirmation Code ( Barcode ) will be generate to them after payment done online. During the event, participants will show the Confirmation Code to the registration counter for register. And the staff will scan their code and find their database in FM. Once the Barcode scanned and record found in FM. FM will check on the Checkbox, Date & Time Stamp, and Save record.
If there is someone try to duplicate the code and scanned and found it is registered, FM will prompt a message of " You are Registered on ' Date & Time Stamp' ".
Is that the right way to do that?
It's not fully clear to me what you mean by this:
FM will check on the Checkbox, Date & Time Stamp, and Save record.
Clearly, some sort of "processing" is needed after the record is found, maybe with some user input, maybe not. The exact details will depend on the design of your database as well as what you need to have done at that point. Please note that you have not yet described the design of the tables and any relevant relationships involved. Your script may not even need to perform a find as with the right relationship linking the globalScannedData field to the ConfirmationNumber field, your script can check for the existance of a matching record via the relationship and can use Go To Related Records to pull it up on the screen.
With either method, what happens next is up to you.
May i share my FM file to you, so that you will have a better idea what im looking at?
Or perhaps you could explain what is meant by the statement that I quoted in my last post? Give a simple example in plain English as to what you need to have take place at that point in the process.