After some help on repeating group pagination. i have read through the forums and can see this is an issue, hopefully something is in place now that can handle my requirements.
So it is the old cliche of having a variable amount of records returned to a repeating group. It works great if you have an exact division but as soon as you have some remainder records it repeats the first few records.
Simple example - i have a repeating group with 2 rows and 1 column (so 2 records per page)
Page 1 shows records 1 and 2
Page 2 shows records 3 and 4
Page 3 should just show record 5 - but it shows records 4 and 5
Is there a way around this, i have read all through the forum and can’t get anything to work, closest i have got it is the coaching no code apps video. this sets up the group but doesn’t handle the last page scenario.
If i leave it how it is the end users are getting confused, i need the last page to show unique items and not have ones from previous page
I’ve handled this using states for number of items to show and page. I have a drop down for Items to Show with options of 50, 100, 250, 500, and Entire List. I also use a button to display data, which I’ve found to be helpful so it isn’t constantly trying to update, but that depends on your use case.
Here’s how mine works when Display Data Button is clicked:
Set State Items to the dropdown’s value
Set State Items Start to State Items * State Page - State Items
Set State Items End to State Items Start + State Items
Display Data from State Items Start until State Items End
The next version of List Shifter has a pagination mode that makes this trivial.
Watch for that.
(You CAN handle pagination tracking in Bubble yourself, but it’s SOOOOO overly complicated and slow that it’s kinda not worth the effort. As for why RG’s don’t have outputs to assist when in paged mode, it’s almost inexplicable. It’s another one of those half-baked features one finds everywhere in Bubble.)
