Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Applescript set cell error

Featured Replies

  • Newbies

New to filemaker, and applescript for that matter, here and I have run into a problem while trying to make sense of some of the old scripts. There is a problem with one of the applescripts within the fm scripts. I will paste the script below but basically it is looking for a folder on the users desktop and copying it to another drive and vice versa, this part seems to work fine. It seems to have a problem when a flag field in the database is set, using “set cell”, to indicate if the folder was found or not. I’m getting an “object not found” error. The odd thing is that we are upgrading from FM 5.5 to 11 and it works for the users using 5.5, but only gives me the error when setting up a testing environment using FM 11. Any help is greatly appreciated!

tell application "Finder

activate

if exists folder "1107CTCR0002MEHEP3" of folder "08" of folder "07July" of folder "2011" of disk "ProdTest" then move folder "1107CTCR0002MEHEP3" of folder "08" of folder "07July" of folder "2011" of disk "ProdTest" to folder "In Progress" with replacing

tell application "FileMaker Pro Advaned

activate

set cell "CRA on server nt found flag" of current record to 0

end tell

else

tell application "FileMaker Pro Advanced"

activate

set cell "CRA on server nt found flag" of current record to 1

end tell

end if

if not (exists folder "1107CTCR0002MEHEP3" of folder "08" of folder "07July" of folder "2011" of disk "ProdTest") then

if exists folder "1107CTCR0002MEHEP3 " of folder "08" of folder "07July" of folder "2011" of disk "ProdTest" then

with replacing

tell application "FileMaker Pro Advanced"

activate

set cell "CRA on server nt found flag" of current record to 0

end tell

else

tell application "FileMaker Pro Advanced"

activate

set cell "CRA on server nt found flag" of current record to 1

end tell

end if

end if

end tell

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.