CodeX Scripts for Time Logs | Online Help | Zoho Projects

CodeX Scripts for Time Logs

CodeX Scripts in Zoho Projects are advanced conditional logic scripts that help enforce specific rules and validations. Users can control how and when time logs can be created, updated, blocked or transitioned.

Use Cases

Restrict Time Logs Based on Task Work Hours

Restrict users from logging time that exceeds the total work hours allocated to a task. The script also blocks logging for tasks with no work hours assigned.
Code
  1. function main() {
  2.     try {
  3.         let url = "https://projects.zoho.com";
  4.         let records = current.record;
  5.         let violations = [];

  7.         function parseToMinutes(s) {
  8.             if (!s) return 0;
  9.             let str = String(s);
  10.             if (str.indexOf(":") === -1) return (parseFloat(str) || 0) * 60;
  11.             let p = str.split(":");
  12.             return (parseInt(p[0], 10) || 0) * 60 + (parseInt(p[1], 10) || 0);
  13.         }

  15.         function formatMinutes(m) {
  16.             let h = Math.floor(m / 60);
  17.             let mins = m % 60;
  18.             return h + ":" + (mins < 10 ? "0" : "") + mins;
  19.         }

  21.         let taskLogs = [];
  22.         let projectTaskMap = {};

  24.         for (let i = 0; i < records.length; i++) {
  25.             let record = records[i];
  26.             let linked = record.module_detail;
  27.             if (!linked || linked.name !== "Task") continue;

  29.             taskLogs.push(record);
  30.             let projId = String(record.project_id);
  31.             if (!projectTaskMap[projId]) projectTaskMap[projId] = {};
  32.             projectTaskMap[projId][linked.id] = true;
  33.         }

  35.         if (taskLogs.length === 0) return;

  37.         let allTasks = [];
  38.         let projectIds = Object.keys(projectTaskMap);

  40.         if (projectIds.length === 1) {
  41.             let projId = projectIds[0];
  42.             let taskIds = Object.keys(projectTaskMap[projId]);
  43.             let filter = JSON.stringify({ criteria: [{ field_name: "id", criteria_condition: "contains", value: taskIds }], pattern: "1" });
  44.             let req = new HttpRequest();
  45.             req.url(`${url}/api/v3/portal/${current.org.zohoOrgId}/projects/${projId}/tasks?page=1&per_page=200&filter=${encodeURIComponent(filter)}`);
  46.             req.method("GET");
  47.             req.connection("zprojects");
  48.             allTasks = req.execute().asJson().statusMessage.responseText.tasks || [];
  49.         } else {
  50.             let uniqueMap = {};
  51.             for (let i = 0; i < projectIds.length; i++) {
  52.                 let ids = Object.keys(projectTaskMap[projectIds[i]]);
  53.                 for (let j = 0; j < ids.length; j++) uniqueMap[ids[j]] = true;
  54.             }
  55.             let filter = JSON.stringify({ criteria: [{ field_name: "id", criteria_condition: "contains", value: Object.keys(uniqueMap) }], pattern: "1" });
  56.             let req = new HttpRequest();
  57.             req.url(`${url}/api/v3/portal/${current.org.zohoOrgId}/tasks?page=1&per_page=200&filter=${encodeURIComponent(filter)}`);
  58.             req.method("GET");
  59.             req.connection("zprojects");
  60.             allTasks = req.execute().asJson().statusMessage.responseText.tasks || [];

  62.             let returnedIds = {};
  63.             for (let i = 0; i < allTasks.length; i++) returnedIds[String(allTasks[i].id)] = true;

  65.             let missingByProject = {};
  66.             for (let i = 0; i < projectIds.length; i++) {
  67.                 let projId = projectIds[i];
  68.                 let taskIds = Object.keys(projectTaskMap[projId]);
  69.                 for (let j = 0; j < taskIds.length; j++) {
  70.                     if (!returnedIds[taskIds[j]]) {
  71.                         if (!missingByProject[projId]) missingByProject[projId] = [];
  72.                         missingByProject[projId].push(taskIds[j]);
  73.                     }
  74.                 }
  75.             }

  77.             let missingProjIds = Object.keys(missingByProject);
  78.             for (let i = 0; i < missingProjIds.length && i < 2; i++) {
  79.                 let projId = missingProjIds[i];
  80.                 let mFilter = JSON.stringify({ criteria: [{ field_name: "id", criteria_condition: "contains", value: missingByProject[projId] }], pattern: "1" });
  81.                 let mReq = new HttpRequest();
  82.                 mReq.url(`${url}/api/v3/portal/${current.org.zohoOrgId}/projects/${projId}/tasks?page=1&per_page=200&filter=${encodeURIComponent(mFilter)}`);
  83.                 mReq.method("GET");
  84.                 mReq.connection("zprojects");
  85.                 let moreTasks = mReq.execute().asJson().statusMessage.responseText.tasks || [];
  86.                 for (let k = 0; k < moreTasks.length; k++) allTasks.push(moreTasks[k]);
  87.             }
  88.         }

  90.         let taskWorkMap = {};
  91.         let taskNameMap = {};
  92.         for (let i = 0; i < allTasks.length; i++) {
  93.             let task = allTasks[i];
  94.             let id = String(task.id);
  95.             taskNameMap[id] = task.name;
  96.             taskWorkMap[id] = {
  97.                 totalWork: parseToMinutes(task.owners_and_work.total_work),
  98.                 alreadyLogged: parseToMinutes(task.log_hours.total_hours)
  99.             };
  100.         }

  102.         let batchPerTask = {};
  103.         for (let i = 0; i < taskLogs.length; i++) {
  104.             let record = taskLogs[i];
  105.             let taskId = String(record.module_detail.id);
  106.             if (!batchPerTask[taskId]) batchPerTask[taskId] = { totalMinutes: 0, logIds: [] };
  107.             batchPerTask[taskId].totalMinutes += parseToMinutes(record.log_hour);
  108.             batchPerTask[taskId].logIds.push(record.id);
  109.         }

  111.         let batchTaskIds = Object.keys(batchPerTask);
  112.         for (let i = 0; i < batchTaskIds.length; i++) {
  113.             let taskId = batchTaskIds[i];
  114.             let info = taskWorkMap[taskId];
  115.             let batch = batchPerTask[taskId];
  116.             if (!info) continue;

  118.             if (info.totalWork === 0) {
  119.                 violations.push({ taskId: taskId, taskName: taskNameMap[taskId], totalWork: "00:00", reason: "No work hours allocated" });
  120.                 continue;
  121.             }

  123.             let totalAfterLog = info.alreadyLogged + batch.totalMinutes;
  124.             if (totalAfterLog > info.totalWork) {
  125.                 violations.push({ taskId: taskId, taskName: taskNameMap[taskId], totalWork: formatMinutes(info.totalWork), alreadyLogged: formatMinutes(info.alreadyLogged), newBatch: formatMinutes(batch.totalMinutes), reason: "Would exceed work hours" });
  126.             }
  127.         }

  129.         if (violations.length > 0) {
  130.             throw new ScriptError(JSON.stringify({ violations: violations }));
  131.         }
  132.     } catch (err) {
  133.         throw new ScriptError(err);
  134.     }
  135. }

 Restrict Time Logs for Unassigned Tasks or Issues

