PaulWebb

Quick Find - Numbers and Text Fields

Discussion created by PaulWebb on Sep 27, 2013
Latest reply on Sep 27, 2013 by PaulWebb

I am using the following script to perform quick finds. The field used is a global field (text). It works great so long as I am searching other text fields. Is there a way to set it up so it will also search number fields?

 

FMPro 12 Adv

FMS 12 Adv

 

Perform Script [ “Allow User Abort” ]

Perform Script [ “Set Error Capture” ]
#
Perform Quick Find [ GLOBALS::xquick_find ] If [ Get(LastError) = 401 ]

Show Custom Dialog [ Title: "No " & LeftWords(Get(LayoutName); 1) & " Found!"; Message: "No " & LeftWords(Get(LayoutName); 1) & " was found!"; Default Button: “OK”, Commit: “Yes” ]

Show All Records
Else If
[ Get(LastError) = 400 //These 2 steps added to show all records when no find criteria is entered (the xquick_find field is emptied) ]

Show All Records End If

Go to Field [ GLOBALS::xquick_find ]

 

Outcomes