Skip to main content

FileMaker Tips and Tricks

Creating a ExecuteSQL Using "LIKE" in the Query

Example:

ExecuteSQL ( "SELECT nameFirst, nameLast FROM pl_people WHERE LOWER(nameLast) LIKE '%' || ? || '%'" ; " " ; "" ; "jones" )

  • 1 comment

Layne Shipley

/ Navigation JSON /

JSONSetElement ( "" ;

["window" ; "opencard" ; JSONString];

["layout" ; "" ; JSONString];

["layoutName" ; "" ; JSONString];

["recordID" ; "" ; JSONString];

["arrayIDs" ; "" ; JSONString];

["arrayPeopleIDs" ; "" ; JSONString ]

)

window: window, newWindow, openCard
Layout: name of layout to navigate to
layoutName: name for the window
recordID: record ID if you want to go to a specific record
arrayID: an array of IDs you'd like to pass
arrayPeopleID: an array of people IDs you'd like to pass