Allow time logging only for tasks or issues that have at least one owner assigned. Logs against unassigned work items are rejected.
Code
  1. function main() {
  2.     try {
  3.         let url = "https://projects.zoho.com";
  4.         let records = current.record;
  5.         let violations = [];

  7.         let taskLogs = [];
  8.         let projectTaskMap = {};

  10.         for (let i = 0; i < records.length; i++) {
  11.             let record = records[i];
  12.             let linked = record.module_detail;
  13.             if (!linked || linked.name !== "Task") continue;

  15.             taskLogs.push(record);
  16.             let projId = String(record.project_id);
  17.             if (!projectTaskMap[projId]) projectTaskMap[projId] = {};
  18.             projectTaskMap[projId][linked.id] = true;
  19.         }

  21.         if (taskLogs.length === 0) return;

  23.         let allTasks = [];
  24.         let projectIds = Object.keys(projectTaskMap);

  26.         if (projectIds.length === 1) {
  27.             let projId = projectIds[0];
  28.             let taskIds = Object.keys(projectTaskMap[projId]);
  29.             let filter = JSON.stringify({ criteria: [{ field_name: "id", criteria_condition: "contains", value: taskIds }], pattern: "1" });
  30.             let req = new HttpRequest();
  31.             req.url(`${url}/api/v3/portal/${current.org.zohoOrgId}/projects/${projId}/tasks?page=1&per_page=200&filter=${encodeURIComponent(filter)}`);
  32.             req.method("GET");
  33.             req.connection("zprojects");
  34.             allTasks = req.execute().asJson().statusMessage.responseText.tasks || [];
  35.         } else {
  36.             let uniqueMap = {};
  37.             for (let i = 0; i < projectIds.length; i++) {
  38.                 let ids = Object.keys(projectTaskMap[projectIds[i]]);
  39.                 for (let j = 0; j < ids.length; j++) uniqueMap[ids[j]] = true;
  40.             }
  41.             let filter = JSON.stringify({ criteria: [{ field_name: "id", criteria_condition: "contains", value: Object.keys(uniqueMap) }], pattern: "1" });
  42.             let req = new HttpRequest();
  43.             req.url(`${url}/api/v3/portal/${current.org.zohoOrgId}/tasks?page=1&per_page=200&filter=${encodeURIComponent(filter)}`);
  44.             req.method("GET");
  45.             req.connection("zprojects");
  46.             allTasks = req.execute().asJson().statusMessage.responseText.tasks || [];

  48.             let returnedIds = {};
  49.             for (let i = 0; i < allTasks.length; i++) returnedIds[String(allTasks[i].id)] = true;

  51.             let missingByProject = {};
  52.             for (let i = 0; i < projectIds.length; i++) {
  53.                 let projId = projectIds[i];
  54.                 let taskIds = Object.keys(projectTaskMap[projId]);
  55.                 for (let j = 0; j < taskIds.length; j++) {
  56.                     if (!returnedIds[taskIds[j]]) {
  57.                         if (!missingByProject[projId]) missingByProject[projId] = [];
  58.                         missingByProject[projId].push(taskIds[j]);
  59.                     }
  60.                 }
  61.             }

  63.             let missingProjIds = Object.keys(missingByProject);
  64.             for (let i = 0; i < missingProjIds.length && i < 2; i++) {
  65.                 let projId = missingProjIds[i];
  66.                 let mFilter = JSON.stringify({ criteria: [{ field_name: "id", criteria_condition: "contains", value: missingByProject[projId] }], pattern: "1" });
  67.                 let mReq = new HttpRequest();
  68.                 mReq.url(`${url}/api/v3/portal/${current.org.zohoOrgId}/projects/${projId}/tasks?page=1&per_page=200&filter=${encodeURIComponent(mFilter)}`);
  69.                 mReq.method("GET");
  70.                 mReq.connection("zprojects");
  71.                 let moreTasks = mReq.execute().asJson().statusMessage.responseText.tasks || [];
  72.                 for (let k = 0; k < moreTasks.length; k++) allTasks.push(moreTasks[k]);
  73.             }
  74.         }

  76.         let taskOwnerMap = {};
  77.         for (let i = 0; i < allTasks.length; i++) {
  78.             let task = allTasks[i];
  79.             let owners = task.owners_and_work.owners || [];
  80.             let hasReal = false;
  81.             for (let j = 0; j < owners.length; j++) {
  82.                 if (owners[j].zuid && owners[j].zuid !== 0) { hasReal = true; break; }
  83.             }
  84.             taskOwnerMap[String(task.id)] = hasReal;
  85.         }

  87.         for (let i = 0; i < taskLogs.length; i++) {
  88.             let record = taskLogs[i];
  89.             let taskId = String(record.module_detail.id);
  90.             if (taskOwnerMap[taskId] === undefined) continue;

  92.             if (!taskOwnerMap[taskId]) {
  93.                 violations.push({ logId: record.id, taskId: taskId, user: record.user ? record.user.name : "Unknown", reason: "Task is unassigned" });
  94.             }
  95.         }

  97.         if (violations.length > 0) {
  98.             throw new ScriptError(JSON.stringify({ violations: violations }));
  99.         }
  100.     } catch (err) {
  101.         throw new ScriptError(err);
  102.     }
  103. }

 Restrict Weekend Time Logs

