# Response time from filtered data in spreadsheet

**URL:** <https://community.thunkable.com/t/response-time-from-filtered-data-in-spreadsheet/3279200>\
**Category:** Questions about Thunkable X\
**Created:** [October 17, 2024, 4:33pm UTC](https://community.thunkable.com/t/response-time-from-filtered-data-in-spreadsheet/3279200 "2024-10-17T16:33:46Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![robert.newton.442rpp](https://avatars.discourse-cdn.com/v4/letter/r/a87d85/32.png) [@robert.newton.442rpp](https://community.thunkable.com/u/robert.newton.442rpp)\
**Post date:** [October 17, 2024, 4:33pm UTC](https://community.thunkable.com/t/response-time-from-filtered-data-in-spreadsheet/3279200/1 "2024-10-17T16:33:47Z")

</div>

I am working on app and I stuck with filtered data from spreadsheet.  
Here is code how I add uniqe dates into spreadsheet FilteredDates in Sheet2 column ‘uniqedates’.

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/8/0890fa334f491971d37075470aada8d3cd2a6876.png)  
That works fine.  
I connect dataviewer with same spreadsheet and sheet and all data are visible. That is good to.

Next step is problem. When user click on date in dateviewer it should parse date on next screen but it does not. I just got blank label.  
Here is code.

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/d/fdb259ab70ac46700aeeb3f2be32212c09781bab.png)

I can get row id but can’t get value from column ‘uniqedates’. Label on next screen (or same screen just for attempt) is blank.  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/3/139df614ca2974a4f273d50cdf062b355220d068.png)

Does it in call refresh data but then how is row id visible. Maybe is problem with response time but I waited for few minutes and nothing show up.

Thanks for help.

---

<div class="post-metadata">

**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:** [October 18, 2024, 6:10pm UTC](https://community.thunkable.com/t/response-time-from-filtered-data-in-spreadsheet/3279200/2 "2024-10-18T18:10:51Z")

</div>

Hi @robert.newton.442rpp , welcome to Thunkable! 🎉

In general, I would suggest you use a local table to save the Filtered Dates to avoid too many calls to Google Sheets.

Also, after you create new rows on the data source you could try to refresh the Data Viewer.

Be sure to check out [How to ask Great Questions v2.0](https://community.thunkable.com/t/how-to-ask-great-questions-v2-0/2689983/1), the [Community Guidelines](https://community.thunkable.com/t/community-guidelines/78/8), and our [Getting Started Guide](https://docs.thunkable.com/getting-started/get-started) to make the best of your Thunkable Community experience!

---

<div class="post-metadata">

**Author:** ![robert.newton.442rpp](https://avatars.discourse-cdn.com/v4/letter/r/a87d85/32.png) [@robert.newton.442rpp](https://community.thunkable.com/u/robert.newton.442rpp)\
**Post date:** [October 20, 2024, 1:27pm UTC](https://community.thunkable.com/t/response-time-from-filtered-data-in-spreadsheet/3279200/3 "2024-10-20T13:27:56Z")

</div>

I rewrite entire code and done it on local level. I didn’t use local table just lists. Now I have one call to Spreadsheet and entire filtering is done on user side. It is much faster code.

You can close topic.

---

<div class="post-metadata">

**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:** [October 21, 2024, 11:20am UTC](https://community.thunkable.com/t/response-time-from-filtered-data-in-spreadsheet/3279200/4 "2024-10-21T11:20:53Z")

</div>