How do you display total amount googleSheet using gviz?

[World_of_Games]

@TIMAI2

A > date '2022-05-22' AND A < date '2022-05-24'

@TIMAI2 sorry Boss you was rigth I was confused.
Boss I decided to use SELECT G WHERE A CONTAINS '22/05'
result showing exect date and also no need use =< >=

[World_of_Games]

Result:

NOW i woluld like to display total Sum (1440+1800)

Here I tried but missing something?

[TIMAI2]

I have broken it down for you so you can see what is going on:

[World_of_Games]

BOSS i did as you explained it's working thank you very much!

and last step
I need to put it on google sheet

[TIMAI2]

@World_of_Games

I need to put it on google sheet

I believe you already know how to do this? Use the update function in your google apps script.

[World_of_Games]

TIMAI2 Thank you very much for your help!
Here is my result with your help

IF date and Shop name existing

IF TextBox empty

**> I've one question: HOW TO MAKE IF date and shop name is not matching **
> then I would like to dipslay "Sorry no data exists for this Shopname"

[Still_Learning]

You have to use the logic when web got result. Just see the response if value found or not found. Calculate the length of the list. And use your logic

If no result found mean see what your app returned. Either empty list or not. If it is empty list mean imagine no result. So you feel now simple to design

[World_of_Games]

Spicy_Topics you mean like this: Still missing something;(

[TIMAI2]

You won't know if you have any matches until the the result of the query is returned from the sheet. Therefore, as Spicy Topics says, you can only do the test (matches/no matches) in the Web.Gottext event once you have the result.

[World_of_Games]

Here is my GSheet

[TIMAI2]

Well, this won't work will it? You will have two values (in a list) and you are checking against one value.

Think it through, try the is in list block ?

[World_of_Games]

[TIMAI2]

and does this work?

It would be really helpful if you used Do it and showed the values of your variables, lists and responseContent....

[World_of_Games]

Not working! Still missing ;(

[TIMAI2]

I don't believe you learnt the lesson from previous posts. Your query will return a list of lists - [["a"],["b"]] therefore you need to test what is inside the list of a list.

[World_of_Games]

Here I tried from begining to display
and this is the result.

[World_of_Games]

I would like to know when I'm typing NOT matching from LIst
I'm seeing sign, what is this sign? and how I can change this sign to empty string.

HERE I made each separate:

[World_of_Games]

After thinking carefully I made match or not , please could you please check

RESULT

[TIMAI2]

The [ ] indicates an empty list.

You can test for any empty list with the is list empty block then do what you need to do

[World_of_Games]

Thank you very much @TIMAI2
YEs, you was right
it's woking also when I use is list empty
here is my result: