Status display on Table view

[zaky]

Dear all

 

i want to make a status display

i have these 2 properties

 

i want to get a list of how's the status on each of those properties is in the table view

can i get a hint?

[Chris Harp]

Assuming you have a Condition called "Shift" displayed in your Condition Table and you need to add the "Mode" of the Status Stamp as a property to Shift. You can use a $shift_condition.mergeProperties($status_stamp).  However, you will need to rename the "Mode" property in your Shift Condition so that Stamp Status "Mode" property does not override the existing "Mode" property in the Shift condition.

Shift 1 Formula:

shifts(8, 8, 'America/Chicago').touches(workWeeks()).setProperty('Shift', 'Shift 1')

Replicate for Shift 2 and Shift 3. I used .move() function in my example to create Shift 2 and 3.

Status Stamp Formula:

$ps2.setProperty('Mode', "PROCESS")
.combineWith($ss.setProperty('Mode', "STOP"))

Combined Shift Formula:

combineWith($s1,$s2,$s3).mergeProperties($status_stamp)

Select the Property for "Shift" and "Mode" to be displayed.