Skip 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.

problems accessing records by their unique ID

Featured Replies

  • Newbies

The Filemaker 7 Apple Events reference describes a custom reference form for records using the unique record ID. The reference "record ID 23" names the record whose unique record ID is 23. I had hoped to use this reference form to communicate between FM scripts and AppleScripts, using Get(RecordID) in FM to identify the unique record ID to pass it to an AppleScript. (Specifically, I use a calculation to create an AppleScript containing that reference.) However, I have discovered that the unique ID for a record as used in Apple Events is not necessarily the same as the value returned by Get(RecordID). In my particular case, IDs less than 128 are the same, but larger ones differ by 32768-128. If this were the whole story, I could work around the problem, but it isn't. I checked a second database, and the pattern is somewhat different. Does anyone know a way to make this work?

At a higher level, what is the best way for a FM script to identify a specific record to an AppleScript? I would like to avoid depending on which layout is current, what the found set is, etc.

Here is some test code:


tell application "FileMaker Pro"

	tell database 1

		get ID of every record

	end tell

end tell

I'm using 7.0v3.

  • 4 months later...

Hi - not an answer to this but did you ever find a solution to this problem vecause i have exactly the same problem!!!

And exactly what problem is that? You need to be very specific in referring to record ID values and tables or layouts with applescript.

Create an account or sign in to comment

Important Information

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

Account

Navigation

Search

Search

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.