Enable display of all records in table

Right now we're limited to 10, 25, 50, 100, with an option to allow users to set the total number to up to 1000. I want to be able to just show all of them at once.

Thanks Tony is a great solution, I will take this thread and add a new solution in case someone helps.

There is a way to configure the table option to be able to directly display 1000 or 9000 or 2 or 44... records without the need for the user to select how many records he wants to view.
Knack in table options only lets you select up to 100 records.

I do not have any table with more than 1000 records, but if someone can try it on a table with more records and tell me if it also works in the case of wanting to show 10,000 or unlimited. We will be grateful.

I will explain this solution with a video, no code is required: (well only one line of html):

https://www.loom.com/share/237a458383c54d1580c4f01b135d8031

Regards.