Daily Quote app

Ask for Help
1

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?

2

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!

3

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

4

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

1 Like
5

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.

6

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
image553×786 44.5 KB

  • 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
image524×627 36.1 KB

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

image
image1639×434 73.9 KB

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

image
image1381×687 50 KB

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

It worked. Thank you very much.

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…

1 Like
8

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