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.