April 13, 201015 yr 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.
April 13, 201015 yr 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