AnsweredAssumed Answered

Filemaker script help

Question asked by nilaja_dastane on Aug 14, 2015
Latest reply on Aug 17, 2015 by philmodjunk

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

               

Outcomes