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
AppleG3QP

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

AppleFD58

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*

Outcomes