Restrict users from logging time on Saturdays and Sundays by validating the selected log date.
Code
  1. function main() {
  2.     try {
  3.         let records = current.record;
  4.         let violations = [];

  6.         for (let i = 0; i < records.length; i++) {
  7.             let record = records[i];
  8.             let logDate = record.log_date;
  9.             if (!logDate) continue;

  11.             let parts = logDate.split("-");
  12.             let date = new Date(parseInt(parts[0]), parseInt(parts[1]) - 1, parseInt(parts[2]));
  13.             let day = date.getDay();

  15.             if (day === 0 || day === 6) {
  16.                 violations.push({ logId: record.id, logDate: logDate, user: record.user ? record.user.name : "Unknown", day: day === 0 ? "Sunday" : "Saturday", reason: "Cannot log time on weekends" });
  17.             }
  18.         }

  20.         if (violations.length > 0) {
  21.             throw new ScriptError(JSON.stringify({ violations: violations }));
  22.         }
  23.     } catch (err) {
  24.         throw new ScriptError(err);
  25.     }
  26. }

Restrict Time Logs on Holidays 

Block time entries on organization holidays by retrieving holiday information from Zoho People and validating the selected log date.
Code
  1. function main() {
  2.     try {
  3.         let peopleUrl = "https://people.zoho.com";
  4.         let records = current.record;
  5.         let violations = [];

  7.         let monthMap = {"Jan":"01","Feb":"02","Mar":"03","Apr":"04","May":"05","Jun":"06","Jul":"07","Aug":"08","Sep":"09","Oct":"10","Nov":"11","Dec":"12"};

  9.         function peopleDateToISO(d) {
  10.             let p = d.split("-");
  11.             if (p.length !== 3) return d;
  12.             return p[2] + "-" + (monthMap[p[1]] || "01") + "-" + (p[0].length === 1 ? "0" + p[0] : p[0]);
  13.         }

  15.         let years = {};
  16.         for (let i = 0; i < records.length; i++) {
  17.             if (records[i].log_date) years[records[i].log_date.substring(0, 4)] = true;
  18.         }

  20.         let holidaySet = {};
  21.         let holidayNames = {};
  22.         let yearKeys = Object.keys(years);
  23.         for (let y = 0; y < yearKeys.length; y++) {
  24.             let year = yearKeys[y];
  25.             let req = new HttpRequest();
  26.             req.url(`${peopleUrl}/people/api/leave/v2/holidays/get?from=01-Jan-${year}&to=31-Dec-${year}`);
  27.             req.method("GET");
  28.             req.connection("zpeople");
  29.             let holidays = req.execute().asJson().statusMessage.responseText.data || [];

  31.             for (let i = 0; i < holidays.length; i++) {
  32.                 let isoDate = peopleDateToISO(holidays[i].Date);
  33.                 holidaySet[isoDate] = true;
  34.                 holidayNames[isoDate] = holidays[i].Name;
  35.             }
  36.         }

  38.         for (let i = 0; i < records.length; i++) {
  39.             let record = records[i];
  40.             let logDate = record.log_date;
  41.             if (!logDate) continue;

  43.             if (holidaySet[logDate]) {
  44.                 violations.push({ logId: record.id, logDate: logDate, user: record.user ? record.user.name : "Unknown", holiday: holidayNames[logDate], reason: logDate + " is a holiday (" + holidayNames[logDate] + ")" });
  45.             }
  46.         }

  48.         if (violations.length > 0) {
  49.             throw new ScriptError(JSON.stringify({ violations: violations }));
  50.         }
  51.     } catch (err) {
  52.         throw new ScriptError(err);
  53.     }
  54. }

 Restrict Time Logs During Leave or Time Off

