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.

Script to go to record with highest # in a field

Featured Replies

I have a database that uses a field that auto-enters a serial number in a field everytime a nw record is created.

Would there be a way to create a script that would go to the record where the field named "serial" contains te highest number?

LR

The highest numbered record is always the last record entered:

Show All Records <--- if you mean THE the highest number, leave out for "in the current found set"

Unsort

Go to Record/Request/Page (Last)

-bd

If it's not always the last record, you could use the script

Sort [by serial number, descending]

Go to record [first]

Sounds like you're looking for something fancier, so here you go.

Create the following:

1. A calculated field "constant" that = 1

2. A self-join, "constant," that is constant::constant

3. A calculated field "theMax" that = Max(constant::serial number)

4. A self-join, "eureka," that is theMax::serial number

5. Now make a script and/or button to Go To Related Record (eureka)

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.