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

Tap the Share icon in Safari
Scroll the menu and tap Add to Home Screen.
Tap Add in the top-right corner.

To install this app on Android

Tap the 3-dot menu (⋮) in the top-right corner of the browser.
Tap Add to Home screen or Install app.
Confirm by tapping Install.

FMForums.com

Sign In

Email Address

Password

Remember me
Not recommended on shared computers

Forgot your password?

Or sign in with...
Sign Up

Where are all the functions?

September 11, 20232 yr

Recently a client asked me where all the MBS functions are. Looking in the calculation dialog, you see just MBS listed:

If you ask why we don't have over 7000 functions listed there, the answer is easy: It would be a nightmare for you to use.

Recently I made a special version of MBS Plugin to register all functions individually and show them in the calculation dialog right away:

You don't see the scrollbar on the screenshot, but all 7000 functions are there. The dialog takes about 12 seconds to open as FileMaker adds all the functions to the list. And it takes another 10 seconds to open the MBS section there. There is a significant time cost for having a lot of functions there and thus we don't do this normally.

Please pass the function name to MBS() as first parameter to pick the function. Take benefit from being able to pick a function name from a field or calculation.