0 Replies Latest reply: Nov 14, 2012 2:09 PM by Robert Lakin RSS

    Automatically switch sheets with interval time

      I'm trying to setup auto tab switching. I've successfully done this in the desktop client but need it for a ajax client. Does auto tab switching not work in ajax? If I sit a click the screen to force the count, it will switch but not on its own.

       

      I'm using the following code in my script:

       

      [Timing]:

      LOAD

      recno() as Tab

      ,rangesum(Seconds,peek(Seconds)) as Seconds

      INLINE [

      Seconds

      15

      15

      30

      ];

       

      [Show]:

      LOAD

      '=' & concat('if(vSeconds<' & Seconds & ',' & Tab,'

      ,') & repeat(')',max(Tab)) as Show

      ,'=mod(round((now()-now(2))*86400),' & max(Seconds) & ')' as Seconds

      RESIDENT Timing;

      LET vShow = peek('Show');

      LET vSeconds = peek('Seconds');

      DROP TABLES [Show], [Timing];

       

      I then use a variable vShow = 1, et... on my sheets.