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.