AnsweredAssumed Answered

Search for row that contains portion of a string

Question asked by prbsparx on Nov 21, 2014
Latest reply on Nov 21, 2014 by Mike_Mitchell

I am trying to create a script that will auto-fill a Model based on the manufacturer and serial number entered if it exists in the list of models.


Table: Model Lookup


ManufacturerSerial NumberModel

MacBook Pro (Retina, 15-inch, Mid 2014)


MacBook Pro (Retina, 15-inch, Late 2013)



If I have a serial number, "C02MN1JHFD58" I'd like to be able to somehow search the above table, the table find "FD58" and return "MacBook Pro (Retina, 15-inch, Late 2013)"


What is the best way to do this in filemaker? I have the following script:


Set Variable[$Manufacturer; Value:Assets::Manufacturer]

Set Variable[$SerialNumber; Value:Assets::Serial Number]

Go to Layout ["Model Lookup" (Model Lookup)]

Perform FInd[

Model Lookup::Manufacturer =$Manufacturer

Model Lookup::Serial Number =*$SerialNumber



Unfortunately, the *$SerialNumber is exactly opposite of what I'd like to do...I need it to be $SerialNumber = *Model Lookup::Serial Number*