AnsweredAssumed Answered

RFID tag to lookup customer's membership record

Question asked by evostrength on Nov 7, 2017
Latest reply on Nov 5, 2018 by HOnza



I'm quite new to FileMaker and I'm trying to figure out what would be the best way to write a script in order to find a customers membership profile from an RFID scan.


I have one table that currently has a global field which is the field where the RFID reader inputs the customer's specific RFID code. Each customer has their own record in a separate table with a field where their specific RFID code is stored.


After my RFID reader inputs the 10 digit sequence of numbers from scanning the customer's keyfob into the global field, it will also input the "enter" key (if I use notepad, the sequence of digits are entered and then it moves down to a new line...I would assume that's considered a linefeed and not a carriage return for the purpose of scripting).


Anyway, this is the OnObjectKeystroke script trigger on the "Member Check In" field that I have so far:


If [ Code ( Get ( TriggerKeystroke ) = 10 )]

     Go to Layout ["LayMembers" (Members); Animation:None]

     Enter Find Mode [Pause:Off]

     Set Field [Members::FOB #; Menu::Member Check In]

     Set Error Capture [On]

     Perform Find []

     If [ Not Get ( FoundCount ) // No Member Found]

          Show Customer Dialong ["No Member Found"]

     End If

End If


FOB # - the customer's specific rfid code field

Member Check In - the global field which the customers keyfob scans into.


I'm fairly confident I've excluded some important step altogether, but I am at a loss for what it might be at the moment.

Any help is appreciated. Thanks!