I'm working on my first Deluge function.  The intent is that it gets fired as part of a workflow whenever a certain field is updated for a lead record.  The function needs to write a record to a custom module, and also update the lead record based on certain criteria.

Here is the code.

2. Void Create_Score_Status_Audit (int LeadID,  int PersonScore,  string ScoreStatus )
3. {
4. NewScoreStatus=input.ScoreStatus;
5. OldScoreStatus=input.ScoreStatus;
6. CurrentPersonScore=input.PersonScore;
7. CurrentLeadID=input.LeadID.toString();
8. if((CurrentPersonScore  >  0)  &&  (CurrentPersonScore  <=  30))
9. {
10. NewScoreStatus="Cold Lead";
11. }
12. else if((CurrentPersonScore  >  30)  &&  (CurrentPersonScore  <=  60))
13. {
14. NewScoreStatus="Warm Lead";
15. }
16. else if((CurrentPersonScore  >  60)  &&  (CurrentPersonScore  <=  90))
17. {
18. NewScoreStatus="Very Warm Lead";
19. }
20. else if(CurrentPersonScore  >  90)
21. {
22. NewScoreStatus="Hot Lead";
23. }
24. if(NewScoreStatus  !=  OldScoreStatus)
25. {
26. ScoreStatusAuditMap=map();
27. ScoreStatusAuditMap.put("LeadID",CurrentLeadID);
28. ScoreStatusAuditMap.put("New Status",NewScoreStatus);
29. ScoreStatusAuditMap.put("Old Status",OldScoreStatus);
30. ScoreStatusAuditMap.put("Date of Change",zoho.currenttime);
31. updateResp = zoho.crm.create("CustomModule2",ScoreStatusAuditMap);
32. LeadUpdateMap=map();
33. LeadUpdateMap.put("Score Status",NewScoreStatus);
34. updateResp = zoho.crm.updateRecord("Leads",CurrentLeadID,LeadUpdateMap);
35. }
36. }

When the workflow triggers:

• The audit record gets written (with correct score status values for old and new), but with no lead (I have a lead lookup in the module)
• The lead doesn't get updated with the new Score Status value .

Cheers

Jo