Running into a dilema that I can’t seme to find an answer for. Imagine I have a database with 10 items. Call them items 1 through 10. I have a fixed repeating group that has 1 row and 4 columns. So, when the data is displayed, I see items 1 through 4 from my database. I have a workflow that runs every 5 seconds to show the next page, but it shows items 5 through 8. What I am trying to do is advance the position by 1 every 5 seconds. So, after five seconds, my repeating group will show items 2 through 5, not 5 through 8, which is waht happens when Is use “Show Next Page”. Thanks in advance for any help!
-You need to use display data in repeating group action, not show next page.
-You’ll have to have a custom state that saves which number you’d like to start from.
-Every time 5 second elapses, increment that number by 1.
-And display data in repeating group: your search:items from “saved number”, items until 4.
-If the “saved number” is bigger than the search’s count - 4, (for example, you’re at item 9, 10, 1, 2) you have to use “merged with”;
-So for 9 & 10, keep using display data in repeating group items from “saved number”
-Then merge that search with the same search but just with items until (4 - (search count - “saved number - 1”)); I would recommend using Arbitrary text converted to number for this math.
If search count is 10 items, and saved number would be 9, it takes 9 and 10, then does a calculation of (4 - (10-(9-1)) → (4-2) = items until 2.
End result is items 9,10,1,2.
Cheers 
This topic was automatically closed after 70 days. New replies are no longer allowed.