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.

Indexing a calculation field?

Featured Replies

  • Newbies

Is it possible to index a calculation field that uses another field from another database?

e.g.

In the main database I have a field call "A" which has this calculation:

Max(Academic History::Term)

Any help would be greatly appreciated.

No, because Filemaker doesn't update it's index whenever related records and unstored calculations change. So, the index would be wrong after a change to the record in the related file. It would be a major undertaking and would probably slow Filemaker down way too much for it to track all these things.

The best you can do is create another field that is set to the value of your calculated field by using a Replace command or a Looping script. That field can be indexed, and you can use it in finds and sorts. You just have to update it regularly.

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.