Time Tracking Automation

							
							//This is to track the time on the AE work, it covers both the Online and Prep, it compares the current and previous status if a mismatch it checks if anything should be done then revises
//pull in the record details from automation
let inputConfig = input.config();
let RecordID = inputConfig[“RecordID”];

//I dislike pulling everything from the input variables so I pull them in a more normal scripting approach
let table = base.getTable(“Projects”);
let QueryResult = await table.selectRecordsAsync();
let Record = QueryResult.getRecord(RecordID);

// grab the things needed to check
let AEWorkOnlineStatus = Record.getCellValue(“AE Work Online Status”);
let AEWorkOnlinePreviousStatus = Record.getCellValue(“AE Work Online Previous Status”);
let AEWorkOnlineRecentchangeTime = Record.getCellValue(“AE Work Online Recent change time”);
let AEWorkOnlineWorkPreviousTime = Record.getCellValue(“AE Work Online Work Previous Time”);
let AEWorkOnlineTimeTrackTotal = Record.getCellValue(“AE Work Online Time Track Total”);

if (AEWorkOnlinePreviousStatus.name == AEWorkOnlineStatus.name){
//do nothing they match this is not the time your looking for
}else{
/// Check that the Previous status was a status you want time tracked, effectivly a filter for do you add time
if (AEWorkOnlinePreviousStatus.name!=“Finishing in Progress”){
// this does not need time tracking so just update the previous status to recent status
// and the previous time to current time
await table.updateRecordAsync(RecordID,{“AE Work Online Previous Status”:{“name”:AEWorkOnlineStatus.name}});
let RecentTime = new Date(AEWorkOnlineRecentchangeTime);
await table.updateRecordAsync(RecordID,{“AE Work Online Work Previous Time”:RecentTime});
} else {
// this does need time tracking done.
// clean up the Time for callculation
let RecentTime = new Date(AEWorkOnlineRecentchangeTime);
let RecentTimeUTCMilli = RecentTime.getTime();
let PreviousTime = new Date(AEWorkOnlineWorkPreviousTime);
let PreviousTimeUTCMilli = PreviousTime.getTime();

// find the diff in time between the 2 and convert to seconds (duration field takes seconds)
let MilliDif = (RecentTimeUTCMilli-PreviousTimeUTCMilli);
let SecDif = (MilliDif/1000);

//add the diff to the previous total time then push to total time
let NewTotalTime = AEWorkOnlineTimeTrackTotal+SecDif;
await table.updateRecordAsync(RecordID,{“AE Work Online Time Track Total”:NewTotalTime});

// update the previous status. this takes the item out of the automation view also update the previous time to recent time

await table.updateRecordAsync(RecordID,{“AE Work Online Previous Status”:{“name”:AEWorkOnlineStatus.name}});
await table.updateRecordAsync(RecordID,{“AE Work Online Work Previous Time”:RecentTime});
}
}