3 Replies Latest reply on Nov 9, 2011 10:39 AM by Stephen Huston

    Column limits in Table View

    ghoffman

      I'm running up against an unpublished limit regarding the number of columns FMP displays in Table View. I see only about 80 columns when I have more than that number of fields on the layout. I'm delivering a solution to be "Excel-like" but this limitation is killing me. Also, it seems that only the visible columns can export when in Table View. If I switch the view to Form View, I can export all the visible fields on the form.

       

      What is the column limit in Table View and can it be adjusted?

       

      Thanks,

      Gary

        • 1. Re: Column limits in Table View
          ghoffman

          I may have found my own answer in the archive which showed up in "More Like This" once I posted this question.

           

          https://fmdev.filemaker.com/message/4129

           

          This answer says the limit is the width of the layout: 110 inches and that if the columns were smaller, more would fit in the space available.

           

          Is that the general concensus?

           

          Gary

          • 2. Re: Column limits in Table View
            KenNewell

            Gary,

             

            The issue might not be the number of columns is limited but the limit could be overall size of the layout.  IIRC the layout size in FM in limited to 110 inches deep (and has been that way for some time I believe),  I don't remeber if I have ever hit a width constrain on the layout but I do think it also has one.

             

            Could you do something creative with a web viewer displaying your data as an HTML table?  Just a random thought . . .

             

            Ken Newell

            • 3. Re: Column limits in Table View
              Stephen Huston

              Hi Gary,

               

              Regarding the Excel export, keep in mind that Save to Excel and Export as Excel can give you different results in which fields are saved to the Excel file. You may want to script an Excel Export that saves the specific fields you need rather than relying on the current layout to manage those fields.