Restrict users from logging time on days when they are on approved leave or time off, using leave records from Zoho People.
Code
  1. function main() {
  2.     try {
  3.         let peopleUrl = "https://people.zoho.com";
  4.         let records = current.record;
  5.         let violations = [];

  7.         let monthMap = {"Jan":"01","Feb":"02","Mar":"03","Apr":"04","May":"05","Jun":"06","Jul":"07","Aug":"08","Sep":"09","Oct":"10","Nov":"11","Dec":"12"};

  9.         function peopleDateToISO(d) {
  10.             let p = d.split("-");
  11.             if (p.length !== 3) return d;
  12.             return p[2] + "-" + (monthMap[p[1]] || "01") + "-" + (p[0].length === 1 ? "0" + p[0] : p[0]);
  13.         }

  15.         function isoToPeopleDate(d) {
  16.             let p = d.split("-");
  17.             let m = ["Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"];
  18.             return p[2] + "-" + m[parseInt(p[1]) - 1] + "-" + p[0];
  19.         }

  21.         let minDate = null;
  22.         let maxDate = null;
  23.         let uniqueUsers = {};

  25.         for (let i = 0; i < records.length; i++) {
  26.             let record = records[i];
  27.             let logDate = record.log_date;
  28.             if (logDate) {
  29.                 if (!minDate || logDate < minDate) minDate = logDate;
  30.                 if (!maxDate || logDate > maxDate) maxDate = logDate;
  31.             }
  32.             if (record.user && record.user.zuid) {
  33.                 uniqueUsers[String(record.user.zuid)] = true;
  34.             }
  35.         }

  37.         if (!minDate) return;

  39.         let req = new HttpRequest();
  40.         req.url(`${peopleUrl}/api/v2/leavetracker/leaves/records?from=${encodeURIComponent(isoToPeopleDate(minDate))}&to=${encodeURIComponent(isoToPeopleDate(maxDate))}`);
  41.         req.method("GET");
  42.         req.connection("zpeople");
  43.         let leaveRecordsMap = req.execute().asJson().statusMessage.responseText.records || {};
  44.         let leaveIds = Object.keys(leaveRecordsMap);

  46.         let userLeaveDayMap = {};
  47.         for (let i = 0; i < leaveIds.length; i++) {
  48.             let lr = leaveRecordsMap[leaveIds[i]];
  49.             let zuid = String(lr.ZUID);
  50.             if (!uniqueUsers[zuid]) continue;

  52.             let days = lr.Days || {};
  53.             let dayKeys = Object.keys(days);
  54.             for (let d = 0; d < dayKeys.length; d++) {
  55.                 let leaveCount = parseFloat(days[dayKeys[d]].LeaveCount) || 0;
  56.                 if (leaveCount <= 0) continue;
  57.                 let isoDate = peopleDateToISO(dayKeys[d]);
  58.                 if (!userLeaveDayMap[zuid]) userLeaveDayMap[zuid] = {};
  59.                 userLeaveDayMap[zuid][isoDate] = { leaveType: lr.Leavetype || "", status: lr.ApprovalStatus || "" };
  60.             }
  61.         }

  63.         for (let i = 0; i < records.length; i++) {
  64.             let record = records[i];
  65.             let logDate = record.log_date;
  66.             if (!logDate) continue;
  67.             let recordZuid = record.user ? String(record.user.zuid) : "";
  68.             if (!recordZuid) continue;

  70.             let userDays = userLeaveDayMap[recordZuid];
  71.             if (!userDays) continue;
  72.             let dayLeave = userDays[logDate];
  73.             if (!dayLeave) continue;

  75.             violations.push({ logId: record.id, logDate: logDate, user: record.user.name, leaveType: dayLeave.leaveType, status: dayLeave.status, reason: "User is on " + dayLeave.leaveType + " (" + dayLeave.status + ")" });
  76.         }

  78.         if (violations.length > 0) {
  79.             throw new ScriptError(JSON.stringify({ violations: violations }));
  80.         }
  81.     } catch (err) {
  82.         throw new ScriptError(err);
  83.     }
  84. }

 Allow Time Logs Only for Task or Issue Owners

