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.

GetNthRecord question

Robert Collins
in Calculation Engine (Define Fields)

Featured Replies

I am trying to look up a value of a related record

but am having some trouble.

The relationship between the two tables is a phone

number and one of the tables holds multiple records with this telephone number. I would like to obtain a fields contents from the last record oof this table. I thought about using the getNthrecord function but this requires knowing the record number so what I need is something like this

GetNthRecord (field ; lastrecord)

is there a way of Getting the last related record for this to work?

thanks

Well,

GetNthRecord ( related::field ; Count ( related::phone ) )

could do it, but

Last ( related::field )

would be a lot simpler. Note that they are not exactly the same, and you will see a difference if the last related record's field is empty.

See also:

http://fmforums.com/forum/showtopic.php?tid/198224/post/303896/#303896

  • Author

thanks for that

Create an account or sign in to comment
Go to topic listing

Important Information

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

I accept

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.