Guide : || How To Get Data From Airtable in A sequential Manner ||

Guides Resources
1

Hello Friends, Today i am going to share you a way to get cells from airtable in a ==sequential manner using only one spreadsheet component …==

Actual Issue -

The issue is that if we use " get row " and assign indexes to labels then the cells got are not in sequential order..

Untitled
Untitled1590×524 23.9 KB

From This Image We can understand the issue much more clearly ..

In this image we can clearly see that the Data is in This Format - ABCDE of Column 12345 but airtable is sending Data in This Specific Format Every Time - BEADC of Column 25143

We can see that this is not in sequential order

So how to do that ??

Some will say use " get cell " but if we have 9 -10 cells then using get cell is little complicated as we have to use 9-10 Spreadsheet component

This Can Be Skipped Using My trick

Components Required –

  • Spreadsheet
  • Labels
  • Buttons

In this trick We will Use A global variable which is assigned to 0.

1

and a button to refresh the screen

1
1194×100 2.31 KB

when screen initialize call get data

1
When screen will call get data get cell will be called

1
1308×151 5.38 KB

and when the cell is got this block will run here the count will be increased in order to get all cells one by one without using more than one component (spreadsheet)
545×1665 85.4 KB

hope You all will like this guide and try this method in you projects !

Last Words

As you all know firebase db is slow than airtable so using airtable should not being complicated use my method to get different cells without use of so many components

Links

Aia - airtable(1).aia (4.8 KB)

Apk - Will be uploaded in next 20 minutes

==No extension is used …==

Credits @ADDYLIN

Thank you addylin for image

8 Likes
2

Good work.
:+1:t2:

But ultimately you are also using Get Cell.

And you forgot to Credit Someone.

1 Like
3

I put all the information on my airtable, but still don’t return any value …

1 Like
4

It’s the only way out but I am using only one component and it’s not much complicated

5

It should work I have tested it

6

As I said, no information came back to me.
I created it just for testing.
see if I happen to be doing something wrong in airtable!

https://api.airtable.com/v0/appIcWdoruab68Bvw/infos?api_key=keyPdUeJtoYqVzEIt

1 Like
7

Please share blocks so that I can see and please include a screenshot of your table at airtable for better understanding

8

I practically used your .aia
I just put my breathable data

1 Like
9

oh so please include the airtable screenshot

10

Screenshot_3
Screenshot_3856×259 11.9 KB

I had even mentioned the airtable link up there, I thought I saw it!

1 Like
11

Are you serious that’s an api link..
Show your blocks. Or else no one can help you.

1 Like
12

Great effort and awesome tutorial

No firebase db is far more faster than Airtable
U can try it :wink:

2 Likes
13

@Zia_Choudhary I think the OP mixed them up, or is it? :thinking:

1 Like
14

@WatermelonIce not get your point!!!

1 Like
15

I mean the original poster might mixed up which is database is faster overall.

2 Likes
16

Yes may be that’s why i cleared the point thay firebase db is far more faster than Airtable

2 Likes
17

Thank you :smiling_face_with_three_hearts:

1 Like
18

You are saying that firebase is faster but when I was using firebase in my app it was taking time but when I used airtable it was working very fast as compared to firebase in my case..:wink:

19

Please check that API key and base id is right in kodular and please ensure that you are using same column name in kodular also :wink:

20

:+1:t2: :+1:t2: Nice Work !!

2 Likes