Finding parameters in formulae

[enquirerfm]

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.

[RodSierra]

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

[TheTominator]

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.