Calculation that returns all layouts a field is found on

[OYoung]

Hi:

I've inherited a rather cumbersome database with one table, 1400 fields, and hundreds of layouts. I'm trying to eliminate unused fields. I'm familiar with the Functions: FieldNames and LayoutNames. Is there a way to get Filemaker to tell me every layout a particular field is used in?

Thanks

[AudioFreak]

With the Developer version you can get a full report. It's now Called Advanced.

HTH

Michael

[OYoung]

Hi:

Unfortunately, I do not have the Developer version. I just wondered if there was a way using Functions and/or Scripts to workaround this.

[David Jondreau]

http://fmnexus.com/InspectorLite.html

This is a great free tool for what you're facing.

[AudioFreak]

Thanks for the link David I was not aware of that software.

Michael

[OYoung]

Hi:

Thanks for the suggestion. I went to the web site and also saw a freeware called "FindIt", but unfortunately both that and your suggestion require v8 and I only have FMP 7.

[Vaughan]

Time to upgrade to FMP 9.0 Advanced!

[David Jondreau]

You're welcome. The software is pretty awesome.

You do need Advanced to create the DDR though. Sorry about that OP.

[comment]

I don't think it would be too hard to script your own "pseudo-DDR". Start by having your script loop through the layouts and create a new record in a Layouts table, with the layout name. Then you can use the FieldNames function to get the fields of each layout.