creating find script

[raitis]

dear fmforum users,

if you could help me, i would be very grateful.

i am trying to add a find script to my database.

i have a database on my pc with products.

i printed labels with barcodes.

i installed filemaker go on my iphone and copied my database to it.

i used this script to add a SCAN button and launch a script which starts PIC2SHOP app, scans my barcode and returns it to filemaker GO. http://www.skeletonkey.com/blog/filemaker_go_barcode_scanning_with_pic2shop

everything works except the last part. the scanned value has to be put in a search script and i cant find how to do this.

i want to be able to scan my product and automatically find it in my database.

my first script looks like this:

"pic2shop://scan?callback=fmp7script%3A//%24/" & Get ( FileName ) & "%3Fscript%3DScan%26param%3DEAN"

and the second one is called SCAN and looks like this:

(file in the attachment).

rr

[bcooney]

I haven't used this, but it seems to me that the possible problems are:

1. You are finding in the Products table for a barcode, but you are not in a barcode field, you're in the ProductID field. ProductIDs should not be barcodes. They should be auto-enter serial numbers that are meaningless.

2. Perhaps you're not even in the Products table ( a context problem). Add a Go To Layout (Products) before your Find.

hth,

Barbara

[imoree]

I haven't used this, but it seems to me that the possible problems are:

1. You are finding in the Products table for a barcode, but you are not in a barcode field, you're in the ProductID field. ProductIDs should not be barcodes. They should be auto-enter serial numbers that are meaningless.

2. Perhaps you're not even in the Products table ( a context problem). Add a Go To Layout (Products) before your Find.

hth,

Barbara

funny thing is Barbara. Context is very difficult when your RG becomes crazy!! Dont ya think?

[bcooney]

That's why I'm a big fan of Anchor-Buoy (although that'll start a debate). Any method that allows you to easily determine your context is absolutely essential.

[raitis]

I haven't used this, but it seems to me that the possible problems are:

1. You are finding in the Products table for a barcode, but you are not in a barcode field, you're in the ProductID field. ProductIDs should not be barcodes. They should be auto-enter serial numbers that are meaningless.

2. Perhaps you're not even in the Products table ( a context problem). Add a Go To Layout (Products) before your Find.

hth,

Barbara

thanks.

1. i will try to add a auto enter serial number field. but i dont know how to do this.

2. i will add a go to layout..

rr

[bcooney]

1. Auto enter serials are available as an entry option in Define Fields.

FM Help

[raitis]

i managed to modify the script, so it scans my barcode and then returns the value into filemaker.

the problem is that the scanned value is not entered in my search field, but instead just the text Get(ScriptParameter).

this is how it looks on my phone:

can anyone help?

[bcooney]

Raitis,

Do you have a Barcode field?

I would think that your Scan script should look like this (let's assume that it's a barcode value in your Get (scriptparameter):

Go to layout ( equipment)

Enter Find Mode

Set Field ( barcode ; Get (scriptparameter) )

Perform Find

[raitis]

Raitis,

Do you have a Barcode field?

I would think that your Scan script should look like this (let's assume that it's a barcode value in your Get (scriptparameter):

Go to layout ( equipment)

Enter Find Mode

Set Field ( barcode ; Get (scriptparameter) )

Perform Find

thank you very much!!!!

it works!

[Lee Smith]

Hi Barbara,

1. Auto enter serials are available as an entry option in Define Fields.

FM Help

This link didn't work when I clicked on FM Help, however when I went in and grab the URL directly, it worked?

http://file:///Applications/FileMaker%20Pro%2010%20Advanced/FileMaker%20Pro%20Advanced.app/Contents/Resources/English.lproj/FileMaker%20Pro%20Help/html/create_db.8.18.html#1029444

Lee