在Zoho CRM中通过Client Script/Custom Function对两个模块进行更改

Question

我试图在名为Tickets的模块中将日期复选框更改为今天的日期(Outbound)时，另一个名为commissions的模块将特定的委托状态更改为"approved"。我已经尝试了大量的代码，但我不确定它是否有效，我对编程完全陌生(持续2个月以上)，我是我工作中唯一的程序员，所以一切都来找我，我没有高级程序员来问问题或其他事情，网上关于Zoho的内容相当稀缺。

当日期框的出库日期为今天时，此代码应该将复选框的佣金状态更改为已批准。

Tickets_list = zoho.crm.searchRecords("Tickets","(Outbound:equals:zoho.currentdate)");
Commission = zoho.crm.searchRecords("Commissions","Commission_Status");
for each  Ticket in Tickets_list
{
zoho.crm.searchRecords("Commissions","Commission_Status");
Commission_Update_Map = Map();
Commission_Update_Map.put("Commission_Status","Approved");
Commission_Update_Response = zoho.crm.updateRecord("Commissions",Commission.getJSON("id"),Commission_Update_Map);
info Commission_Update_Response;
}
return "";

Answer 1

for each  Ticket in Tickets_list
{
/*create a lookup in commission module and whenever a ticket is created update the Commissoion module's Ticket lookup with Ticket ID*/

/*get ticket id*/
ticket_id = Ticket.getJSON("id");
/*searching the commission module with the linked ticket ID and the Commission status */
commission_search_map = Map();
commission_search_map.put("Commission_Status");
commission_search_map.put("Ticket", ticket_id);
commission_res = zoho.crm.searchRecords("Commissions",commission_search_map);
// update the records found with the values you want to update 
Commission_Update_Map = Map();
Commission_Update_Map.put("Commission_Status","Approved");
Commission_Update_Response = zoho.crm.updateRecord("Commissions",commission_res.getJSON("id"),Commission_Update_Map);
info Commission_Update_Response;
}