How to make a league table which shows standings

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

Just set the text to get value to set the text to all of the values…If you want to set takim1 to the first value of the list…Just set to select list item…List = value…index=1

1 Like

Can you please show it with blocks?

That will set label one to the first value from takim colmun:
blocks - 2020-08-15T180650.249

2 Likes

Thank you :blush: So I have to use this block with it, right?

What’s max record used for?

1 Like

Max Record is Maximum Number of Data To Be Called From That Specified Column.
For Example - 100, 200, 300 or any.

1 Like

Thank you @ADDYLIN :blush:

1 Like

Done! :blush:


But as you know, I have to get more columns. So I guess have to use another block instead of “get value”.Which block should it be? I mean this:


What do you mean…You just need to increase the max record