And also the tutorial given here (to bypass the Airtable 100 record limit): Airtable Pagination
But I am still not able to work it out somehow. I am trying to use the pageSize parameter, but I am not able to make the Next Page button work out. I am also ordering the list using sort option with an Airtable autonumbering field, to ensure the list shows up logically. Ideally, there would be a Next Button and a Previous Button with respective functionalities.
Any help in this regard would be a huge help.
Thanks a lot, once again, in advance.
P.S. - Any resources that can help a UI/UX designer (something like a dummies guide) to learn these elements will also be super helpful!
Thank you for the kind reply. If it will help, I can create a sample airtable database and add you as creator so that you can use that. I don’t wish to impose though. But will be a big help if you were able to check that.
Thanks a lot for helping out, friend. You are truly amazing. I was able to make it work, but had a couple of quirks:
The list wouldn’t automatically populate in the beginning. I changed the input (in my app, I called it searchnumber) default value to 1, and then it started working (in the video example, it seems the default value is blank). Is there any way this can be done automatically? For example, if I want to retrieve and display the data in a descending order, then I will have to start with the highest number in the ID2 field (I called it group field). But that will constantly change as more data is added into the table on the go, after the app is published.
The number of maximum pages it can go to is fixed in the change input value field. If I put 10 there (4 in your example), then it can only go up to 10 pages. But if I add more content (pages) in the table, then it will not reflect in the app (once I publish it), unless I constantly change that action field and push updates to the app store. Is there anyway it can be dynamic, changing depending on the number of records in the table?
I have made the app and data cloneable, so that you can check the settings:
Managed to figure out how to set the form fields dynamically (collection name–>field name–>Minimum) and then create another text form field to retrieve the maximum number in that field, and then the Next button action can be set to retrieve that text form field data to reset the page to 1. Hope this additional info helps anyone else looking to implement the same (and hope I was able to explain it properly).
Yeah you don’t need a change input value action and you can add the default value as 1 in that input or Images>fields>ID2>Minimum as the default value in the input.
I think you have found it!
One thing to add here. When you add Images>fields>ID2>Maximum to another input’s default value and add that input for conditional action instead of 4 then when you come to 3 you can’t see the last 4 images because condition works and changing the input again. For that you can add a custom formula to that added input and add the Images>fields>ID2>Maximum + 1. Then if the maximum id is 3 then the input becomes 4 and you can see the last images. And once you see the last images and clicked the next button then again to first images 4.
Anyway great find Bles! Didn’t thought about this Thanks!
Thanks!