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.

Custom Function Bug?

Featured Replies

I discovered this with a much more complex calc, but am able to reproduce it by doing the following:

1. Create a new database file.

2. Add a field called EntryField that is a number field.

3. Add a custom function called "Series" that takes one parameter with the following definition:

Any function or expression that references a Get function has to be unstored. Does the "bug" still occur if the calculation is unstored?

Hi Vaugham,

i think Get( CalculationRepetitionNumber )

is the one notable exception....

  • Author

Whether the field is stored or unstored changes nothing about the bug. I had thought of that, which is how I discovered that switching the stored/unstored status will allow the calc to be updated.

Chuck

FileMaker Version: Dev 7

Platform: Mac OS X Panther

This seems to have something to do with the calculation not being able to "see" that repetitions are being used inside the custom function.

Changing the CalcField to be defined as:

Series(EntryField) & Left( Extend(EntryField); 0 )

also causes the update to occur for all repetitions.

A cleaner one that fixes the problem is:

Series(Extend(EntryField))

and then the Extend() is not needed inside the custom function either.

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.