Applescipt find in Filemaker 13 not working

I’ve used this script in another Table on the same database with no problem.


tell application "FileMaker Pro"
	display dialog "Please enter a SPEC Number." default answer "" buttons "OK" default button 1
	set specNum to text returned of result as string
	if specNum = "" then
		return 0
	end if
	tell database "2018 GS_RVTG"
		go to layout "SPEC ADS"
		try
			show (every record whose cell "Spec Ad Number" = specNum)
		on error
			display dialog "Couldn't find a record of SPEC Ad:" & return & "\"" & specNum & "\"" buttons {"OK"} default button 1 with icon 1
			return 0
		end try
	end tell
end tell

Here are the results from the Script Editor. It just stays on the same record and doesn’t perform a find.

tell application “FileMaker Pro”
display dialog “Please enter a SPEC Number.” default answer “” buttons “OK” default button 1
go to layout “SPEC ADS” of database “2018 GS_RVTG”
show every record of database “2018 GS_RVTG” whose cell “Spec Ad Number” = “1001”
end tell

It is searching the correct cell because when I use a number that in not in the “Spec Ad Number” Cell, it comes back with the built in error dialog.

Any Ideas why this is not working in this table?

Rob

Does this thread help?

http://macscripter.net/viewtopic.php?id=43617