Getting data from Google Sheet based on a certain condition

[aimar]

Hello everyone,

I'm new to this community. I continue to learn App Inventor and give myself tasks after watching the videos. Thanks to the videos I watched on YouTube, I was able to extract data from Google Sheet and transfer it into the listview. The task I set for myself is as follows, but I have not accomplished it yet. I request your help for this.

The example I'm trying to do is:
Each day has a word and its explanation and sentence. I want the application to take the date where it is located and bring the word, explanation and sentence related to that date.

I wrote the codes in my logic, but it didn't work. I wonder if you can help me update the blocks?

Thanks in advance everyone.

Files:
words_of_day_with_google_sheet.aia (4.0 KB)
word_of_days.csv (1.4 KB)

[TIMAI2]

Use gviz query ?

METRIC RAT AI2 - Use gviz to get and query google sheet data

[ABG]

words_of_day_with_Media_File.aia (4.3 KB)

[aimar]

Thank you so so much @ABG and @TIMAI2 for your guidance You made my day