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
when screen initialize call get data

1
When screen will call get data get cell will be called
1
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
Need help with Airtable
#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