I want to display the picture of Shift Engineers on the web view. I have 4 shift engineers and they work in different shifts, i.e. 6:00 to 14:00, 14:00 to 22:00 and 22:00 to 6:00 on different days. Their duties are pre-scheduled. I want to display the picture of the Shift Engineer on duty automatically (as per the schedule) on the web view. Kindly suggest the easiest way to do that.
I shall take it as a complement, thanks.
The display can be either photos or names of the Shift Engineers or both by using dynamic picture/text. But how? Can it be done on web page itself or has it to be done using formula?
As addition to manjey73:
You need to create a formula in the Formulas table that returns a number 0, 1, 2… depending on current time. Then create an input channel and use this formula to display photo or name.