How can I collect information from my spreadsheet data source when I select a particular date

[youngboyzrecord9sr2n]

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

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).

The Second screen block(Data Readings).

Please I NEED HELP IN GETTING THE RIGHT BLOCKS!

[ioannis]

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:

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

[youngboyzrecord9sr2n]

This the error code I get on the live app

[youngboyzrecord9sr2n]

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.

[ioannis]

Hi @youngboyzrecord9sr2n
The issue is not with the two screen.
Could you please change the component from rich text to a label?

[youngboyzrecord9sr2n]

Yes I change it to label and it work

But I don’t like how the text is display
I need space and change some of the text colors. Something like this below

And this

Please is there any thing I can do?

[ioannis]

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.

[ioannis]

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 of your browser for the changes to take effect in your project. If you experienced any of these issues on the Thunkable Live 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 is affected by any of these issues, you will need to re-download or re-publish your app for these changes to take effect.