Adalo Pagination with Airtable

Hi,

I have been gradually getting to learn Adalo, and the Adalo community has been truly helpful. Special shoutout to @Flawless and @dilon_perera!

I need some more help, and once again banking on the generosity of the community for help.

I am trying to build a list from an Airtable collection, and I am trying to create multi-page list with each page limited to 10 or 20 records. I tried following the video from @pford about external collections given here: Part 2: Paging Through API Results in Adalo (using Pixabay) - YouTube

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!

I don’t have an Airtable database to play with to show you at the moment. Maybe @dilon_perera can help you here :grin:

1 Like

Hi @Flawless,

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.

Thank you…

Hi Bles,

This is the way that I found! Not sure if this the better way of doing this :slightly_smiling_face:

Thank you

2 Likes

@dilon_perera you’re a class act, my friend.

2 Likes

Hi @dilon_perera,

Thanks a lot for helping out, friend. You are truly amazing. I was able to make it work, but had a couple of quirks:

  1. 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.

  2. 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:

I know I am asking a lot (and I apologize if it is an inconvenience). But I am truly grateful for all the help.

Thanks a lot, once again.

1 Like

Hello @dilon_perera you make awesome videos but they getting lost here. Why not upload them on youtube into a adalo channel ? That would be awesome

2 Likes

I agree with @pushingpandas

Others will have an easier time finding your videos & you’ll get more people to see your content @dilon_perera

2 Likes

Hi @dilon_perera

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).

And I agree with @pushingpandas and @Flawless. You should put this up on YouTube.

Thanks once again a lot for helping and pointing in the right direction.

All the best.

1 Like

Your Welcome!

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 :upside_down_face: Thanks!

1 Like