Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- var jobsArray = []
- for(let x = 0; x < getKnackJobRecords.length; x++) {
- //var found = false;
- for(let y = 0; y < getWorkflowJobs.length; y++) {
- //Break loop if id is found in knack records
- // if(getKnackJobRecords[x].field_173 == getWorkflowJobs[y].ID) {
- // found = true
- // break;
- // }
- //Address is in name field, so need to split to specific special char
- const [beforeAddress, afterAddress] = getWorkflowJobs[y].Description.split("-")
- //FORMAT DATE START/END DATES FOR KNACK
- let startDateFormat = moment(getWorkflowJobs[y].StartDate).format('DD/MM/YYYY')
- let dueDateFormat = moment(getWorkflowJobs[y].DueDate).format('DD/MM/YYYY')
- const jobData = {
- //JOB
- field_173: getWorkflowJobs[y].ID,
- field_171:getWorkflowJobs[y].Description,
- field_172:getWorkflowJobs[y].WorkActivity,
- field_169: startDateFormat,
- field_170: dueDateFormat,
- field_180: String(beforeAddress),
- field_190: getWorkflowJobs[y].State,
- field_191: getWorkflowJobs[y].otherAssStaffIds,
- field_190: getWorkflowJobs[y].Type,
- //CLIENT DETAILS
- field_174: getWorkflowJobs[y].ClientOrderNumber,
- field_175: getWorkflowJobs[y].ClientName,
- //ASSIGNED STAFF
- field_178: getWorkflowJobs[y].assignedStaffIds,
- field_176: getWorkflowJobs[y].assignedStaffNames,
- //field_22: getWorkflowJobs[y].otherAssStaffIds,
- field_177: getWorkflowJobs[y].otherAssStaffNames,
- }
- //If id is not found, update record with data
- //if(found == false) {
- jobsArray.push(knack.createRecord(1, jobData))
- await knack.sleep(200);
- //}
- }
- }
- await Promise.all(jobsArray)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement