Advertisement
Guest User

Untitled

a guest
Nov 20th, 2019
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.     var jobsArray = []
  2.     for(let x = 0; x < getKnackJobRecords.length; x++) {
  3.         //var found = false;
  4.         for(let y = 0; y < getWorkflowJobs.length; y++) {
  5.             //Break loop if id is found in knack records
  6.             // if(getKnackJobRecords[x].field_173 == getWorkflowJobs[y].ID) {
  7.             //     found = true
  8.             //     break;
  9.             // }
  10.  
  11.             //Address is in name field, so need to split to specific special char
  12.             const [beforeAddress, afterAddress] = getWorkflowJobs[y].Description.split("-")
  13.  
  14.             //FORMAT DATE START/END DATES FOR KNACK
  15.             let startDateFormat = moment(getWorkflowJobs[y].StartDate).format('DD/MM/YYYY')
  16.             let dueDateFormat = moment(getWorkflowJobs[y].DueDate).format('DD/MM/YYYY')
  17.  
  18.             const jobData = {
  19.                 //JOB
  20.                 field_173: getWorkflowJobs[y].ID,
  21.                 field_171:getWorkflowJobs[y].Description,
  22.                 field_172:getWorkflowJobs[y].WorkActivity,
  23.                 field_169: startDateFormat,
  24.                 field_170: dueDateFormat,
  25.                 field_180: String(beforeAddress),
  26.                 field_190: getWorkflowJobs[y].State,
  27.                 field_191: getWorkflowJobs[y].otherAssStaffIds,
  28.                 field_190: getWorkflowJobs[y].Type,
  29.  
  30.                 //CLIENT DETAILS
  31.                 field_174: getWorkflowJobs[y].ClientOrderNumber,
  32.                 field_175: getWorkflowJobs[y].ClientName,
  33.  
  34.                 //ASSIGNED STAFF
  35.                 field_178: getWorkflowJobs[y].assignedStaffIds,
  36.                 field_176: getWorkflowJobs[y].assignedStaffNames,
  37.                 //field_22: getWorkflowJobs[y].otherAssStaffIds,
  38.                 field_177: getWorkflowJobs[y].otherAssStaffNames,
  39.             }
  40.  
  41.             //If id is not found, update record with data
  42.             //if(found == false) {
  43.                 jobsArray.push(knack.createRecord(1, jobData))
  44.                 await knack.sleep(200);
  45.            //}
  46.  
  47.         }
  48.     }
  49.  
  50.     await Promise.all(jobsArray)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement