Change per page record count

[jbk68]

Looking for a way to increase that to 2500, 5000 or even better “Show All”

Didn't know if KTL currently has this or if this is something that can be added.

If anyone knows a way of adding it and has a script, it would greatly appreciated if you go share it with me.

Any and all help on this would be appreciated… JON

[CSWinnall]

Hi @jbk68

As far as I know Knack has a limit of 1000 records. So the KTL will too. The issue will be load time if it was possible. If you want to load more records you may need to look into API and load more records as you scroll (infinite scroll or lazy load records).

Craig

[CSWinnall]

The other option is filtering records or using KTL public filters so uses can quickly zoom in on certain records.
Another option is search tables to refine the records.

Why would you want to show that many records. If you give more context there may be other ways to help.

[jbk68]

Thanks Craig for the responses. The only reason I want to be able to view or load more records than 1000 at a time is because I have created an export button that exports my data to .xlxs format with selected table data and due the fact I can only view 1000 records max, I can only export 1000 records max at a single time. So when I have a table with say 5000 records, I literally have to export 5 times (page1, page2 etc...)

…

On Sat, Aug 24, 2024, 4:25 PM Craig Winnall ***@***.***> wrote: The other option is filtering records or using KTL public filters so uses can quickly zoom in on certain records. Another option is search tables to refine the records. Why would you want to show that many records. If you give more context there may be other ways to help. — Reply to this email directly, view it on GitHub <#344 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BAZFANAAY3BTHZWX37VVYOLZTD23LAVCNFSM6AAAAABNB4J6J6VHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTANBTHE4TAOA> . You are receiving this because you were mentioned.Message ID: <cortexrd/Knack-Toolkit-Library/repo-discussions/344/comments/10439908@ github.com>

[CSWinnall]

Hi Jon

When you use _dr in the URL you should see where the number of rows is. It's something like

rows_per_page =1000

Have you tried changing that to a higher number to see if it is possible.

Craig

[jbk68]

Hey Craig, thanks again for assistance. I have not tried that. Can you please explain were to place that keyword?

…

On Sun, Aug 25, 2024, 2:32 AM Craig Winnall ***@***.***> wrote: Hi Jon When you use _dr in the URL you should see where the number of rows is. It's something like rows_per_page =1000 Have you tried changing that to a higher number to see if it is possible. Craig — Reply to this email directly, view it on GitHub <#344 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BAZFANE3JI2M2NFIJ42YCRLZTGCCTAVCNFSM6AAAAABNB4J6J6VHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTANBUGE2TCNY> . You are receiving this because you were mentioned.Message ID: <cortexrd/Knack-Toolkit-Library/repo-discussions/344/comments/10441517@ github.com>

[cortexrd]

Hi guys,

I tried several things, including deep exploration of Knack's code and real-time value changes to see if I could get a higher count of displayed records, but that seems to be limited internally at the server-side, no matter what you do.

As Craig pointed out, the only way to do this is to automate sequential multi-page fetches. I would concatenate them in memory, then do the export. I was planning to do this, but since Knack said they already have this on the development timetable, I decided to concentrate on other things.

Norm

[CSWinnall]

Hi Jon You can place _dr=1000 In the description of the view. I've just seen Norms reply so it's not going to work. Another option would be to use make.com when you click the button it will send a webhook to make then you could do sequential searches for records then import them to a spreadsheet but this would be operation intensive.

…

On Sun, 25 Aug 2024, 13:47 jbk68, ***@***.***> wrote: Hey Craig, thanks again for assistance. I have not tried that. Can you please explain were to place that keyword? On Sun, Aug 25, 2024, 2:32 AM Craig Winnall ***@***.***> wrote: > Hi Jon > > When you use _dr in the URL you should see where the number of rows is. > It's something like > > rows_per_page =1000 > > Have you tried changing that to a higher number to see if it is possible. > > Craig > > — > Reply to this email directly, view it on GitHub > < #344 (reply in thread)>, > or unsubscribe > < https://github.com/notifications/unsubscribe-auth/BAZFANE3JI2M2NFIJ42YCRLZTGCCTAVCNFSM6AAAAABNB4J6J6VHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTANBUGE2TCNY> > . > You are receiving this because you were mentioned.Message ID: > <cortexrd/Knack-Toolkit-Library/repo-discussions/344/comments/10441517@ > github.com> > — Reply to this email directly, view it on GitHub <#344 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACQQXA5SB37D4NLZKIRSHHLZTHG73AVCNFSM6AAAAABNB4J6J6VHI2DSMVQWIX3LMV43URDJONRXK43TNFXW4Q3PNVWWK3TUHMYTANBUGI3TMOI> . You are receiving this because you commented.Message ID: <cortexrd/Knack-Toolkit-Library/repo-discussions/344/comments/10442769@ github.com>