My pastor encourages us to read the Psalms and Proverbs everyday.
He has taught us a system of reading that will take us through them once a month.
I took his system and created an app. What I like most of all about the app is the little workaround I have for the homepage being the correct DAY of the month.
Because the reading is the DAY of the month, it is a finite/rotating system. Each FIRST of the month I want the #1 row to appear on the front page. Then 2 and 3 and so on.
Here is how I did the front page to be relevant each day.
Info Sheet with ALL the info - one for each day of the month
I have a sheet with 31 rows. One for each possible day of the month.
Column B is the day of the month and the rest of the Row is the information for that day.
Column A is a FORMULA =day(today())-B2
So, TODAY’s Day of the month MINUS the info in that row
TODAY will always be calculated as ZERO - each day the ZERO moves to the next day.
In my TODAY sheet I just have ONE row that is FILTERED to ‘grab’ the correct row from the Info sheet
This becomes my APPs homepage.
Note: Because I have the FREE version, this will NOT happend AUTOmagically.
I have an Update button at the bottom of the front page asking my users to submit a form that just enters a timestamp. This then updates the app to TODAY.