App sheet button to display 5 rows at a time in views

[sandeepraon]

hi app sheet developer community, 

i built an app with a spreadsheet with two sheets, one mastersheet - which contains n (66) rows in one sheet and other child sheet which references the master sheet containing only has 6 rows , 

i made two views, one with master sheet and the other with 6 rows - both with table view type.

1)need a button in a view  , when clicked would iterate , the current 6 rows and show me the next 6 rows

2)while the above 1)is done,  of iterating to next six rows and displaying , I also would like to have a the old 6 entries marked as read/flagged by having a column in the master sheet in the spreadsheet with  a column (name: flag) to switch from false to true(default) indicating that they are read,  so that they disappear from the view in the master view.

Please suggest how can these two actions be performed. please share any template examples  if you know of for reference would be really appreciated.

[Luis_Rodriguez_ · Accepted solution]

Intersting solicitation.

I think its possible by using slices and action button + VC to filter the rows as you change some value to filter. So this is an idea :

create a slice and set the 'flag' column you suggest to be equal to 'false'  so it filter only the ones not seen.

then create a button to set the value of a column in a row and set the value of column FLag to true. In behavior 'Only if this condition is true': insert a condition so that only affect the 6 first records of the table.

[sandeepraon]

Thank you , yes i thought about the logic and redesigned to fetch all the content from 1 sheet / table in that way i can have an extra column for display and use the display column to iterate to set the selected rows displayed . 

seems to work for now and as the previous reply , the slice and actions with expressions worked to my requirement.