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:
recno() as Tab
,rangesum(Seconds,peek(Seconds)) as Seconds
'=' & concat('if(vSeconds<' & Seconds & ',' & Tab,'
,') & repeat(')',max(Tab)) as Show
,'=mod(round((now()-now(2))*86400),' & max(Seconds) & ')' as Seconds
LET vShow = peek('Show');
LET vSeconds = peek('Seconds');
DROP TABLES [Show], [Timing];
I then use a variable vShow = 1, et... on my sheets.