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.

Setting cell values in FMP7 via AS

Featured Replies

I need to locate a record on a specific layout and set one of the cells to a value. I have done this thousands of times in FMP6 but am having great difficulty in FMP7. Can anyone help me please?! Here's my code...

tell application "FileMaker Pro 7"

tell database "IMS"

go to layout "shell [imageTemp Lookup]"

show(every record whose cell "id" contains "T0000003")

set cell "status" of current record to "Completed"

end tell

end tell

--This causes "Event Failed" error.

I need to locate a record on a specific layout and set one of the cells to a value.

tell application "FileMaker Pro 7"

tell database "IMS"

go to layout "shell [imageTemp Lookup]"

show(every record whose cell "id" contains "T0000003")

set cell "status" of current record to "Completed"

end tell

end tell

--This causes "Event Failed" error.

I think you may need to be more explicit in the set cell step.

set cell "status" of current record of table "ImageTemp Lookup" to "Completed"

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.