5 Replies Latest reply on Aug 17, 2015 7:03 AM by philmodjunk

    Filemaker script help

    nilaja_dastane

      Title

      Filemaker script help

      Post

      Hi,

      Can you provide me some example on how to work with scripts? How to generate report from database table  and show it in layout by using script.

       

      Like I have table and want to show some calculated data quarterly basic. I can easy do that by ExecuteSql by group by command. But don't know hot to assign it to variable and then again show it in layout. Is there a solution for this to show all the generated data as shown in below chart by using script.

      Or there is any other way?

       

       

       

       

                                                                                                                                                                                                                                                                                                                                                                                                                                                     
                     

      Quarter

                     
                     

      Total calc1

                     
                     

      Total Calc2

                     
                     

      Q2FY2010

                     
                     

      55

                     
                     

      111

                     
                     

      Q3FY2010

                     
                     

      11

                     
                     

      222

                     
                     

      Q4FY2010

                     
                     

      22

                     
                     

      333

                     
                     

      Q1FY2011

                     
                     

      33

                     
                     

      444

                     
                     

      Q2FY2011

                     
                     

      44

                     
                     

      555