I think you’d want to find the starting row # for that particular date and the ending row # and then get the column called “item” and create a list that contains those cells. Then, keep only the list items within that range (starting row to ending row).
I think I didn’t explain what I was trying to accomplish effectively.
I was able to find the first occurrence of the selected date and the last occurrence of the selected date. I was trying to only show the items inputted on a selected date in the data viewer, is that possible? In other words, I’m wondering if it’s possible to only show a certain number of rows in the data viewer
Something like this (I know why this doesn’t work) but i was wondering if this idea was possible…
When I retrieve a “date” formatted Airtable cell in Thunkable, it appears in the format “2021-01-22” even though in Airtable, it shows up as “January 22, 2021”. So I’m guessing that your date strings aren’t matching even when the compared dates are the same.
But I definitely think what you’re trying to do is possible.
Right! I saw that as well and changed the date format of my date picker!
I was just having trouble only displaying the selected rows, any ideas on how I could do that?
You’re setting the value of the “item” variable to the green item block, which is the title of the listviewer item that was clicked. But then you’re trying to use the “index” variable in the “when finished click” block. Have you defined that value? I assume you meant to define it above in the listviewer “item click” block.
