Barcode Database Search w/ Filemaker 13

[tdaumit]

Hey guys,

 

I am trying to create a script that will preform a search and pull up a record in my FM database with a barcode scan from CMS Barcode.

 

I have already setup CMS Barcode so that the barcode number imports into a text field in my database with a scan, however from there I am stumped. 

 

The script can't be that complex, and CMS only offers limited information. Any help would be appreciated!

 

Tomio

[Wim Decorte]

What exactly is stumping you?  Expand a bit on what you have and what needs to happen?

[tdaumit]

Wim, I can't figure out how to perform a find using a script. 

 

I am trying to:

 

1. Perform find with the scanned barcode

2. Open matching record from find, or create new record if nothing is found.

 

This is what I have so far, I am not sure what do script before and after when using CNS Barcode...

 

#

Enter Find Mode [ ]

Set Field [ ]

Perform Find [ ]

[Ed Bradley]

tdaumit, Configure your barcode reader to put a return after barcode scans. Then set the field to advance with return, create a trigger after field exit script that sets a variable of the field contents then finds the matching record or if none found create new record setting the field with the variable. Then your are ready to add the other information in the new record or edit the existing found record.

 

Depending on what you are trying to do, there may be a better way to write the script.

 

Set Variable [$scan; table::fieldname]

Perform Find(fieldname; $scan)

If[get(foundcount)]

    Halt script

Else

    New Record/Request

   Set Field[table::fieldname; $scan)

End If

[tdaumit]

Hey guys,

 

After setting up my solution with FM12 and CNS Barcode, they released FM13 with the barcode scanning feature built in, so I am now trying to set-up the new system. Here's a breakdown of what I am trying to accomplish (again):

 

Using FMGO13, scan a barcode and pull up the item profile, that's it. Should be easy enough, but for some reason I can't get it to work.

 

I have tried:

 

Go to Layout...

Insert from Device

Perform Find

Go to Related Layout

 

but this doesn't work...

 

Any help would be appreciated! Thanks Guys!

[Lee Smith]

I merged your two questions, Please do NOT multiple post your questions.