How to get the requested/duplicate entries from the googlesheet?

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

Friends, i am having such data in my google sheet.

If i search using name how can i get number of entries datewise in our app or IN/OUT category wise…

I know how to get data from sheet to app but it gives only one row

[TimAi2 (metricrat)]

Try this method:

🟩 Use gviz to get and query google sheet data

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

I followeded the steps given in METRIC RAT AI2 - Use gviz to get and query google sheet data

but i am getting result like this…

I want to extract particular data but it extracts all the datas

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

I am calling A,B and C value if the sheet contains Particular name but it shows all the name…

Am i did any mistake?

[TimAi2 (metricrat)]

In your select query try:

SELECT A,B,C where C contains 'name'

[Taifun]

@Still-learning

Am i did any mistake?

the documentation is here Query Language Reference (Version 0.7)  |  Charts  |  Google Developers
a correct select statement also would be

select A,B,C where C matches 'namelabel.Text'

don’t forget the single quotes around the textbox…

Taifun

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

Thanks @Taifun , If i use the url(

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+'Ms+R+Revathi'

) link in the browser it downloads exactly what i am looking but in app again it shows full list. Even i tried in another angel. I dont know what is the mistake i am doing. Morning only need to check up…

![Screenshot_10|633x406, 75%]

I have used separate text box even for the query (as you did the webpage)

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

I slightly modified the blocks and now i am getting properly…

Thank you @Taifun

Every thing working fine now…
First time entry by the user alone auto deletes. 2nd time onwards their entries correctly updating in the sheet…

Screenshot was old one, that was testing only. Actually i set the response content to open in the next screen…

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

@Taifun , Suppose if i adjust the query to search the name matching with date , then results turned empty. I dont know why. I used the same blocks but instead of namelabel.text i used datelabel.text field.

Is it not possible to search the field based on date? And i display the date in the label by using web component

web site address :

http://worldtimeapi.org/api/ip

and the blocks are ,

Query link look like this,
https://docs.google.com/spreadsheets/u/1/d/10ZXG9P0s4mYQhJn4KbVJy3I5RNEYP7q3HWn85caBwYs/gviz/tq?tqx=out:csv&sheet=Sheet1&tq=SELECT%20B%2CC%2CD%20where%20A%20matches%2006-02-2021

I have used both type of text as shown in below picture

but for both the type of date i got the following error

UBDATES:
I followed this tutorial too for how to use date query in google sheet,
https://infoinspired.com/google-docs/spreadsheet/how-to-use-date-criteria-in-query-function-in-google-sheets/

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

Worked out and found result,

select A,C,D where A=date 'datelabel.text'

The problem is only space