6 Replies Latest reply on Aug 2, 2012 3:16 PM by philmodjunk

    Border / Rule under multiple columns "If" function

    BP

      Title

      Border / Rule under multiple columns "If" function

      Post

      I am a an intermediate-level FP7 user... I have a database that has multiple columns, that may go several lines long. I want to draw a rule / border between each new row, IF there is an entry in a specific column. (I'll try to illustrate here...)

       

      1  9:30 AM   blah, blah, blah        so, so, so

                         blah, blah, blah        not so much

      ______________________________________

       

      2 10:20 AM   huh?                     so much more

                                                      in this column

                                                       than the other

                                                       columns

      _______________________________________

      3                                             see no entry in

                                                     the other two

                                                     columns, but then

                                                     this last column has

                                                     multiple text entries

                                                     before being separated

                                                     with a border

      ____________________________________________

       

      Thanks for any help, or pointing me in the right direction!

        • 1. Re: Border / Rule under multiple columns "If" function
          philmodjunk

          Is each row shown a different record?

          I don't understnad the logic for the second to last line. If the other fields are empty why the line and why there and not a few lines of text lower down?

          • 2. Re: Border / Rule under multiple columns "If" function
            BP

            No, each record has multiple columns and multiple rows. Some columns do not always have an entry and sometimes a column has 1 row of entry, or 10 rows of entry.

            For example, I DO NOT want the borders to look like the following (using my same text entry as above):

             

            1  9:30 AM   blah, blah, blah        so, so, so

            ______________________________________

                               blah, blah, blah        not so much

            ______________________________________

             

            2 10:20 AM   huh?                     so much more

            ______________________________________

                                                            in this column

            ______________________________________

                                                             than the other

            ______________________________________

                                                             columns

            _______________________________________

            3                                             see no entry in

            ______________________________________

                                                           the other two

            ______________________________________

                                                           columns, but then

            ______________________________________

                                                           this last column has

            ___________________________________________

                                                           multiple text entries

            ______________________________________________

                                                           before being separated

            ____________________________________________

                                                           with a border

            ____________________________________________

             

            Obviously, my columns (tabs) are not very uniform in this example, where they would be in my database. And, the rules would all be the same length, IF there is a rule, based on the column that specifies there is a rule IF there is an entry in that column (In this example the column with the numbers.)

             

            I hope this makes my needs clearer.

             

            Thanks!

             

            • 3. Re: Border / Rule under multiple columns "If" function
              philmodjunk

              Then what is an 'entry'? A field?

              I could easily be wrong, but this looks like data that should be separated into individual records for more flexibility.

              And I still don't understand why you have the line I've colored red from your first example:

              2 10:20 AM   huh?                     so much more

                                                              in this column

                                                               than the other

                                                               columns

              _______________________________________

              3                                             see no entry in

                                                             the other two

                                                             columns, but then

                                                             this last column has

                                                             multiple text entries

                                                             before being separated

                                                             with a border

              ____________________________________________

               

              What do the numbers represent?

              • 4. Re: Border / Rule under multiple columns "If" function
                BP

                Each record has columns of multiple fields. I can't specify what each one is, since it's client-proprietary info. But, here is a snapshot of one layout. Hopefully, you can see that each field in each column could be 1 or more lines. Sometimes, no lines of text entry.

                But, I need to draw a rule between the entries based on one of the columns (the one with the number in my above examples)... whatever that might be.

                Sorry, this seems confusing...

                • 5. Re: Border / Rule under multiple columns "If" function
                  BP

                  Also, what you can't see is that I have an option for 100 entries. But in some records may only have 1, and some 20, or some 100.

                   

                  I just want the border to draw in between the fields where the number occurs. And to stop at the last entry in that record (which might be 1, 2, 10, 100).

                  Thanks!!

                  • 6. Re: Border / Rule under multiple columns "If" function
                    philmodjunk

                    You never answered the question: What is an "entry". Is it data in one field?

                    I think that you have many fields where you should have many records, but let's table that for a moment and address the issue at hand. FileMaker cannot dynamically resize fields in browse mode. It can, if printing, previewing or saving as a PDF. I will assume that you need this when printing as we are stopped at square one if you need it in browse mode.

                    Use the Line tool to draw a line at each location where you need a line. It looks like you can draw this line between each row of fields on your layout. That's if the numbers shown represent individual fields and not repetitions of repeating fields.

                    Select all the fields and all the horizontal lines and use the sliding and visibility section of the inspector to set them all (including the horizontal lines) to Slide up and to resize enclosing part.

                    This will cause the lines to slide up to the bottom of the field field immediately above it with the most data. The fields just below it will slide up into a row below this line and so forth....

                    If these are repeating fields and if this is also FileMaker 12, there's a bug that will make this impossible to do unless the FMP 12.02 update fixed it.

                    But a set of related records, one record for each row is much, much more flexible for setting up this kind of report.

                    Key facts about sliding layout objects:

                    1. It's only visible in preview mode and when you print/save as PDF...
                    2. Sliding fields will shrink but not expand.
                    3. All layout objects below and in the same layout part as the slide/resize field need to also be set to slide up and resize.
                    4. Objects in headers and footers will not slide.
                    5. Portals will shrink/slide to fit the number of rows of records, but fields within the portal row will not shrink/slide.
                    6. Fields will slide up only if Top, alignment is specified for it and will slide left only if left alignment is specified.
                    7. Consistent side borders are difficult to achieve with sliding fields.