cancel
Showing results for 
Search instead for 
Did you mean: 
yulia
Nintex Newbie

Workflow New record was created with old record ID and old record was erased

This work flow is querying data from another list to summarize total numbers in each month for different segment.

 

Workflow1.pngWorkflow2.png

Workflow3.png

Notes for workflow:

  • 1. Perform a list item query on US Safety Metrics Monthly Data Entry and store result in colRecordMonth.
  • 2. Remove duplicate values in colRecordMonth and store result in uniqueRecordMonth.
  • 3. Loop through each item in uniqueRecordMonth and store result in tempRecordMonth.
  • 5. Perform a list item query on US Safety Metrics Monthly Data Entry and store result in colRecordableCases.
  • 6. Set variable totRecordableCases to equal 0.
  • 7. Set variable totID to equal 0.
  • 8. Loop through each item in colRecordableCases and store result in tempRecordableCases.
  • 9. Do calculation:
    totRecordableCases = totRecordableCases + tempRecordableCases.
  • 10. Perform a list item query on US Safety Metrics Monthly Data Entry and store result in colDARTCases.
  • 11. Set variable totDARTCases to equal 0.
  • 12. Set variable totID to equal 0.
  • 13. Loop through each item in colDARTCases and store result in tempDARTCases.
  • 14. Do calculation:
    totDARTCases = totDARTCases + tempDARTCases.
  • 15. Perform a list item query on US Safety Metrics Monthly Data Entry and store result in colMan-hoursWorked.
  • 16. Set variable totMan-hoursWorked to equal 0.
  • 17. Set variable totID to equal 0.
  • 18. Loop through each item in colMan-hoursWorked and store result in tempMan-hoursWorked.
  • 19. Do calculation:
    totMan-hoursWorked = totMan-hoursWorked + tempMan-hoursWorked.
  • 20. Perform a list item query on US Safety Metrics Overview and store result in colID.
  • 21. Count the number of items in colID.
  • 22. Variable 'totID' equals '0'.
  • 23. Create Item in US Safety Metrics Overview.
  • 24. Variable 'totID' not equals '0'.
  • 25. Update an item in US Safety Metrics Overview.

 

 

First run result:

FirstRunResult.png

Second run result:

SecondRunResult.png

The second run result erase ID130 from ATS but add ID130 to AS as a duplicated record.

 

Can anyone help to find out where is incorrect on the workflow please?

 

Thanks,

Labels: (1)
0 Kudos
Reply