How to make a league table which shows standings

Hi everyone! I need your help again! Especially @Mohamed_Tamer :sweat_smile:

I want to make a league table. I designed the background. But I don’t know how to fill it with data properly. And also, I would like you to tell which API I should use for this job; I need to change data frequently.

Thank you all!

Where is your data stored?

1 Like

Actually, nowhere. Because I have no data to store yet. I tried Firebase Realtime Database but it doesn’t look suitable for this job. I am open to suggestions about where to store data as well :blush:

You can try airtable…

1 Like

You must have a data so you can put in your table :sweat_smile:

1 Like

Good point :sweat_smile:

1 Like

Done :blush:

I’m waiting for the instructions :raising_hand_man:

1 Like

Now you need to sort your table according to any raw?

1 Like

Sorry, I didn’t understand. What did you mean by “raw”?

Sorry i meant colmun in your airtable…Like Oynanan…

Yup! That’s what I want to do!

1 Like

Which raw you want to sort the table according to it…Oynanan?

1 Like

No, according to “Puan” which doesn’t seem in the screenshot. I can’t show it on mobile browser.

1 Like

First do you know how to get your airtable value?
You will need to make a for each item in list block…And set the list items to the names of your rows you want to get…Takim,Oynanan,Galiibiyet,etc…And put inside the for each item loop get colmun…And set the colmun name parameter to item variable you will find in the for each item in list block…
Also, don’t forget to set the table name, base id, etc… properties…You can learn more about that from here:

When you got success in getting columns just tell me here…Else if you got error you can also ask the community here… :slightly_smiling_face:

1 Like

Thank you so much! I’m already working on it :blush:

1 Like

You’re welcome :grin:

1 Like

Do you know how can I align the texts? :sweat_smile:

May be that its not related to this topic :thinking:
Anyway Just change it’s size and text alignment as per as your need…

1 Like

Hi @Mohamed_Tamer! The allignment is done :blush:

1 Like

But I guess the topic doesn’t show how to get data from spreadsheet:

I think this may works for getting data:

blocks

But I’m stuck setting the texts as cells value:

blocks (1)

1 Like