How can i create an infinite pagination scroll table on retool?

I've tried to create an infinite scroll (paginated) in retool but I can't. The problem is that I have selected the scroll option in the table settings panel, with the "limit offset based" pagination type but I don't see any changes no scroll (until I change the table size), no value changes for my_table.paginationOffset.
Can someone help me with this problem?
image

Note: we use limit offset pagination type (not cursor-based).

@donoagaradu

Hey there :wave: Thanks for reaching out! You will need to include the total row count for this to work, that should give you the total number of pages: