How do you skip the title row in Google Sheets using the gVizQuery?

[Samhappy]

When I use OFFSET 1 it's still displaying ID title

[TIMAI2]

&headers=0 should do it

[Samhappy]

Thank you so much it's working!

[Samhappy]

I would like to see a message saying 'Password not matching' if the entered number is incorrect. However, when I enter the wrong number, it does not display 'Password not matching.

[ABG]

How do you know response content will be a csv table?

And why would you need a for each loop in the response?

And why do you have no provision for handling web response for different request types (password vs app data)?

What type of user would have more than one row returned?

Why do you use a notifier that lacks an okay button? Who is watching the screen, a hummingbird?

[Samhappy]

I'm using gVizQuery.

[Samhappy]

@Samhappy

when I enter the wrong number, it does not display 'Password not matching.

only issue is that when I type the wrong only numbers, it does not display 'Password not matching. If i use number with letter is working.

[Samhappy]

@TIMAI2 please help me with this issue

[Samhappy]

I guess issue with string I guess number need to convert into string but I dont know how to convert.
issue close to these places

[TIMAI2]

Show your response content for a successful and unsuccessful "password"

[Taifun]

What about simplifying your query and get only B from the spreadsheet?

Select B where A = Login_tb.Text

Taifun

[Samhappy]

[Samhappy]

I tried not working! I would like to match only A columb

[Taifun]

@TIMAI2

Show your response content

How to show raw responseContent from your app when debugging

Many developers often get stuck when trying to handle the response content from an online server after making a GET request using the web component. Those trying to help often ask to see the raw responseContent being returned. When using companion this can be copied and pasted to the community for those trying to help to use with debugging. This is how you might return that information / data to a label. BLOCKS [image] DATA Do It Result: ""Name","Date of Birth","Age" "Adah","06/04/1999","2…

Taifun

[Taifun]

@Samhappy

not working

Well, obviously you have to adjust your blocks in the GotText event then

Learn to debug your project!

Use the companion app and Do it to debug your blocks, see also tip 4 here App Inventor: How to Learn | Pura Vida Apps
see also Live Development, Testing, and Debugging Tools

FAQ Section: Debugging

Introductory Testing techniques, including Do It - MIT Sample Connect -> Companion sequence - @ABG How to Read and Understand a Runtime Error Message - @ABG Common Runtime Errors - @TimAI2 Advanced Do It' to view procedure results, event arguments and local variables How to run Logcat How to use Do It in a loop Screen1.ErrorOccured message numbers SteveJG monster list of things you should not do How to show raw responseContent from your app when debugging - TimAI2 Video of copying Do…

Taifun

---

Trying to push the limits! Snippets, Tutorials and Extensions from Pura Vida Apps by Taifun.

[TIMAI2]

You need to do this:

If the "password" entered is not in the spreadsheet, then nothing is returned, if the password entered is in the spreadsheet then a list of lists is returned once you convert to a list from csv table. you therefore have to select item twice in order to get to the value of A returned

[Samhappy]

Now it's working BUT when I enter wrong Number with letter it's not showing message

[Taifun]

Set the NumbersOnly property of the textbox to true
Taifun

[Samhappy]

no maybe in future it'll be number with letter. What will I do in that case. So it's better to bas as it's. I need solution!

[Taifun]

You have to change your query to alphanumeric and use quotes

... where A = 'some text'

Taifun