Read data from Google sheets

[thinh]

I followed you but can't look up the data, please help

[TIMAI2]

• Are you certain your sheet is called sheet1 and not Sheet1 (uppercase S) ?
• You don't show a query you have tested with
• Is your script correctly deployed ?

[TIMAI2]

Also see:

• Use gviz to get and query google sheet data

• Use gviz to get or query PRIVATE google sheet data

[thinh]

I tried but still can't run

[thinh]

Please check the code for me, and sheet and Sheet (in uppercase and lowercase) I have corrected but still not working

[thinh]

Please check the code for me, and sheet and Sheet (in uppercase and lowercase) I have corrected but still not working

[TIMAI2]

It appears that your sheet is called Sheet but you are sending sheet1 in the blocks

[nishyanthkumar]

Try Sheet, with a capital "S."

[thinh]

I make google sheet data query, i tried my best. however, it still does not work. Can anyone help me see if there is an error, the code, or do I need to install any additional google sheets add-ons?

[TIMAI2]

What query are you trying ?

Are you sure you have your google apps script published and your script url in your app is the same?

[thinh]

I've fixed it many times, but still can't get the query. #ERROR announcement!
https://script.google.com/macros/s/AKfycbzAXLlAO0XBsq1Ms98hES9wuTO03i72yXJC-mMEFbZGdq_TwQ/exec
17KQxRL-HALgY9etgTqa_mo4jXDYu_dlxTMka8d3w2ec

[thinh]

i don't know where it went wrong this is my google sheet

Querysheet

[TIMAI2]

There is a problem with your google apps script web app. It could be an issue with your locale. Try changing this line in your script:

 var qry = '=query(' + rg + ';\"' + sql + '\";1)';

you will see I have replaced the , (commas) with ; (semi-colons).
Remember to deploy your script to a new version

If you run this in your computer browser you will see the data is returned in a table:

https://docs.google.com/spreadsheets/d/17KQxRL-HALgY9etgTqa_mo4jXDYu_dlxTMka8d3w2ec/gviz/tq?tqx=out:html&tq=SELECT%20*

[thinh]

@TIMAI2

https://docs.google.com/spreadsheets/d/17KQxRL-HALgY9etgTqa_mo4jXDYu_dlxTMka8d3w2ec/gviz/tq?tqx=out:html&tq=SELECT%20*

I did it, thank you so much

[thinh]

how can i view it as a table on the phone screen. by column on google sheet

[TIMAI2]

I would use @Ken's Tableview extension, but you can use a webview with a javascript dynamic table, or make a table with labels

[thinh]

i want to represent the data from my query as a table. can you help me.

[TIMAI2]

Here is a tableview example

TableViewExample.aia (19.8 KB)

To get the display correct, ensure you set the Cell delimiter and Row delimiter options in the Tableview designer properties, and also see the checkboxes for Shrink to Fit and Stretch to Fit.

[nishyanthkumar]

Replace the commas in the header with semicolons (";").

[thinh]

how can i display the data in the "Address" box to the size i want, or the data can be newline