[Custom]How to load data one by one on user scroll from Airtable, Firebase, Mysql

Hi gyz i present you my another powerful app for custom data loading on user scroll(concept of RecyclerView) from Airtable, Firebase and mysql under jugard series project 6

Note

  1. i did not focus on code optimization so that everyone can understand it easily
  2. I’ll keep on updating the guide for more convenience and try to make it easily understandable

methods and extensions used

I used
Mysql snippet and php file by @Taifun
Dynamic components extension by @yusufcihan
Vertical Scroll handler extension by @ColinTree
Async image loading extension by @DevYB

Explanantion

Offline List

the whole concept of ofline list is very simple and i already have written a complete guide on this topic u can read it from the following link

Load items on user scroll

Load Data from Firebase

Details

                  *Call all the tags
                  *save it in a variable
                  *then run a for loop with limit of your required data i.e 5
                  * when got value then create the list fior 5 items
                  *When reach bottom then
                  *now set limit again to 5 but starting point of loop should be 5+1=6
                  *Repeat the process

Blocks

blocks (34)
blocks (35)
blocks (37)



blocks (30)
blocks (41)
blocks (42)
blocks (44)
blocks (43)

MySQL

Details

                 *Run a query to get number of rows
                 *Run A queru with a Limit say starts from 0 and get data for 5 rows (SQL allows 
                     us to get data with a specific limit)
                  *save it in a variable
                  *then run a for loop with limit of your required data i.e 5
                  * when got value then create the list for 5 items
                  *When reach bottom then
                  *now set limit again  starts frm 5 and again get data for 5 rows
                    (see sql Limit queries)
                  *Repeat the process

Blocks

blocks (46)
blocks (47)
blocks (48)
blocks (49)
blocks (50)
blocks (51)
blocks (52)
blocks (53)
blocks (30)
blocks (41)
blocks (56)



blocks (59)

blocks (61)


blocks (14)

Airtable

Details
in airtable u cannot directly found the number of total records
there are two ways
*LookUp Method
*Use a cell for saving total record numbers
LookUp method is official method suggested by airtable but it requires some calculations that will confuse users , so here we will discuss only use cell method
but if you want to impliment lookup method then u can check it here How to use look up method

Cell method
this is a jugard method …
create another table within the same base that contain only one coulmn and one row mean there should be only one cell
now when u create your first table for the first time then also add total number of records in second table’s cell
for example if your main table has 25 rows then put 25 in second table’s cell manually
now when u made any post after that from admin app or if a user posts then when the post is updated in ,main table then run a query to get value of cell from second table for example
if the vaule in second table’s cell is 25 then update it by adding 1 to 25 mean 25+1=26 in app and then update the value to 26 second table’s cell and repeat it every time a user posts by using increment logic in your app

Note u can also do it without creating a seperate table and for example
if in your main table u 5 columns add a 6th column and set value of total records in its first cell
but it is also confusing for some users so simply create a new table…as i mentioned above
or either use lookup method

now instructions for getting data

                  *get cell value from second table
                  *save it in a variable
                  *then run a for loop with limit of your required data i.e 5 and get 5 rows from fist 
                    table
                  * when got value then create the list for 5 items then
                  *When reach bottom then
                  *now set now call next 5 rows 
                  *Repeat the process

Blocks

blocks (65)
blocks (44)
blocks (67)
blocks (68)
blocks (43)
blocks (30)
blocks (41)
blocks (76)


blocks (77)

advantages

With this u can load data in parts mean if you want load items 4 by 4… 5 by 5 even any custom form can be obtained
Now u can develop apps with loading data systems very similar to facebook, YouTube etc

beta Tester

This aia is tested by our senior koder @Rogerio_Rios and @Alapjeet

demo video

U can watch live video here
Its realy a customizable data loading u can load data from database one by one or in any custom forms
note
I made it highly user friendly and even newbies can understand logics very easily
Because i didn’t focus on code optimization i tried my best to made it more understandable

