Problem with multiple 'for each' statements in workflow

Problem with multiple 'for each' statements in workflow

New to ZC and almost a novice at coding. I'm mostly getting along fine learning Deluge through the documentation and googling, but I'm completely stuck on this one. At line 22 I get the error 'Variable Actual_Work_Time does not exist in Activity_log'. I've tried every way I can think of to specify that 'Actual_Work_Time' is in the form Projects (not the subform Activity_log) but it won't accept any.

Forms/fields (only for as far as the problematic line):
  1. Projects (fields Total_Project_Time_Actual)
    1. subform Tasks (fields Live_for_Logging, Actual_Work_Time)
      1. subform Activity_log (fields Start_Logging, End_Logging, Total_Time)
The problematic line is supposed to sum the Actual_Work_Time fields in the Tasks subform and input the result in the Total_Project_Time_Actual field of the Projects form.

The code works except for line 22 (it runs fine if I comment the line out).

It runs on successful form submission of the Activity_Log form (the variant capitalisation is correct - it's Activity_Log as a form but Activity_log when it's a subform of Tasks).

Any help greatly appreciated!

  2. task = Tasks[ID = input.Task_ID];
  3. project = Projects[ID = task.Project];
  4. if(Start_Logging = "Yes")
  5. {
  6. input.Start_Logging = "No";
  7. openURL("#Script.page.close","same window");
  8. openURL("#Page:Timekeeping","same window");
  9. }
  10. if(End_Logging = "Yes")
  11. {
  12. task.Live_for_Logging="No";
  13. totaltask = 0;
  14. for each  r in Activity_log[Task_ID == task.ID]
  15. {
  16. totaltask = totaltask + r.Total_Time;
  17. }
  18. task.Actual_Work_Time=totaltask;
  19. totalproject = 0;
  20. for each  r in Tasks[Project == project.ID]
  21. {
  22. totalproject = totalproject + r.Actual_Work_Time;
  23. }
  24. project.Total_Project_Time_Actual=totalproject;
  25. task.Actual_Fee_Per_Hour=task.Actual_Fee / task.Actual_Work_Time;
  26. taskvalueactual = task.Actual_Fee;
  27. tasktimeactual = task.Actual_Work_Time;
  28. for each  r in Activity_log
  29. {
  30. logvalueactual = taskvalueactual / tasktimeactual * input.Total_Time;
  31. }
  32. input.Log_Value_Actual_Fee = logvalueactual;
  33. taskvalueest = task.Estimated_Fee;
  34. tasktimeest = task.Estimated_Work_Time;
  35. if(task.Estimated_Fee = 0 || task.Estimated_Fee = null || task.Estimated_Work_Time = 0 || task.Estimated_Work_Time = null)
  36. {
  37. //do nothing
  38. }
  39. else
  40. {
  41. for each  r in Activity_log
  42. {
  43. logvalueest = taskvalueest / tasktimeest * input.Total_Time;
  44. }
  45. }
  46. input.Log_Value_Estimated_Fee = logvalueest;
  47. input.End_Logging = "No";
  48. openURL("#Script.page.close","same window");
  49. openURL("#Page:Timekeeping","same window");
  50. }