AnsweredAssumed Answered

Script and Barcode reader

Question asked by mrcmrc on Nov 26, 2018
Latest reply on Nov 27, 2018 by Reid Larson

Like • Show 0 Likes0
Comment • 5

I'm using FM15 Advanced on a Mac and need help with building a script that involves using a barcode reader (a TaoTronics TT-BS014).

The script has the following steps:

Go to Field [ Maga::Barcode ]

Enter Find Mode [ Pause: Off ]

If I run this script FM goes in Find mode and position the cursor on the Barcode field, I can use the barcode reader to scan a barcode and enter it in the field and perform find.

I don't need any further step like "Perfom find" because when I press the barcode reader button it scan the code and then is like pressing an "enter" key, because - after the script - I see the found record but I'm in Browse mode (not in Find mode).

My problem is that I wish to perform an action on the found record: I wish to set a field with a custom content (Set Field). But any instruction I insert after the two steps above happen 'while' the find and not after.

E.G.: If I enter as third step

Set Field [ Maga::Status ; "in house" ]

FM add that to my find (and do not find anything), do not perform the command after the find.

Any idea on how to bypass this problem?

Thanks,

- Marco.

No one else has this question

Outcomes

user29536 Nov 26, 2018 11:48 AM

See Photo

Edit, sorry this system is for adding from a barcode reader, but I hope this may help you figure out your needs.

Actions

Reid Larson Nov 27, 2018 7:12 AM

I use global fields for all my barcode scanning needs. Then I use an OnObjectKeystroke script trigger on the field and Code ( Get ( TriggerKeystroke ) ) to check for the scanner's appended character. This allows me to script the entire process needed after the scan. Your script might look something like this:

Set Variable [ $ctks ; Value: Code(Get(TriggerKeystroke)) ]
If [ $ctks and $ctks <> 10 and $ctks <> 13 ]
     Exit Script
End If
Set Variable [ $barcode ; Value: GLOBAL::FIELD ]
Enter Find Mode [ Pause: Off ]
Set Field [ Maga::Barcode ; $barcode ]
Perform Find [ ]
If [ Get(FoundCount) ]
     Set Field [ Maga::Status ; "in house" ]
End If
Exit Script [ Text Result: False ]

Actions

mrcmrc @ Reid Larson on Nov 27, 2018 12:44 AM

Thanks for your reply Reid,

just a little clarification about "Set Variable", I can not replicate exactly the steps 01 and 05 because when I insert the "Set Variable" command if want a "value", the result I get in script editor is:

Set Variable [ $ctks ; Value: Code ( Get ( TriggerKeystroke ) ) ]

the editor add "Value:"

Set Variable [ $barcode ; Value: GLOBAL::FIELD ) ) ]

Another thing: I understand that with "Set Script Trigger" and "OnObjectKeystroke" I can start the script, but however I need before to click in that field, then using the barcode reader, right?

Thanks again,

- Marco.

Actions

mrcmrc @ user29536 on Nov 27, 2018 12:44 AM

Thanks!

Actions

Reid Larson @ mrcmrc on Nov 27, 2018 7:16 AM

mrcmrc wrote:

Thanks for your reply Reid,
just a little clarification about "Set Variable", I can not replicate exactly the steps 01 and 05 because when I insert the "Set Variable" command if want a "value", the result I get in script editor is:

Set Variable [ $ctks ; Value: Code ( Get ( TriggerKeystroke ) ) ]

the editor add "Value:"

Everything before the semicolon (";") is the variable name. Everything after is the value you should set the variable to. I was writing it off the top of my head, so it didn't look exactly like it would in the script workspace.

mrcmrc wrote:

the editor add "Value:"

Set Variable [ $barcode ; Value: GLOBAL::FIELD ) ) ]

You would need to create the text field with global storage to enter your barcode into.

mrcmrc wrote:

Another thing: I understand that with "Set Script Trigger" and "OnObjectKeystroke" I can start the script, but however I need before to click in that field, then using the barcode reader, right?

On FileMaker Pro you could use an OnLayoutKeystroke script trigger to do this automatically, but I'd start with just getting the scanning working how you want. You could still use your original Go to Field [ Maga::Barcode ] step if you thought it was necessary.

Actions

5 Replies

user29536 Nov 26, 2018 11:48 AM
Mark Correct
Correct Answer
See Photo

Edit, sorry this system is for adding from a barcode reader, but I hope this may help you figure out your needs.
Like • Show 0 Likes0
Actions
Reid Larson Nov 27, 2018 7:12 AM
Mark Correct
Correct Answer
I use global fields for all my barcode scanning needs. Then I use an OnObjectKeystroke script trigger on the field and Code ( Get ( TriggerKeystroke ) ) to check for the scanner's appended character. This allows me to script the entire process needed after the scan. Your script might look something like this:
```
Set Variable [ $ctks ; Value: Code(Get(TriggerKeystroke)) ]
If [ $ctks and $ctks <> 10 and $ctks <> 13 ]
     Exit Script
End If
Set Variable [ $barcode ; Value: GLOBAL::FIELD ]
Enter Find Mode [ Pause: Off ]
Set Field [ Maga::Barcode ; $barcode ]
Perform Find [ ]
If [ Get(FoundCount) ]
     Set Field [ Maga::Status ; "in house" ]
End If
Exit Script [ Text Result: False ]
```
Like • Show 0 Likes0
Actions
mrcmrc @ Reid Larson on Nov 27, 2018 12:44 AM
Mark Correct
Correct Answer
Thanks for your reply Reid,
just a little clarification about "Set Variable", I can not replicate exactly the steps 01 and 05 because when I insert the "Set Variable" command if want a "value", the result I get in script editor is:

Set Variable [ $ctks ; Value: Code ( Get ( TriggerKeystroke ) ) ]

the editor add "Value:"

Set Variable [ $barcode ; Value: GLOBAL::FIELD ) ) ]

Another thing: I understand that with "Set Script Trigger" and "OnObjectKeystroke" I can start the script, but however I need before to click in that field, then using the barcode reader, right?

Thanks again,
- Marco.
Like • Show 0 Likes0
Actions
mrcmrc @ user29536 on Nov 27, 2018 12:44 AM
Mark Correct
Correct Answer
Thanks!
Like • Show 0 Likes0
Actions
Reid Larson @ mrcmrc on Nov 27, 2018 7:16 AM
Mark Correct
Correct Answer
mrcmrc wrote:

Thanks for your reply Reid,
just a little clarification about "Set Variable", I can not replicate exactly the steps 01 and 05 because when I insert the "Set Variable" command if want a "value", the result I get in script editor is:

Set Variable [ $ctks ; Value: Code ( Get ( TriggerKeystroke ) ) ]

the editor add "Value:"
Everything before the semicolon (";") is the variable name. Everything after is the value you should set the variable to. I was writing it off the top of my head, so it didn't look exactly like it would in the script workspace.

mrcmrc wrote:

the editor add "Value:"

Set Variable [ $barcode ; Value: GLOBAL::FIELD ) ) ]
You would need to create the text field with global storage to enter your barcode into.

mrcmrc wrote:

Another thing: I understand that with "Set Script Trigger" and "OnObjectKeystroke" I can start the script, but however I need before to click in that field, then using the barcode reader, right?
On FileMaker Pro you could use an OnLayoutKeystroke script trigger to do this automatically, but I'd start with just getting the scanning working how you want. You could still use your original Go to Field [ Maga::Barcode ] step if you thought it was necessary.
Like • Show 0 Likes0
Actions

Script and Barcode reader

Outcomes

Related Content

Recommended Content