On clicking the clamp, do you want to get these two rows info?
Hi spicy,
I mean when clicking on an spinnner, chosing the option, I want to get the info with the same word chossen in the colum B from the spreadsheet
for example chose OPERACIONES and only see the rows in the colum B that contain the word OPERACIONES
have you tried this in gviz function tq= SELECT A,C WHERE B='SPINNER SELECTION'
ok , and those the rows could be shown on a list view ?
you will get the result as list items
Here i run to take A,B,C where B=1001. So it returns three ROWS.. Each row will be counted as a list. So here i am getting three list.. And each list contain further three items..
great, just what I need, now let me work on it and I will go back to say how does it works
great! I am going to work on It, I apreciate your help
1 Like
But keep in mind, since your fikterimg the col based on text you must add ' in front of the word also at the end of the word by using join block. Here i filtered wiyh number so no such things are needed
Select A, C where B='selection'
Hi,
actually I try the code and It works but not yet like it should,
let me show you the bloks
the colums 3 & 4 are the one that needs to be shown in the list view
how with the selection OPERACIONES in colums 2 we could only see just the rows that contain this world,
do you know the way how to do it with blocks?
Please I will really apreciate your help
I guess is something like this
but actually I do not works yet
Check your combined Web1.Url, there are some errors ....
https://docs.google.com/spreadsheets/d/<SpreadsheetID/
gviz/tq?tqx=out:csv&sheet=<sheetName>
&range=<A1 notation range reference>&tq=SELECT....
Ok, I check It and I get back
Ok. so is there ike this?
you know how can we handle the where cointains and the selection do the spinner
just to make the filter
Hi,
I even try with the adress https://docs.google.com/spreadsheets/d/
but is not still working, what I can see is that it do not read the Where
You forgot to call the Web Get method after defining the URL
And it looks like you are expecting to receive the result magically directly after setting the URL... this is not the case... the web component works asynchronously, which means you receive the result in the Web GotText event...
See also METRIC RAT AI2 - Use gviz to get and query google sheet data
Taifun
Hi @Arturo, I was slept. BTW you have committed three mistakes..
-
In the no. 1 it should be like B= 'get selection' but you've added B=get selection
-
You have not added call web1. Get just below the web url
-
You have added the No2. In image in the same place, but it shoild go in web got text. Pls see the image have added in my previous post
Clearly i have mentioned in the previous post
thanks for the answer
I let me tell you more about the previous codes
web get.text already have info
because the first thing that the app does is read the spread sheet
and Now when I run the code for the gviz query is not working
it shows me this image
and now what It confuse me is that with the read all we can select the items in the list view and update them and this is one of the main funtion of the app
so can you tell me if we need to create a new code for in the web for the query ? or is it posible to make the filter wirth bloks or even with app script ?
I aready make the instructions that you told me
Found your problems, As i guess.,
- to use gviz you need to give sheet atleast viewer permission
- You have used if then else in web got text, but instead of that try to use multiple if then
- In that case when spinner got selection you must set global fun to anyither word and use such condition in web got text
4 else use gviz query in the script editor too
Ok , thanks I will execute this tomorrow, now ia late. I do and I go back