# Daily Quote app

**URL:** <https://community.glideapps.com/t/daily-quote-app/71587>\
**Category:** Ask for Help\
**Created:** [March 11, 2024, 11:32am UTC](https://community.glideapps.com/t/daily-quote-app/71587 "2024-03-11T11:32:35Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Erick88](https://avatars.discourse-cdn.com/v4/letter/e/cab0a1/32.png) [@Erick88](https://community.glideapps.com/u/Erick88)\
**Post date:** [March 11, 2024, 11:32am UTC](https://community.glideapps.com/t/daily-quote-app/71587/1 "2024-03-11T11:32:35Z")

</div>

I’m making a simple quote app that displays different quotes every day. I already have a table containing 3 columns, quotes, its respective author and an image. how can i make the app display a different app every day from the quotes table?

---

<div class="post-metadata">

**Author:** ![Collin\_Stedham](https://avatars.discourse-cdn.com/v4/letter/c/13edae/32.png) [@Collin\_Stedham](https://community.glideapps.com/u/Collin_Stedham)\
**Post date:** [March 11, 2024, 11:45am UTC](https://community.glideapps.com/t/daily-quote-app/71587/2 "2024-03-11T11:45:26Z")

</div>

Make a custom screen with a card. Then link the card to your table. Assign a number value based on the date using a math column. Then assign a number value to each row. Make an If-Then-Else that says if the number value matches the math column, display true. Then go back to your table. Go to the “options” tab on your card display. Click the “filter” tab and set the conditions to "display when ‘if-then-else’ is ‘true’. This should, if the math column is right, set a quote for each day.

You don’t have to do cards, I just think it would be better from a UI perspective.

Hope I helped!

---

<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:** [March 11, 2024, 1:15pm UTC](https://community.glideapps.com/t/daily-quote-app/71587/3 "2024-03-11T13:15:32Z")

</div>

Do you have to display a set card on a set date though? Or it can be randomly displayed to users?

---

<div class="post-metadata">

**Author:** ![Collin\_Stedham](https://avatars.discourse-cdn.com/v4/letter/c/13edae/32.png) [@Collin\_Stedham](https://community.glideapps.com/u/Collin_Stedham)\
**Post date:** [March 11, 2024, 1:29pm UTC](https://community.glideapps.com/t/daily-quote-app/71587/4 "2024-03-11T13:29:46Z")

</div>

You could use a math column to set up a filter that filters the quotes per date.

---

<div class="post-metadata">

**Author:** ![Erick88](https://avatars.discourse-cdn.com/v4/letter/e/cab0a1/32.png) [@Erick88](https://community.glideapps.com/u/Erick88)\
**Post date:** [March 11, 2024, 10:29pm UTC](https://community.glideapps.com/t/daily-quote-app/71587/5 "2024-03-11T22:29:25Z")

</div>

The table has 102 quotes in total. It just has to display a different one every day automatically from the first to the last. After it displays the last, it goes back to display the first, like a cycle. Everything is triggered by the date.

---

<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:** [March 12, 2024, 12:24am UTC](https://community.glideapps.com/t/daily-quote-app/71587/6 "2024-03-12T00:24:41Z")

</div>

I will list out the steps that I think make sense for this use case:

- Create a Date Difference Raw column in your Users table. Specify a Start Date.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/0/403abf520e1289237464af365670d9348da379d3.png)

- Use a Math Column to get the index of the current day that matches with the quotes. Say you start today, then the result of this column is 0. If you’re on day 103 then the result of this column will be 1.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/9/19da573c9857332783be1af16f2888682f3ca059.png)

- In your Quotes table, create a lookup column that targets the whole list of rowIDs.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/d/4d9f83ce5cbcc3bdd6b10b421f4769481ac2af8b.png)

- Add a column to get each row’s index.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/3/e3676b4b66764e79c6f0f8800e042b641817bd6f.png)

- Add a custom collection pointing to the Quotes table, add components as needed, filter it by index equals User Profiles \> Date Since Final.

---

<div class="post-metadata">

**Author:** ![Erick88](https://avatars.discourse-cdn.com/v4/letter/e/cab0a1/32.png) [@Erick88](https://community.glideapps.com/u/Erick88)\
**Post date:** [March 12, 2024, 11:11am UTC](https://community.glideapps.com/t/daily-quote-app/71587/7 "2024-03-12T11:11:39Z")

</div>

It worked. Thank you very much.

> **[Daily Quotes](https://daily-quotes-ughv.glide.page)**

That’s the link to the app just in case you like quotes. I’ll keep it published for a couple of days as I’m developing other apps. Again, THANK YOU…

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [March 19, 2024, 11:12am UTC](https://community.glideapps.com/t/daily-quote-app/71587/8 "2024-03-19T11:12:25Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
