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.

Featured Replies

For some reason, this equation only autoupdates,

when I select the field in question, or close and reopen the Filemaker document:

If(index>1;If(index+skip ≠ index; GetNthRecord ( addtoindex; Get(RecordNumber)-1 )+skip;GetNthRecord ( addtoindex; Get(RecordNumber)-1 )+1);index+skip)

where index, skip, and addtoindex are all fields.

and this equation gives the results for addtoindex itself.

Calculation result is a number.

Number of repetitions is 1.

Do not evaluate if all reference fields are empty.

Storage options is set for Do not store calculation results.

And no Global storage is checked.

Filemaker 8.0v3, soon upgrading to version 8.5 for the Mac.

Will this be improved in 8.5, or do I need to do something else that that every time I change the value of skip or index, addtoindex updates without my having to select it first or close the document?

Any calculation field with GetNthRecord() needs to be unstored. Some unstored calcs only update after a Refresh Window [ flush cached join results ] step.

Create a script with the Refresh Window [ flush cached join results ] step and run it to see if the calc updates.

There is proably nothing wrong with FMP.

I have no idea what this is trying to do, but try this calculation instead:

Case(

index > 1 and skip = 0 ;

GetNthRecord ( addtoindex ; Get( RecordNumber ) - 1 ) + 1 ;

index > 1 ;

GetNthRecord ( addtoindex ; Get( RecordNumber ) - 1 ) + skip ;

index+skip

)

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.