Hi,

I have a Deluge script, which works perfectly. We have a custom field in the Campaigns module called Total_Raised which looks at the Donation_Amount field in the custom module, Donations. The idea is to sum up the total of all donation amounts.

However, it stops at 200 records, the Zoho default cut-off, as I understand it. Is there any way of being able to search through more than 200 records, possibly up to 2000? My existing working code is:

2. void automation.UpdateDonationTotal(Int campaignId)
3. {
4.     if(campaignId != null)
5.     {
6.         // Fetch related donations for the given Campaign ID
7.         donations = zoho.crm.getRelatedRecords("Donations", "Campaigns", campaignId, 1, 200);
8. 
   
9.         // Initialize the total amount
10.         totalRaised = 0.0;
11. 
    
12.         // Iterate over each donation and sum the Donation Amount
13.         for each donation in donations
14.         {
15.             if(donation.get("Donation_Amount") != null)
16.             {
17.                 totalRaised = totalRaised + donation.get("Donation_Amount");
18.             }
19.         }
20. 
    
21.         // Fetch the current Campaign record to compare Total_Raised
22.         campaignRecord = zoho.crm.getRecordById("Campaigns", campaignId);
23.         existingTotal = campaignRecord.get("Total_Raised");
24. 
    
25.         // Debugging log
26.         info "Campaign ID: " + campaignId;
27.         info "Total Raised (calculated): " + totalRaised;
28.         info "Existing Total Raised: " + existingTotal;
29. 
    
30.         // Update only if the calculated value differs from the existing value
31.         if(existingTotal != totalRaised)
32.         {
33.             // Prepare data for updating the Campaign's Total Raised field
34.             updateMap = Map();
35.             updateMap.put("Total_Raised", totalRaised);
36. 
    
37.             // Update the Campaign record
38.             response = zoho.crm.updateRecord("Campaigns", campaignId, updateMap);
39. 
    
40.             if(response.get("code") == "SUCCESS")
41.             {
42.                 info "Successfully updated Total Raised for Campaign ID: " + campaignId;
43.             }
44.             else
45.             {
46.                 info "Failed to update Total Raised for Campaign ID: " + campaignId + ". Response: " + response;
47.             }
48.         }
49.         else
50.         {
51.             info "No update needed. Total Raised is already correct.";
52.         }
53.     }
54.     else
55.     {
56.         info "Invalid Campaign ID: " + campaignId;
57.     }
58. }