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

    Populate Field Comments

    FH

      Title

      Populate Field Comments

      Post

           Hi,

            

           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

            

           Francis

        • 1. Re: Populate Field Comments
          JimMac

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

               However...

               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]

               Jim....

          • 2. Re: Populate Field Comments
            philmodjunk

                 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
              FH

                   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.

                   best

                    

                   Francis

              • 4. Re: Populate Field Comments
                FH

                     @Jim

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