Ensure that only users assigned as owners of a task or issue can log time against it. Unassigned tasks and unauthorized users are blocked.
Code
  1. function main() {
  2.     try {

  4.         let url = "https://projects.zoho.com";
  5.         let records = current.record;
  6.         let violations = [];

  8.         let taskLogs = [];
  9.         let projectTaskMap = {};

  11.         for (let i = 0; i < records.length; i++) {
  12.             let record = records[i];
  13.             let linked = record.module_detail;
  14.             if (!linked || linked.name === "general") continue;

  16.             taskLogs.push(record);
  17.             let projId = String(record.project_id);
  18.             if (!projectTaskMap[projId]) projectTaskMap[projId] = {};
  19.             projectTaskMap[projId][linked.id] = true;
  20.         }

  22.         if (taskLogs.length === 0) return;

  24.         let allTasks = [];
  25.         let projectIds = Object.keys(projectTaskMap);

  27.         if (projectIds.length === 1) {
  28.             let projId = projectIds[0];
  29.             let taskIds = Object.keys(projectTaskMap[projId]);
  30.             let filter = JSON.stringify({ criteria: [{ field_name: "id", criteria_condition: "contains", value: taskIds }], pattern: "1" });
  31.             let req = new HttpRequest();
  32.             req.url(`${url}/api/v3/portal/${current.org.zohoOrgId}/projects/${projId}/tasks?page=1&per_page=200&filter=${encodeURIComponent(filter)}`);
  33.             req.method("GET");
  34.             req.connection("zprojects");
  35.             allTasks = req.execute().asJson().statusMessage.responseText.tasks || [];
  36.         } else {
  37.             let uniqueMap = {};
  38.             for (let i = 0; i < projectIds.length; i++) {
  39.                 let ids = Object.keys(projectTaskMap[projectIds[i]]);
  40.                 for (let j = 0; j < ids.length; j++) uniqueMap[ids[j]] = true;
  41.             }
  42.             let filter = JSON.stringify({ criteria: [{ field_name: "id", criteria_condition: "contains", value: Object.keys(uniqueMap) }], pattern: "1" });
  43.             let req = new HttpRequest();
  44.             req.url(`${url}/api/v3/portal/${current.org.zohoOrgId}/tasks?page=1&per_page=200&filter=${encodeURIComponent(filter)}`);
  45.             req.method("GET");
  46.             req.connection("zprojects");
  47.             allTasks = req.execute().asJson().statusMessage.responseText.tasks || [];

  49.             let returnedIds = {};
  50.             for (let i = 0; i < allTasks.length; i++) returnedIds[String(allTasks[i].id)] = true;

  52.             let missingByProject = {};
  53.             for (let i = 0; i < projectIds.length; i++) {
  54.                 let projId = projectIds[i];
  55.                 let taskIds = Object.keys(projectTaskMap[projId]);
  56.                 for (let j = 0; j < taskIds.length; j++) {
  57.                     if (!returnedIds[taskIds[j]]) {
  58.                         if (!missingByProject[projId]) missingByProject[projId] = [];
  59.                         missingByProject[projId].push(taskIds[j]);
  60.                     }
  61.                 }
  62.             }

  64.             let missingProjIds = Object.keys(missingByProject);
  65.             for (let i = 0; i < missingProjIds.length && i < 2; i++) {
  66.                 let projId = missingProjIds[i];
  67.                 let mFilter = JSON.stringify({ criteria: [{ field_name: "id", criteria_condition: "contains", value: missingByProject[projId] }], pattern: "1" });
  68.                 let mReq = new HttpRequest();
  69.                 mReq.url(`${url}/api/v3/portal/${current.org.zohoOrgId}/projects/${projId}/tasks?page=1&per_page=200&filter=${encodeURIComponent(mFilter)}`);
  70.                 mReq.method("GET");
  71.                 mReq.connection("zprojects");
  72.                 let moreTasks = mReq.execute().asJson().statusMessage.responseText.tasks || [];
  73.                 for (let k = 0; k < moreTasks.length; k++) allTasks.push(moreTasks[k]);
  74.             }
  75.         }

  77.         let taskOwnerMap = {};
  78.         for (let i = 0; i < allTasks.length; i++) {
  79.             let task = allTasks[i];
  80.             let owners = task.owners_and_work.owners || [];
  81.             let realZpuids = [];
  82.             for (let j = 0; j < owners.length; j++) {
  83.                 if (owners[j].zuid && owners[j].zuid !== 0) realZpuids.push(String(owners[j].zpuid));
  84.             }
  85.             taskOwnerMap[String(task.id)] = realZpuids;
  86.         }

  88.         for (let i = 0; i < taskLogs.length; i++) {
  89.             let record = taskLogs[i];
  90.             let taskId = String(record.module_detail.id);
  91.             let userZpuid = record.user ? String(record.user.id) : String(current.user.id);
  92.             let ownerZpuids = taskOwnerMap[taskId];

  94.             if (!ownerZpuids) continue;

  96.             if (ownerZpuids.length === 0) {
  97.                 violations.push({ logId: record.id, taskId: taskId, user: record.user ? record.user.name : "Unknown", reason: "Task is unassigned" });
  98.             } else if (ownerZpuids.indexOf(userZpuid) === -1) {
  99.                 violations.push({ logId: record.id, taskId: taskId, user: record.user ? record.user.name : "Unknown", reason: "User is not the task owner" });
  100.             }
  101.         }

  103.         if (violations.length > 0) {
  104.             throw new ScriptError(JSON.stringify({ violations: violations }));
  105.         }
  106.     } catch (err) {
  107.         throw new ScriptError(err);
  108.     }
  109. }

