pls remove this text and few more details to ocnfirm for seamless result (98% got result with new logic)
@Alisson_Silva test tis aia
Updated at 2023-01-06T17:52:00Z
Test this V2 (In two methods data is sorted , I hope the screen2 method only you are expecting)
Gsheet_Track_V2.aia (45.3 KB)
Very cool
thank you very much for your help friend, this community is one of the best I’ve ever seen… thank you for the work of the university…
If I need more help can I count on you?
Thank you very much.
sure… Make sure your expectation based on this topic was solves or not, dont forget to mark it to help others in future
my friend
at some point it’s crashing after choosing in the spinner
I’m reviewing…
it still didn’t work.
friend
my worksheet has been changed
I made changes and unfortunately it is stuck
keeps looking but no answer.
Friend
when I include many indeses it is stuck, it cannot solve the problem. always looking…
I can only put 33 lines but it doesn’t perform the function
The reason is, you have not designed what you are looking… if you look deep into my aia there it will look perfectly the selected vehicle value
Test my aia, after picking a spinner checking the web url…
Else share your aia
BTW, it won’t crash even if you try any number of times
Friend
I’m on the same sheet
I made more lines for processes
the more inclusions after 33 to not run
Follow spreadsheet
as you sheet contain different format of texts it doesnot group the data properly. You said it is vehicle number but you use numbers alone… gviz will focus either alpha or num. It will not read or query both the items
So I expressed myself badly,
in this case could it only be in letters and numbers?
In the future they will change everything to the fleet number, so I’m already thinking about it.
you cannot group the items which contains both alpha number and number alone using gviz
In this case, it could not be just numbers (fleets)
search only for equal numbers?
may be you can try with airtable and i am not sure with your query
may be some one who expert in query will help you and me also will learn. Let we wait for @Taifun or @TimAi2 to respond your query…
friend
Good afternoon
could you help me in this other situation?
I’ll post it myself.
Uploading: Captura de tela 2023-01-13 151713.png…
This block is experiencing an error…
can you help me?
Nope…
Even no one can help you
See the attached image
friend in this command line that you gave me,
how should I put to pull one more column to show names related to column C?
Select C, count(C) group by C
Select C, sum(F), sum(G), count(C) where C=’
'group by C
this sheet is not accessbile… we need some screenshot of your sheet
or test this
Select C, sum(F), sum(G), Count(C) where C=‘JPG-5052A’ group by C