# \[Solved\] Attempting to only show specific rows in dataviewer **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** beginner, airtable\ **Created:** [January 22, 2021, 5:08am UTC](https://community.thunkable.com/t/solved-attempting-to-only-show-specific-rows-in-dataviewer/1063071 "2021-01-22T05:08:56Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![sp72979rdrlbc](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sp72979rdrlbc/32/94224_2.png) [@sp72979rdrlbc](https://community.thunkable.com/u/sp72979rdrlbc)\ **Post date:** [January 22, 2021, 5:08am UTC](https://community.thunkable.com/t/solved-attempting-to-only-show-specific-rows-in-dataviewer/1063071/1 "2021-01-22T05:08:56Z")
I have this to-do list app. There is a date picker in the to-do list. I’m trying to only show rows from the airtable for a selected day. For example, if it’s 1/21/2021, then the user would see all their to-do list for 1/21/2021. I tried something like this: ![Thunkable - Google Chrome 1_21_2021 9_04_25 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/4/94c7645b27e5c3ceb6083c770bdcde0af9bf6ce6.png) But it didn’t work. I’m not sure if this is possible so I wanted to see if it was, and if it is how would I do this. Here is a link to the app if you’d like to have a look inside: [https://x.thunkable.com/copy/cc942f16809c23f757d0a06ef380bef6](https://x.thunkable.com/copy/cc942f16809c23f757d0a06ef380bef6) ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [January 22, 2021, 5:19am UTC](https://community.thunkable.com/t/solved-attempting-to-only-show-specific-rows-in-dataviewer/1063071/2 "2021-01-22T05:19:27Z")
What does your airtable data look like? ---
**Author:** ![sp72979rdrlbc](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sp72979rdrlbc/32/94224_2.png) [@sp72979rdrlbc](https://community.thunkable.com/u/sp72979rdrlbc)\ **Post date:** [January 22, 2021, 5:32am UTC](https://community.thunkable.com/t/solved-attempting-to-only-show-specific-rows-in-dataviewer/1063071/3 "2021-01-22T05:32:13Z")
It looks like this!: ![TDL_ Table 1 - Airtable - Google Chrome 1_21_2021 9_30_43 PM (2)](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/a/3af014cda3704e7a9d030c091e1fdca931def195.png) ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [January 22, 2021, 5:35am UTC](https://community.thunkable.com/t/solved-attempting-to-only-show-specific-rows-in-dataviewer/1063071/4 "2021-01-22T05:35:03Z")
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). ---
**Author:** ![sp72979rdrlbc](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sp72979rdrlbc/32/94224_2.png) [@sp72979rdrlbc](https://community.thunkable.com/u/sp72979rdrlbc)\ **Post date:** [January 22, 2021, 5:37am UTC](https://community.thunkable.com/t/solved-attempting-to-only-show-specific-rows-in-dataviewer/1063071/5 "2021-01-22T05:37:28Z")
Alright! I’ll try that, thank you! ---
**Author:** ![sp72979rdrlbc](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sp72979rdrlbc/32/94224_2.png) [@sp72979rdrlbc](https://community.thunkable.com/u/sp72979rdrlbc)\ **Post date:** [January 23, 2021, 12:17am UTC](https://community.thunkable.com/t/solved-attempting-to-only-show-specific-rows-in-dataviewer/1063071/6 "2021-01-23T00:17:32Z")
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… ![Thunkable - Google Chrome 1_22_2021 4_13_08 PM (2)](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/2/3/234e17082bd752c05233b8e137ec53ba2f3e5e77.png) Thanks again for the help! ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [January 23, 2021, 2:01am UTC](https://community.thunkable.com/t/solved-attempting-to-only-show-specific-rows-in-dataviewer/1063071/7 "2021-01-23T02:01:35Z")
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. ---
**Author:** ![sp72979rdrlbc](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sp72979rdrlbc/32/94224_2.png) [@sp72979rdrlbc](https://community.thunkable.com/u/sp72979rdrlbc)\ **Post date:** [January 23, 2021, 2:21am UTC](https://community.thunkable.com/t/solved-attempting-to-only-show-specific-rows-in-dataviewer/1063071/9 "2021-01-23T02:21:59Z")
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? ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [January 23, 2021, 4:27am UTC](https://community.thunkable.com/t/solved-attempting-to-only-show-specific-rows-in-dataviewer/1063071/10 "2021-01-23T04:27:52Z")
I’m working on a demo for you… but Thunkable is giving me delayed and different results every time I preview the project so I’m not getting very far. 😠 ---
**Author:** ![sp72979rdrlbc](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sp72979rdrlbc/32/94224_2.png) [@sp72979rdrlbc](https://community.thunkable.com/u/sp72979rdrlbc)\ **Post date:** [January 23, 2021, 4:52am UTC](https://community.thunkable.com/t/solved-attempting-to-only-show-specific-rows-in-dataviewer/1063071/11 "2021-01-23T04:52:07Z")
It’s okay! I know it can be annoying, so you really don’t have to if it’s out of your way right now! ---
**Author:** ![sp72979rdrlbc](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sp72979rdrlbc/32/94224_2.png) [@sp72979rdrlbc](https://community.thunkable.com/u/sp72979rdrlbc)\ **Post date:** [January 24, 2021, 7:07am UTC](https://community.thunkable.com/t/solved-attempting-to-only-show-specific-rows-in-dataviewer/1063071/12 "2021-01-24T07:07:35Z")
Okay! I think I figured out how to do it, ![Thunkable - Google Chrome 1_23_2021 11_03_55 PM (2)](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/0/5072b09edef8813eca7b03a2da9f9869ebc0655c.png) I’m having trouble figuring out how to set the property of a clicked list viewer item. (right side of code when user presses finished button) ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [January 24, 2021, 7:13am UTC](https://community.thunkable.com/t/solved-attempting-to-only-show-specific-rows-in-dataviewer/1063071/13 "2021-01-24T07:13:01Z")
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. ---
**Author:** ![sp72979rdrlbc](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/sp72979rdrlbc/32/94224_2.png) [@sp72979rdrlbc](https://community.thunkable.com/u/sp72979rdrlbc)\ **Post date:** [January 24, 2021, 7:27am UTC](https://community.thunkable.com/t/solved-attempting-to-only-show-specific-rows-in-dataviewer/1063071/14 "2021-01-24T07:27:37Z")
Okay, I defined it but it still doesn’t change the airtable row or list viewer item? ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [January 24, 2021, 7:40am UTC](https://community.thunkable.com/t/solved-attempting-to-only-show-specific-rows-in-dataviewer/1063071/15 "2021-01-24T07:40:30Z")
The same issue I replied to in another post. ---
**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\ **Post date:** [November 8, 2024, 1:30pm UTC](https://community.thunkable.com/t/solved-attempting-to-only-show-specific-rows-in-dataviewer/1063071/16 "2024-11-08T13:30:34Z")