How do you display total amount googleSheet using gviz?

[World_of_Games]

How to get same DATE and SHOP values of SUM by using gviz then post to Google sheet TOTAL.

[TIMAI2]

You have a choice....either:

• place an arrayFormula in H1 that calculates the sum for you
• place a formula in each cell in column H that calculates the formala
• calculate the total in your app, and upload it in the same way as you upload all the other data

[World_of_Games]

TIMAI2
How can I get G values if A date=23/05 and B shop=AMENO by using gviz.
I tried to use SELECT G WHERE B CONTAINS 'AMENO'
result coming

"900"
"4950"
"1440"

but result should be

"4950"
"1440"

because "900" is for date 22/05

how to do ?

[TIMAI2]

How are you setting the date ?

[World_of_Games]

[TIMAI2]

Your SELECT should be:

SELECT C WHERE A >= date '2022-05-23' AND B = 'Ameno'

Doesn't seem to like just = on my system

[TIMAI2]

This is better:

SELECT C WHERE B = 'Ameno' AND A > date '2022-05-22' AND A < date '2022-05-24'

[World_of_Games]

yes it's working thank you very much TIMAI2.
Now I need

[World_of_Games]

How display with current date i mean todays date now() and with value Ameno?

[World_of_Games]

@TIMAI2

[World_of_Games]

Also I'm trying this but still not working

[TIMAI2]

You need to use the date format I have shown if using gviz

[World_of_Games]

Like this still missing something ;(

[TIMAI2]

You are not listening.....

@TIMAI2

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

[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"