Is it possible to see rows in a lista View using a Gviz query?

MIT App Inventor Help
1

Dear community,

I've been trying ti fin the better way filter some information from an spreadsheet, in order to make easier for the user to see the only necessary information.

The next image can show in a easiest way the process

fliters
fliters664×694 21.6 KB

then in the next image there is and spreadsheet

spread
spread664×694 13.5 KB

As far as the info search and the advises. the better way to do this is with and gviz query i think that select words search in the spinner to see only those colums.

but my question is if I can see the columns in the list view, because always that I can the info taken from a gviz query it is shown in a label.

and then if someone knows a way to make this in a another way for example with block or a filter code in the spread sheet that will really help me

thanks in advance

2

On clicking the clamp, do you want to get these two rows info?

image

3

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

4

have you tried this in gviz function tq= SELECT A,C WHERE B='SPINNER SELECTION'

5

ok , and those the rows could be shown on a list view ?

6

you will get the result as list items

image

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..

7

great, just what I need, now let me work on it and I will go back to say how does it works

8

see how it works in app, we can customonise the result in any direction such way we need

image
image1014×357 36.5 KB

9

great! I am going to work on It, I apreciate your help

1 Like
10

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'

11

Hi,

actually I try the code and It works but not yet like it should,

let me show you the bloks

image

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

12

I guess is something like this

image

but actually I do not works yet

13

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....

14

Ok, I check It and I get back

15

Ok. so is there ike this?

image
image691×472 33.1 KB

you know how can we handle the where cointains and the selection do the spinner

just to make the filter

16

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

image

17

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

18

Hi @Arturo, I was slept. BTW you have committed three mistakes..

  1. In the no. 1 it should be like B= 'get selection' but you've added B=get selection

  2. You have not added call web1. Get just below the web url

  3. 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

Screenshot_2022-09-26-08-07-22-13
Screenshot_2022-09-26-08-07-22-13720×118 22.1 KB

19

@Spicy_Topics

thanks for the answer

I let me tell you more about the previous codes

web get.text already have info

image

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

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

image

20

Found your problems, As i guess.,

  1. to use gviz you need to give sheet atleast viewer permission
  2. You have used if then else in web got text, but instead of that try to use multiple if then
  3. 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