I have a collection of 7 videos that I want to rotate on a customer’s home screen based on the day of the week. I have the videos with a column for 1-7 and Monday-Sunday.
What would be the best solution to get the correct video to be available on the current weekday?