Extracting and filtering data from the list

[Ceit89]

Is the information entered by the user in the list of the data I received through google sheets?

[Taifun]

@Ceit89

Is the information entered by the user in the list of the data I received through google sheets

in the for item in list loop you are comparing the information entered by the user with the complete row
this is probably not what you want... you might want to check only the item from the relevant column

Taifun

[Spicy_Topics]

Your blocks are wrong

[TIMAI2]

Something like this ?

[Ceit89]

can you help me how to do it?

[Ceit89]

What should be the correct codes?

[Ceit89]

I'm trying right away

[Ceit89]

i did it this way but it only gets the last data

[TIMAI2]

Look at my blocks again. You left out the break block.

[ABG]

Here are some table filter routines you can use ...

Build Your Own DB - Part 1

[Ceit89]

thank you, i'm checking it out

[Ceit89]

About the collection of filtered data according to a certain condition

Hello, I am pulling and filtering data with google sheets. I want to sum values in a column that belong to the same date, currently it only gets the data from the last date. Where am I going wrong, can anyone help?

[ABG]

Explain start value?

[Ceit89]

my values are like this, but it only gets the latest score

[Spicy_Topics]

@Ceit89

latest score

1. If you catch the result list in lable then it will print the last value only..

2. from gsheet you are getting all teh details or selectively calling specific col alone?

3. To sum the list value you must use for each item event block in diff way

4. When web got text you set empty list to global veri but in label how it print the alst value? Surprising
   

   

To sum the list of numbers use this procedure

To print the list value try any one of these

[ABG]

If you have the full table, you can pass it through this procedure to do a grouped sum, like in SQL.

Search for same ingredient and add them

This type of problem works better with tables (lists of lists) and a group by sum procedure similar to the SQL SELECT SUM GROUP By construct. This sample app groups and sums expenses, as opposed to grouping and summing ingredients, but the base concept is the same. group_sum.aia (7.6 KB) Here is a raw data Comma Separated Values (CSV) file... [details table structure] [when Screen1 Initialize] [when FileSampleDetails GotText] When the file arrives from the Media folder, it gets scrubbed…

[Nova_Sulistyo]

excuse me, I want to ask, how to filter the list based on specific date, I tried to use 2 methods,

1. using filterbar by listview
2. using the "if then" component in block,

but the result, if I enter the date 1/3/2023, then 11/3/2023 will also be displayed
this is my block :

and my result :

[ABG]

Since you are asking the Spreadsheet component for your data, you can use the block that asks for rows with a filter:

Before you can do this with a date column, be sure you have set it up properly in Google Sheets:

(Highlight column with the dates, Format->Number->Date)

and use the Clock1.FormatDateTime block to build a date string to match the Sheet's formatting from your date choice.

P.S. All I had was a datetime formatted column when I took my screen shots.)