4 Replies Latest reply on Sep 14, 2012 8:12 AM by FH

    Populate Field Comments



      Populate Field Comments




           is there any way to automatically polulate the field comments in the "define database" dialog? I'd like to automatically add the information to the field comment, in which script and which layout the field is being used.


           Is there a plugIn that does it or any way to address the field comments with a script or custom function?


           thanks a lot in advance



        • 1. Re: Populate Field Comments

               I could not find any way using FMP to do auto fill of the comments field.


               I try to name a field with self evident use and also makes easy Labels on layout too.

               Such as...

               CustomerLastName or  StreetAddress  [self commented and self labeled]


          • 2. Re: Populate Field Comments

                 Also, if you acquire a copy of FileMaker Advanced, you can generate a Database Design Report that will, among other things, list every field in every table in your file and layout and script that uses it.

            • 3. Re: Populate Field Comments

                   Thanks for the answer: @PhilModJunk 


                   I should have specified that I'm already using the advanced version. So I can create and use DDRs. Just I'd like to extract certain information from it (should be no problem from the XML) and automatically write it to the field comments. So whenever I'm working with my field, I instantly see where they are and which script uses them. Currently I do this by hand, to stay oriented. Helps me a lot when touching a database a few months later.




              • 4. Re: Populate Field Comments


                     thanks for your comment. I'm already doing so.