Make SUM all value from Goggle sheet in label

[Ramadani]

I’m sorry if this question has been discussed before, I’ve followed various tutorials in the community, but still haven’t found a way out, can anyone help me?, or provide tutorial references?, thanks before

i want to sum all value

[Anil_M (Codal Inc.)]

Remove 0 & Replace Empty List

[Ramadani]

[Anil_M (Codal Inc.)]

Remove + add items to list components use

[Ramadani]

can you show me please?

[Still-learning (1-2-3-4...)]

You blocks are seems to be not from kodular and it is violating the rules for kodular. So use kodular blocks or ask the question in that community else this topic will be delisted

Also show us gsheet data

[sugarlesscreator]

under certain conditions, your block is correct.

This is an example of retrieving data from google spreadsheet.

Table

Use qwery to select data from column D

https://docs.google.com/spreadsheets/d/1MvMpTePRD0PP-e9J2qyPiFydzM0HM6wG1j3Cgy2TmZg/gviz/tq?tqx=out:csv&tq=SELECT D

[Still-learning (1-2-3-4...)]

Infact the user can try this formula too… In the place of html pls try with csv while using as web url in kodular…

https://docs.google.com/spreadsheets/u/0/d/1MvMpTePRD0PP-e9J2qyPiFydzM0HM6wG1j3Cgy2TmZg/gviz/tq?tqx=out:html&tq=select%20sum(B)%20where%20B%3E0

you can replace the col names

https://docs.google.com/spreadsheets/u/0/d/1MvMpTePRD0PP-e9J2qyPiFydzM0HM6wG1j3Cgy2TmZg/gviz/tq?tqx=out:html&tq=select sum(D) where D>0

And in blocks part just use remove item index 1

[sugarlesscreator]

no problem, it’s just an example

it’s the same if we export it to csv…

https://docs.google.com/spreadsheets/d/1MvMpTePRD0PP-e9J2qyPiFydzM0HM6wG1j3Cgy2TmZg/export?format=csv

And block web get text
Change index 1 to 4 on add item to list x
Bcoz column D is in index 4

[Ramadani]

I apologize in advance if this is outside of kodular, but I believe members of the kodular community are the most trustworthy.

[Ramadani]

thank you my friend, this is perfect, thank you very much

[Ramadani]

Thank you my friend