Restrict Time Logs for Tasks in Review

Restrict users from logging time against tasks whose status is In Review, ensuring work is logged only during active execution stages.
Code
  1. function main() {
  2.     try {
  3.         
  4.         let url = " https://projects.zoho.com";
  5.         let records = current.record;
  6.         let violations = [];

  8.         let taskLogs = [];
  9.         let projectTaskMap = {};

  11.         for (let i = 0; i < records.length; i++) {
  12.             let record = records[i];
  13.             let linked = record.module_detail;
  14.             if (!linked || linked.name !== "Task") continue;

  16.             taskLogs.push(record);
  17.             let projId = String(record.project_id);
  18.             if (!projectTaskMap[projId]) projectTaskMap[projId] = {};
  19.             projectTaskMap[projId][linked.id] = true;
  20.         }

  22.         if (taskLogs.length === 0) return;

  24.         let allTasks = [];
  25.         let projectIds = Object.keys(projectTaskMap);

  27.         if (projectIds.length === 1) {
  28.             let projId = projectIds[0];
  29.             let taskIds = Object.keys(projectTaskMap[projId]);
  30.             let filter = JSON.stringify({ criteria: [{ field_name: "id", criteria_condition: "contains", value: taskIds }], pattern: "1" });
  31.             let req = new HttpRequest();
  32.             req.url(`${url}/api/v3/portal/${current.org.zohoOrgId}/projects/${projId}/tasks?page=1&per_page=200&filter=${encodeURIComponent(filter)}`);
  33.             req.method("GET");
  34.             req.connection("zprojects");
  35.             allTasks = req.execute().asJson().statusMessage.responseText.tasks || [];
  36.         } else {
  37.             let uniqueMap = {};
  38.             for (let i = 0; i < projectIds.length; i++) {
  39.                 let ids = Object.keys(projectTaskMap[projectIds[i]]);
  40.                 for (let j = 0; j < ids.length; j++) uniqueMap[ids[j]] = true;
  41.             }
  42.             let filter = JSON.stringify({ criteria: [{ field_name: "id", criteria_condition: "contains", value: Object.keys(uniqueMap) }], pattern: "1" });
  43.             let req = new HttpRequest();
  44.             req.url(`${url}/api/v3/portal/${current.org.zohoOrgId}/tasks?page=1&per_page=200&filter=${encodeURIComponent(filter)}`);
  45.             req.method("GET");
  46.             req.connection("zprojects");
  47.             allTasks = req.execute().asJson().statusMessage.responseText.tasks || [];

  49.             let returnedIds = {};
  50.             for (let i = 0; i < allTasks.length; i++) returnedIds[String(allTasks[i].id)] = true;

  52.             let missingByProject = {};
  53.             for (let i = 0; i < projectIds.length; i++) {
  54.                 let projId = projectIds[i];
  55.                 let taskIds = Object.keys(projectTaskMap[projId]);
  56.                 for (let j = 0; j < taskIds.length; j++) {
  57.                     if (!returnedIds[taskIds[j]]) {
  58.                         if (!missingByProject[projId]) missingByProject[projId] = [];
  59.                         missingByProject[projId].push(taskIds[j]);
  60.                     }
  61.                 }
  62.             }

  64.             let missingProjIds = Object.keys(missingByProject);
  65.             for (let i = 0; i < missingProjIds.length && i < 2; i++) {
  66.                 let projId = missingProjIds[i];
  67.                 let mFilter = JSON.stringify({ criteria: [{ field_name: "id", criteria_condition: "contains", value: missingByProject[projId] }], pattern: "1" });
  68.                 let mReq = new HttpRequest();
  69.                 mReq.url(`${url}/api/v3/portal/${current.org.zohoOrgId}/projects/${projId}/tasks?page=1&per_page=200&filter=${encodeURIComponent(mFilter)}`);
  70.                 mReq.method("GET");
  71.                 mReq.connection("zprojects");
  72.                 let moreTasks = mReq.execute().asJson().statusMessage.responseText.tasks || [];
  73.                 for (let k = 0; k < moreTasks.length; k++) allTasks.push(moreTasks[k]);
  74.             }
  75.         }

  77.         let taskStatusMap = {};
  78.         let taskNameMap = {};
  79.         for (let i = 0; i < allTasks.length; i++) {
  80.             let task = allTasks[i];
  81.             let id = String(task.id);
  82.             taskStatusMap[id] = task.status;
  83.             taskNameMap[id] = task.name;
  84.         }

  86.         for (let i = 0; i < taskLogs.length; i++) {
  87.             let record = taskLogs[i];
  88.             let taskId = String(record.module_detail.id);
  89.             let status = taskStatusMap[taskId];
  90.             if (!status) continue;

  92.             if (status.name === 'In Review') {
  93.                 violations.push({ logId: record.id, taskId: taskId, taskName: taskNameMap[taskId], status: status.name, reason: "Task is in review" });
  94.             }
  95.         }

  97.         if (violations.length > 0) {
  98.             throw new ScriptError(JSON.stringify({ violations: violations }));
  99.         }
  100.     } catch (err) {
  101.         throw new ScriptError(err);
  102.     }
  103. }

 Restrict General Time Logs

