# Ephemeris with a calendar

**URL:** <https://community.glideapps.com/t/ephemeris-with-a-calendar/11562>\
**Category:** Feature Requests\
**Created:** [June 27, 2020, 9:25pm UTC](https://community.glideapps.com/t/ephemeris-with-a-calendar/11562 "2020-06-27T21:25:26Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sergio\_de\_Jesus\_Cace](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sergio_de_jesus_cace/32/9809_2.png) [@Sergio\_de\_Jesus\_Cace](https://community.glideapps.com/u/Sergio_de_Jesus_Cace)\
**Post date:** [June 27, 2020, 9:25pm UTC](https://community.glideapps.com/t/ephemeris-with-a-calendar/11562/1 "2020-06-27T21:25:26Z")

</div>

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.

 ![Screen](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/96b3d50942b9de8643fc276afc6f1b27b1eb211c.jpeg)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 27, 2020, 9:28pm UTC](https://community.glideapps.com/t/ephemeris-with-a-calendar/11562/2 "2020-06-27T21:28:14Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Sergio\_de\_Jesus\_Cace](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sergio_de_jesus_cace/32/9809_2.png) [@Sergio\_de\_Jesus\_Cace](https://community.glideapps.com/u/Sergio_de_Jesus_Cace)\
**Post date:** [June 27, 2020, 9:34pm UTC](https://community.glideapps.com/t/ephemeris-with-a-calendar/11562/3 "2020-06-27T21:34:50Z")

</div>

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

In my spreadsheet I only have this

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/cfb70e797dea4f699a85165c3ffc4f7c8bcb071e.png)

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [June 27, 2020, 10:26pm UTC](https://community.glideapps.com/t/ephemeris-with-a-calendar/11562/4 "2020-06-27T22:26:32Z")

</div>

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.