I am working on a system where the app creator can ‘schedule’ posts ahead of time.
Here is the link: https://vyqrm.glideapp.io
(You can copy the sheet)
In the “Schedule” tab, I have several simple posts for the past and present and future.
In the “Latest” tab I have ONE LINE with a couple of formulas:
A2 - Grab the closest date to TODAY - including TODAY) - If it is NOT today, it will find the closest past date
B2 - Grab the rest of the row that matches the closest day (populates B-C-D from Schedule)
In the APP
I have a Details layout with the ONE line info for the “Latest” tab
I also have a list of the PAST posts by with a FILTER that makes sure the DATE is BEFORE today.
(So NO FUTURE posts appear)
Then as each day turns, the “Latest” tab looks to see if TODAY’s date matches any in the “Schedule” sheet.
If it does, it puts the new current post at the top of the app, AND moves the previous post to the “Previous Thoughts” part of the page.