Block general time logs that are not linked to a task or issue, ensuring every time entry is associated with a work item.
Code
  1. function main() {
  2.     try {
  3.         let records = current.record;
  4.         let violations = [];

  6.         for (let i = 0; i < records.length; i++) {
  7.             let record = records[i];
  8.             let linked = record.module_detail;

  10.             if (linked && linked.name === "general") {
  11.                 violations.push({ logId: record.id, user: record.user ? record.user.name : "Unknown", reason: "General timelogs not allowed. Must link to a Task or Issue." });
  12.             }
  13.         }

  15.         if (violations.length > 0) {
  16.             throw new ScriptError(JSON.stringify({ violations: violations }));
  17.         }
  18.     } catch (err) {
  19.         throw new ScriptError(err);
  20.     }
  21. }

 Restrict Time Logs to the Current Day

Allow time logging only for the current date. The script blocks both backdated and future-dated time entries.
Code
  1. function main() {
  2.     try {
  3.         let records = current.record;
  4.         let violations = [];

  6.         let now = new Date();
  7.         let todayStr = now.getFullYear() + "-" +
  8.             (now.getMonth() + 1 < 10 ? "0" : "") + (now.getMonth() + 1) + "-" +
  9.             (now.getDate() < 10 ? "0" : "") + now.getDate();

  11.         for (let i = 0; i < records.length; i++) {
  12.             let record = records[i];
  13.             let logDate = record.log_date;
  14.             if (!logDate) continue;

  16.             if (logDate !== todayStr) {
  17.                 violations.push({ logId: record.id, logDate: logDate, today: todayStr, user: record.user ? record.user.name : "Unknown", reason: logDate < todayStr ? "Cannot log for past dates" : "Cannot log for future dates" });
  18.             }
  19.         }

  21.         if (violations.length > 0) {
  22.             throw new ScriptError(JSON.stringify({ violations: violations }));
  23.         }
  24.     } catch (err) {
  25.         throw new ScriptError(err);
  26.     }
  27. }

 Restrict Time Logs for Tasks

Restrict users from logging time against tasks. This can be used in scenarios where time logging is permitted only for issues or general logs.
Code
  1. function main() {
  2.     try {
  3.         let records = current.record;
  4.         let violations = [];

  6.         for (let i = 0; i < records.length; i++) {
  7.             let record = records[i];
  8.             let linked = record.module_detail;

  10.             if (linked && linked.name === "Task") {
  11.                 violations.push({ logId: record.id, user: record.user ? record.user.name : "Unknown", reason: "Logging time against Tasks is not allowed" });
  12.             }
  13.         }

  15.         if (violations.length > 0) {
  16.             throw new ScriptError(JSON.stringify({ violations: violations }));
  17.         }
  18.     } catch (err) {
  19.         throw new ScriptError(err);
  20.     }
  21. }