This can be achieved by using a fullscreen image region that uses the ODBC data source to tell us which png to use. Since your menu information is coming from a spreadsheet, I will assume excel, we can use that data source to tell us which day of the week it is. By using an "Advanced" SELECT statement (applying to excel
) such as:SELECT *, WEEKDAY(NOW()) AS Weekday FROM [TableNameHere$]For other community users who are not familiar with data source connectivity see this post http://www.noventri.com/forum/viewtopic.php?f=6&t=225.
This statement will return all of the columns from your spreadsheet as well as a new column called "Weekday".
The "Weekday" column will be a number
representing the day of the week. For example 1 would be Sunday, 2 would be Monday, 3 would be Tuesday, etc.
The way an image region makes use of the ODBC data source is by allowing the returned data to complete a portion of the file path to the image. Therefore, we will want to have a directory of images for each day of the week. For example:
Each image would be a full screen transparent png with the box/line in the appropriate location for the day of week.
Now we are ready to point our project to these images. Back in our image region with the previously mentioned advanced SELECT statement - Enter the image path to your directory of images for each day of the week with the database formatter in place of the number. For example:
Now you can press "Refresh Now" on the "Advanced" tab and you will see the box around the applicable day.
I hope this solves your goal, and please let us know if it does not or if you have any questions.