Product: LABELVIEW, CODESOFT
Version: All Versions
|
1. If you haven't already done so, go to View and enable the Data Sources panel.
2. Right-click Formula and select Add. This will launch the Formula window.
3. From the Formula tab, give the formula a Name.
4. Select the Date & Time category from the list of predefined formulas, and then select ShiftCode. Click Insert.
5. The ShiftCode formula will appear in the text box. This formula needs two pieces of information: items and defaultValue.
a. items is where each shift is defined. Shifts must be input in "startHour:startMin-stopHour:stopMin-value|" format.
For example: 1st shift (7:00-15:00), 2nd shift (15:00-23:00), and 3rd shift (23:00-7:00)
In ShiftCode format: "7:00-15:00-1st|15:00-23:00-2nd|23:00-7:00-3rd"
b. defaultValue sets the default shift value. Using the example data above, we'll just set the default to "1st".
6. Input your shift data into the ShiftCode formula. The preview should return the appropriate shift value for the current time. Please note that a 24-hour clock is used to define time values. Click OK.
7. Place the formula on the label, either by clicking and dragging the formula from the Data sources window, or by right-clicking the formula and selecting Place.
|