Downloads

CustonLoading.apk
CustonLoading (3).aia (364.2 KB)

Credits

Thanks to @kodular for such a great platform
thanks to @yusufcihan @DevYB and @ColinTree for their extensions
Thanks to @Taifun for his mysql tutorial
Thanks to @Rogerio_Rios for his help during the project
Thanks to @msr79526 for giving me idea for this project

Feel Free to ask queries and your questions

69 Likes
My app take too much time to read data from Airtable
App lag issue when using 500+ records in airtable
Deleting and recreating dynamic card using dynamic component Extension
Airtable - How to obtain the number of elements at a column?
How to use clock to load items in a listview/custom listview?
How to load more fierbase data
Which server database is faster?
Get Values from airtable and Firebase data base on user scroll
Dynamic Cardview: App Crashing
Need help for recyclerlist data from mySQL
[F/OS] - Dynamic Components Extension (for every component) 2.3.0
Dynamic components loads image slowly
Animation / Loading bar freezes during page loading
Editable listview, possible? Alternative?
How to show one after another dynamically from the list in the carview once the button is clicked?
How to Load Huge Amount Of Data widout lag/hang/stuck
Recycler view component
Can anyone help me to add scroll to load more method in this aia?
Google spreadsheet Recycler View
Load Items when User Scroll [Advance & Unique]
Help with social media app
Dynamic components slow loading
Dynamic component help
Load Items when User Scroll [Advance & Unique]
How to use recycler view on loading images datas in dynamic card view?
How to load data from airtable with recyclerview without using deep host's extension?
Dynamic layout with airtable (or any database)
Recyclerview with dynamic card view
How can i load big data(12600rows) from csv file using kodular dynamic without lag or freeze
How to Create 3 Column Dynamic GridView without Extension
Load data one by one
How To Load Dynamic Schema 1 By 1
Determine the end of the Vertical Scroll Arrangement?
Which server database is faster?
Which server database is faster?

Great Initiative!

2 Likes

Cool… Something really cooll…
Please Give Tutorial about it…

2 Likes

Thanku so much for your help during the project

2 Likes

Respect :smiling_face_with_three_hearts:

5 Likes

you mean the total, right?

3 Likes

Thanku for this appreciation
M also thankful for your help during project’s firebase database part

I’ll post the guide as soon as possible :heart:

1 Like

Yes in total :blush::blush:

4 Likes

Thanku so much :heart:

2 Likes

I really liked.

2 Likes

@ashishthakoor58 Thanku so much :heart:

Amazing Intro :star_struck: :star_struck: :heart_eyes: :heart_eyes:

Waiting for your guide :smiley: :smiley:

Specially in firebasefirebase firebase

1 Like

Is it call data like first 10 then when scroll down call more 10. Or call all data ?

1 Like

@Yash_Agarwal_376 yes it is doing this
U can even call data 5 by 5 even 15 by 15
Mean u can get data according to you own wish :heart::heart:
It will be a great experience for community :blush:

1 Like

Oh yes we are waiting for your guide

1 Like

@Yash_Agarwal_376 thannk you so much for your appreciation
And i’ll try to post guide as soon as possible :heart:

no you are not doing that…
i’ll suggest you must check your aia as you said thta its powerful but its not…
and as you said your method is cannot be replaced but it is…

i would like to request you to let me introduce my guide on the same topic as its much powerful,efficient and much goot than yours…

1 Like

Yes i am waiting for your guide also
No matter who contributed just contribute

3 Likes

no i can’t as this idea firstly came in zia’s mind but may be after that

1 Like

Hmm m doing what @Yash_Agarwal_376 asking
And why r u spoiling

@Rogerio_Rios @Alapjeet
Please if u have some time then please confirm here that m doing the vety same thing that i am explaining in my video and post

Hmm let’s see
As far as i know until the intro to my aia u had no idea about this