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.

Finding parameters in formulae

Featured Replies

Is there a quick way where I could locate all instances of a field used in all calculation formulae? e.g. I currently have a field which I update manually - called manual_value. I have now worked out a way to calculate this automatically but there are lots of formulae that operate on this field. Is here an easy way to find which one they are? Thx.

Generate a database design report and use that to locate all instances.

Easy, no. Not so much.

You can save a clone (or copy) of your database.

Open up the clone.

Delete the manual_value field and see what FileMaker warns you about concerning its dependencies.

Or you can use FMP Advanced's feature of creating a Database Design Report.

Analyze this DDR yourself using a tool of your choice.

A text editor will do at a minimum to find all occurrences of "manual_value". A much easier option is to use a third-party DDR parsing tool designed to do the analysis for you.

I use Base Elements.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

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.