1 Reply Latest reply on Jul 5, 2017 8:17 AM by philmodjunk

    Sub Summary Object Hiding

    rmycholuk

      Hi there,

       

      We have created a daily payment portal that tracks numerous invoice types and payment methods each day. We have created two summary reports based on that information. However, I need to suppress on the summary reports one of the payment methods, but I need that to stay in the original data entry layout.

       

      I need to create a behaviour script that for example - if a payment method is Visa/Debit those records will not appear on the summary reports. However, when I try to create the script either it doesn't work, it says table is missing but the payment methods appear correctly everywhere else.

       

      please help .

        • 1. Re: Sub Summary Object Hiding
          philmodjunk

          Hmmm, I can think of multiple different approaches that fit your description of this issue. Please post back with more details.

           

          The simplest way to keep entries out of a typical FileMaker summary report is to keep those records out of the found set when you produce that report. But other options may also be valid approaches here depending on exactly what you have set up and what you are trying to do with your script.

           

          Screen shots of your report in layout mode, screen shots of your script in the script editor (or copy/pasting it as text if you copy from a Database Design Report, a PDF of your script or via a third party developer tool) are welcome.