Gviz query how do you get numbers and letters bouth from a colum in a list view?

[Arturo]

Hi dear commuty,

I have an issue and I don't know how to fix it. I use giviz to get some values from an spreadsheet, in the next image I will show the values.

The issue is:

In the colum H, we have numbers and letters. ex. 98, 5200, no corre & ill

then when I take the values in a list view, let me show you the list view.

how can we have all the values of colum H. because we can only see the numbers but not the letters, in the last row we see PushPull, 9, Marca código and , ....... but we can't see tarimas because are letters

I will show the blocks used to extract the information

By chance somebody knws how to fix it to see all the values numbers and letters ?

thanks in advance

[Juan_Antonio]

What do you get in Web.GotText - responseContent?

Have you checked this @TIMAI2 tutorial?

METRIC RAT AI2 - Use gviz to get and query google sheet data

[Arturo]

@Juan_Antonio Hi, yes did.

this is the web got.text

[Juan_Antonio]

Put a Label on Web.GotText and see what you get.

[Arturo]

The same Issue, we can not see thé letters

with push pull it does not appear the world tarimas

[TIMAI2]

You do not show your query....

[Arturo]

sorry, I'll show the URL and the query

https://docs.google.com/spreadsheets/d/1Cu77ER5zL6tieN6jQSpQAP0wtF8PNXvdCe6xmq_rZXc/gviz/tq?tqx=out:csv&tq=SELECT E, F, G, H, I WHERE A = 'Reportado'

you know even when we test this in the browser show this

column D only we can see the numbers

[TIMAI2]

@Arturo

https://docs.google.com/spreadsheets/d/1Cu77ER5zL6tieN6jQSpQAP0wtF8PNXvdCe6xmq_rZXc/gviz/tq?tqx=out:csv&tq=SELECT E, F, G, H, I WHERE A =

It seems to work OK for numbers and text in column F. What is different about column H ?

[Arturo]

I am trying to see, but I have not realise

for colum F manualy I chage the format

as text wiout format

but is there a way to do that automatizally for all the row?

[TIMAI2]

Google Sheets will tend to set the format of a cell based upon the content which a puts applies.

You run an apps script to set the format after an entry is made...

Alternatively, you could enter all the numbers as text, by placing an apostrophe before the number:

'1234

[Arturo]

TIM,

Is like this the code that I need to introduce in apps script ?

if (Funcion == 'ENVIAR' ) {
var registro = e.parameter.REGISTRO.split(',');
sh.appendRow(registro);
sh.getDataRange().setNumberFormat(String numberFormat)
return ContentService.createTextOutput("New record created");

[TIMAI2]

See here

Set cell format with google apps script

I suggest, if you cannot set just the cell, then to set the column.

[Arturo]

thanks

so like this?

if (Funcion == 'ENVIAR' ) {
var registro = e.parameter.REGISTRO.split(',');
sh.appendRow(registro);
var column = sheet.getRange("H2:H");
column.setNumberFormat("@");
return ContentService.createTextOutput("New record created");
}

[TIMAI2]

Try it, see what happens...

[Arturo]

ok, I'll do, and then I go back

no, I did and I do not works

looks that the code is not running

[TIMAI2]

sh.getRange("H2:H") (not sheet.)

[Arturo]

thanks TIM, I really apreciate your help, now it works