Table of Contents

Is it possible to display more than 100 records at a time on a table, list, or search view?

Danielle Kellogg Updated by Danielle Kellogg

While there's no built-in option for displaying more than 100 records on a view, there is a workaround for this.

With the workaround, you will link to a page that displays more than 100 records. There isn't a way to make this work without linking to a new page.

1,000 records is the max number of records that can be displayed on a view at a time.

Workaround Setup

Here's how to set up the workaround. We use a table view in this example:

1. Create a table displaying the records you need to show. The number of records displayed doesn't matter.

2. Add a Menu to the page where you want users to access the view with more records.

3. Add a new link to the menu that "Links to a URL."

4. The URL for the original page with the table needs to be tweaked with the higher record count.

For example, let's say that this is the URL for your main Products page: https://odalis-apps.knack.com/test-6#products/

To show 1000 records at a time, you would add the following to the URL:

?view_20_per_page=1000&view_20_page=1

You'll replace the view IDs in red with the view ID for the table displaying the records. And you'll replace the number after "page=" with 1000 to show 1000 records.

Here's the final URL:

https://odalis-apps.knack.com/test-6#products/?view_20_per_page=1000&view_20_page=1

If you're not sure how to find the view ID, click here to find out how.

Now when users click the link on the Menu, they will be directed to a page displaying 1000 records at a time.

How did we do?

How can I change the color of something in my app?

Contact