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