6 Replies Latest reply on Oct 24, 2014 4:16 PM by beverly

    List Formatting Columns

    hockman11

      How do I get listed data formatted to account for different lengths of number and text variables so they stay in nice neat columns, such as below? Thank you in advance.

       

      Name Name Name

      ### ## ###

        • 1. Re: List Formatting Columns
          erolst

          Well, we don't know the circumstances in which you plan to display that list; let's just say that one way would be to use tabs as column delimiters and display the list in a field formatted with the desired tab stop positions.

           

          No idea if that is applicable in your case.

          • 2. Re: List Formatting Columns
            itraining

            Hi Hockman11

             

            FileMaker provides a few options to view listed data:

            (1) Form View to view a single record

            (2) List View to view multiple records and where each field is a box field or a merge field (each column separated by a tab stop) and possibly a mixture of box and merge fields

            (3) Table View to view multiple records and mimic a spreadsheet

             

            Each viewing option provides beneficial functionality and limitations.

            Please see the attached demonstration database illustrating some of the techniques above.

             

            Hope this helps.

             

             

            Michael Richards

            Brisbane (Australia)

            • 3. Re: List Formatting Columns
              hockman11

              This list would be in a calculation taking data from from fields to list scores from tests.

               

              Test Name       Scores

              Reading               85

              Math             100

               

              The length of the name and scores will vary so I cannot figure out how to account for the the spaces between the name and score differences.

              • 4. Re: List Formatting Columns
                beverly

                h..11, Perhaps this article would help? I often "pad" to make text format (single field) appear in nice columns. I do use the method of setting tab-stops if this is for use in FMP on a layout. However, these tab settings do NOT translate if the text needs to be inserted into an email, for example. Ergo the method I outline in the article:

                 

                     <http://filemakerhacks.com/2012/08/29/fixed-width-for-edi-and-other-reporting/>

                 

                 

                Beverly

                • 5. Re: List Formatting Columns
                  keywords

                  Don't overlook what erolst said: the data is displayed "in a field formatted with the desired tab stop positions".  You set the tabs using the Appearance Inspector.

                  • 6. Re: List Formatting Columns
                    beverly

                    Absolutely! tabs stops are handy for right-justifying (numbers) or on the decimal point (numbers). Study up on how these little wonders work.

                     

                    It all depends on where the data needs to be displayed...

                     

                    Beverly