How to make a league table which shows standings

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

No, I mean I have to get and set many different columns’ data.

To get use get column and set the name as you want…
To set…Use set cell or any other set methods…

Well, I don’t know much about how spreadsheet set methods work. Btw, this guy mentioned what I want to do:

You can do it…Just add the get cell block in for each item loop…And set the list of items to the name of cells you want…
Some thing like this:
blocks - 2020-08-15T224451.292

Thanks for it, I did it. But it just makes easier to get columns. I’m asking how can I set labels by different columns’ data. I mean I have to get data from “Takım” column and set six labels with its data. Get data from “Oynanan” column and set another six labels with its data. I need to learn the set method, as you said.

I finally found a way:

Thank y’all for your replies!