Jump to content
Sign in to follow this  
OYoung

Calculation that returns all layouts a field is found on

Recommended Posts

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Time to upgrade to FMP 9.0 Advanced!

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

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