# How can I collect information from my spreadsheet data source when I select a particular date **URL:** \ **Category:** Issues / Bugs\ **Tags:** beginner, spreadsheets, date\_picker, data-source\ **Created:** [October 28, 2024, 10:05am UTC](https://community.thunkable.com/t/how-can-i-collect-information-from-my-spreadsheet-data-source-when-i-select-a-particular-date/3305835 "2024-10-28T10:05:07Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![youngboyzrecord9sr2n](https://avatars.discourse-cdn.com/v4/letter/y/85e7bf/32.png) [@youngboyzrecord9sr2n](https://community.thunkable.com/u/youngboyzrecord9sr2n)\ **Post date:** [October 28, 2024, 10:05am UTC](https://community.thunkable.com/t/how-can-i-collect-information-from-my-spreadsheet-data-source-when-i-select-a-particular-date/3305835/1 "2024-10-28T10:05:07Z")
Please I need help. I have a spreadsheet which is connected to my project where I have DATE, FIRST READING, PSALM, SECOND READIND and so others. see image below ![Screenshot (27)](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/6/c69d823a95cdd94e1563bcead12b4dfd2fcf49cf.png) Then I created a two screens, one for for the date picker and the second to display the readings. So the idea is when select a date it will take me to the reading gotten from the data source to my second screen. But I have tried everything seems not to be working even though I used ChatGPT I’m still lost. Here’s the block for the First screen Date Selection(Date Picker). ![Screenshot (28)](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/6/d63b5636fe02d85a73d8367de8a991896a2fcfbf.png) The Second screen block(Data Readings). ![Screenshot (26)](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/4/b4bd14b9ea73f916b247d4645905f0edb2ddff82.png) Please I NEED HELP IN GETTING THE RIGHT BLOCKS! ---
**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 28, 2024, 1:43pm UTC](https://community.thunkable.com/t/how-can-i-collect-information-from-my-spreadsheet-data-source-when-i-select-a-particular-date/3305835/2 "2024-10-28T13:43:19Z")
Hello @youngboyzrecord9sr2n Thank you for sharing screenshots. The green “Date input” block returns the component ID and not the date. To get the date on the needed format you could use the following blocks: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/2/b255cde575d4db9419ada9836df1d01b11065d73.png) Also, the “get first row object from” block returns an object so you could use the “generate json from object” block to connect it with a label ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/8/084a508fe0e1e766824ff7bfefd24bd2364127b0.png) ---
**Author:** ![youngboyzrecord9sr2n](https://avatars.discourse-cdn.com/v4/letter/y/85e7bf/32.png) [@youngboyzrecord9sr2n](https://community.thunkable.com/u/youngboyzrecord9sr2n)\ **Post date:** [October 28, 2024, 9:49pm UTC](https://community.thunkable.com/t/how-can-i-collect-information-from-my-spreadsheet-data-source-when-i-select-a-particular-date/3305835/3 "2024-10-28T21:49:14Z")
![Screenshot_20241028-224645_Thunkable](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/d/8db5276d7c312e3d532082756321806131014fb6.jpeg) This the error code I get on the live app ---
**Author:** ![youngboyzrecord9sr2n](https://avatars.discourse-cdn.com/v4/letter/y/85e7bf/32.png) [@youngboyzrecord9sr2n](https://community.thunkable.com/u/youngboyzrecord9sr2n)\ **Post date:** [October 28, 2024, 9:50pm UTC](https://community.thunkable.com/t/how-can-i-collect-information-from-my-spreadsheet-data-source-when-i-select-a-particular-date/3305835/4 "2024-10-28T21:50:55Z")
Plus remember I said there is two screen one for the calendar(date\_input) and then the second to display the content(text) when the date is picked. ---
**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 29, 2024, 10:02am UTC](https://community.thunkable.com/t/how-can-i-collect-information-from-my-spreadsheet-data-source-when-i-select-a-particular-date/3305835/5 "2024-10-29T10:02:26Z")
Hi @youngboyzrecord9sr2n The issue is not with the two screen. Could you please change the component from rich text to a label? ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/0/a01d4e4b4848dd393d64ee19094de6476687dc6a.png) ---
**Author:** ![youngboyzrecord9sr2n](https://avatars.discourse-cdn.com/v4/letter/y/85e7bf/32.png) [@youngboyzrecord9sr2n](https://community.thunkable.com/u/youngboyzrecord9sr2n)\ **Post date:** [October 29, 2024, 11:07am UTC](https://community.thunkable.com/t/how-can-i-collect-information-from-my-spreadsheet-data-source-when-i-select-a-particular-date/3305835/6 "2024-10-29T11:07:57Z")
Yes I change it to label and it work ![Screenshot_20241029-115541_Thunkable](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/d/4de842112e51fd1fed9735bd2aba923c0c9f76be.jpeg) But I don’t like how the text is display I need space and change some of the text colors. Something like this below ![Screenshot_20241029-120051](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/b/db72e06e67c3b19affe2bab7ca08bbd100ccab32.jpeg) And this ![Screenshot_20241029-120018](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/0/001b452d2d5a146360a4109e26a3347272631105.jpeg) Please is there any thing I can do? ---
**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 21, 2024, 9:48am UTC](https://community.thunkable.com/t/how-can-i-collect-information-from-my-spreadsheet-data-source-when-i-select-a-particular-date/3305835/7 "2024-11-21T09:48:40Z")
Hi, We have flagged it to our engineering team and will provide an update as soon as possible. Thank you for your time and patience in this matter. ---
**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:** [December 18, 2024, 4:55pm UTC](https://community.thunkable.com/t/how-can-i-collect-information-from-my-spreadsheet-data-source-when-i-select-a-particular-date/3305835/8 "2024-12-18T16:55:39Z")
Hello @youngboyzrecord9sr2n Thank you again for your patience. I would like to let you know that we have now officially released a fix for this bug and now the app is not crashing. ​ Please keep in mind that you may need to do a [hard refresh](https://docs.thunkable.com/getting-started/data-sources/data-sources#hard-refresh-your-browser)of your browser for the changes to take effect in your project. If you experienced any of these issues on the [Thunkable Live](https://thunkable.com/mobile) app, you will need to update to the latest version through the App Store and/or Google Play Store before any changes will occur. If your [downloaded or published app](https://docs.thunkable.com/publishing-apps/publish) is affected by any of these issues, you will need to re-download or re-publish your app for these changes to take effect.