Ephemeris with a calendar

Hello, I am designing an app where I need to enter a date and show me the ephemeris or holydays in that date, which I have already loaded in my spreadsheet. In my photo I have what I would like, but the information does not change according to the date I choose. Can anybody help me.

You have to make a relation matching that input date with the date you stored in your sheet, then return the text via a lookup.

1 Like

I will search about that. Where I need to do that? In my spreadsheet?

In my spreadsheet I only have this

First make a user-specific column to store your date choice.

Then make a relation matching that value to the date you stored in the “Fecha” column.

Have a lookup column, taking the “Texto” value from that relation and display it in your app.