Changes

Jump to: navigation, search

Timesheet Variables

915 bytes added, 18:26, 24 July 2014
Examples
The code between the '''[#(?object=timesheet)''' and closing '''#]''' will be repeated for each timesheet item to be included.
 
Other examples include:
 
===Last Timesheet Entry Date===
[#(?object=timesheet;groupfunction=max)~actiondate~#]
 
===Non-Invoiced Hours===
<!--@sscalculation((REPLACE("[#(?object=timesheet;criteria=tsinvoiceid=0 and isagainstjob=1;groupfunction=sum)~totalhours~#]",",",""))*1)-->
 
==Invoiced==
<!--@sscalculation((REPLACE("[#(?object=timesheet;criteria=tsinvoiceid>0 and isagainstjob=1;groupfunction=sum)~totalhours~#]",",",""))*1)-->
 
===Non-billable hours===
<!--@sscalculation((REPLACE("[#(?object=timesheet;criteria=isagainstjob=0;groupfunction=sum)~totalhours~#]",",",""))*1)-->
 
===Billable Hours===
<!--@sscalculation((REPLACE("[#(?object=timesheet;criteria=isagainstjob=1;groupfunction=sum)~totalhours~#]",",",""))*1)-->
 
===Actual Hours (total hours)===
<!--@sscalculation(REPLACE("[#(?object=timesheet;groupfunction=sum)~totalhours~#]",",","")*1)-->
 
===Timecodes===
[#(?object=timesheet;)~timecode~<BR>#]
==See Also==
8,849
edits

Navigation menu