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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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