How to count the number of entries?

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

I have list of entries in googlesheet.
When user completes his marking he will check his entries for the confirmation. So i used the method suggested by @Taifun.
Everything works as i expected.

If user checks his entries, how can i count the number of entries obtained from the googlesheet??

See the attched images

1. Googlesheet list of entries
   

   

2. Obtained result after the user request in another screen
   

   

[dora_paz (Dora)]

The result is in the form of list of lists , so the lenght of list above is 11. If you wish to count IN for example for each item in list select index item in index 4 cause IN is in position 4

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

Suppose if we use Name(in the place of IN) mean we can get total number na

[iamwsumit (Sumit Kumar)]

Absolutely

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

getting error

[electrobot_appy (HIFI APPS)]

Issue is u don’t got any response from web viewer

[electrobot_appy (HIFI APPS)]

Or ur response is not in list format

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

this is mobile response. I am getting entries

[electrobot_appy (HIFI APPS)]

I got it I will reply soon

[dora_paz (Dora)]

Try using list from csv table block when you got text from web

[electrobot_appy (HIFI APPS)]

I think the issue is u got a JSON array so in components there is a component named JSON so use it replace length of list get response with length of JSON array and so on
Replace select list index with

https://docs.kodular.io/components/utilities/json/#get-jsonobject-from-jsonarray
And so on

[electrobot_appy (HIFI APPS)]

I think even it will work for this

[dora_paz (Dora)]

I used the following url , got it from your previous post

https://docs.google.com/spreadsheets/u/1/d/10ZXG9P0s4mYQhJn4KbVJy3I5RNEYP7q3HWn85caBwYs/gviz/tq?tqx=out:csv&sheet=Sheet1&tq=SELECT+A,B,C,D+where+C+matches+'Mr+E+Jai+sankar'

[Raja_HarshVardhanSolanki]

Use this block in Web.GotText.

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

In all formats it says the argument is not a list…

[Raja_HarshVardhanSolanki]

Use for each number block in Web component’s GotText Block, And Save Response in global Variable with list csv list block in lists as @dora_paz said In Post 10.

[dora_paz (Dora)]

Try the following aia. When button pressed first label gets web response (no list), second label gets list from csv table - (list of lists) - third label shows entries . Just write the name you want in textbox and press button to test it

spreadsheet_1.aia (3.7 KB)

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

Super, I missed to add create empty list in the variable. We are getting the count, If i click again the count become doubles. Other thing it is pakka

[dora_paz (Dora)]

Just add the following blocks and it will not add entries again

spreadsheet_2.aia (3.8 KB)

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

@dora_paz , Thankas a lot… Finally fulfilled my desire with your full and full effort. Thanks a lot once again. Keep in touch with us…