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. }

        Create. Review. Publish.

        Write, edit, collaborate on, and publish documents to different content management platforms.

        Get Started Now


          Access your files securely from anywhere

            Zoho CRM Training Programs

            Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

            Zoho CRM Training
              Redefine the way you work
              with Zoho Workplace
              Start your free trial

                Zoho DataPrep Personalized Demo

                If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

                Zoho CRM Training

                  Create, share, and deliver

                  beautiful slides from anywhere.

                  Get Started Now


                    Zoho Sign now offers specialized one-on-one training for both administrators and developers.

                    BOOK A SESSION







                                Quick LinksWorkflow AutomationData Collection
                                Web FormsEnterpriseOnline Data Collection Tool
                                Embeddable FormsBankingBegin Data Collection
                                Interactive FormsWorkplaceData Collection App
                                CRM FormsCustomer ServiceAccessible Forms
                                Digital FormsMarketingForms for Small Business
                                HTML FormsEducationForms for Enterprise
                                Contact FormsE-commerceForms for any business
                                Lead Generation FormsHealthcareForms for Startups
                                Wordpress FormsCustomer onboardingForms for Small Business
                                No Code FormsConstructionRSVP tool for holidays
                                Free FormsTravelFeatures for Order Forms
                                Prefill FormsNon-Profit

                                Intake FormsLegal
                                		Mobile App
                                Form DesignerHR
                                		Mobile Forms
                                Card FormsFoodOffline Forms
                                Assign FormsPhotographyMobile Forms Features
                                Translate FormsReal EstateKiosk in Mobile Forms
                                Electronic Forms
                                Drag & drop form builder

                                Notification Emails for FormsAlternativesSecurity & Compliance
                                Holiday FormsGoogle Forms alternative GDPR
                                Form to PDFJotform alternativeHIPAA Forms
                                Email FormsFormstack alternativeEncrypted Forms

                                		Wufoo alternativeSecure Forms

                                		TypeformWCAG

                                  Zoho FSM Video Tutorials

                                    Workforce
                                    Mobile App
                                    Job Scenarios
                                    Scheduled Maintenance
                                    FSM × Desk
                                    FSM × Books & Invoice
                                    FSM × WhatsApp

                                    MCP Tool Guide MCP Changelog
                                        What's new
                                        Blogs
                                        Community
                                        Zia
                                        API resources
                                        Pricing
                                        Integrations
                                        Town Hall
                                        Custom Apps


                                        All-in-one knowledge management and training platform for your employees and customers.

                                                    What's new
                                                    Help Guide
                                                    Blogs
                                                    Forums
                                                    Webinars
                                                    API
                                                    Developers
                                                    Build Extensions

                                                  Create. Review. Publish.

                                                  Write, edit, collaborate on, and publish documents to different content management platforms.

                                                  Get Started Now







                                                                Zoho Pagesense Resources

                                                                    You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.


                                                                      Zoho Survey Resources
                                                                        Features
                                                                        Survey Templates
                                                                        Integrations
                                                                        Community
                                                                        iOS Mobile Surveys
                                                                        Pricing
                                                                        Android Mobile Surveys
                                                                        Insurvey Blogs
                                                                        Insight Blogs
                                                                        Tips & Tricks


                                                                        Manage your brands on social media
                                                                        Access Zoho Social


                                                                          • Desk Community Learning Series


                                                                          • Digest


                                                                          • Functions


                                                                          • Meetups


                                                                          • Kbase


                                                                          • Resources


                                                                          • Glossary


                                                                          • Desk Marketplace


                                                                          • MVP Corner


                                                                          • Word of the Day


                                                                          • Ask the Experts


                                                                            Zoho Sheet Resources

                                                                             

                                                                                Zoho Forms Resources


                                                                                  Features

                                                                                  Form Templates

                                                                                  Customers

                                                                                  Mobile Forms

                                                                                  Pricing

                                                                                  Integrations

                                                                                  Blogs

                                                                                  Ebooks

                                                                                  Tips & Tricks

                                                                                  Community

                                                                                  Terms of Use

                                                                                  Secure your business
                                                                                  communication with Zoho Mail
                                                                                  Get started


                                                                                  Mail on the move with
                                                                                  Zoho Mail mobile application
                                                                                  Go Mobile

                                                                                    Stay on top of your schedule
                                                                                    at all times
                                                                                    Get started


                                                                                    Carry your calendar with you
                                                                                    Anytime, anywhere
                                                                                    Get started


                                                                                      Latest Announcements


                                                                                          Zoho Sign Resources

                                                                                            What's new
                                                                                            Help Guide
                                                                                            Solutions Guide
                                                                                            API
                                                                                            Blogs
                                                                                            FAQ's
                                                                                            Legal Guide
                                                                                            Forums
                                                                                            Webinars

                                                                                            Sign, Paperless!

                                                                                            Sign and send business documents on the go!

                                                                                            Get Started Now


                                                                                                Zoho SalesIQ Resources


                                                                                                    Zoho TeamInbox Resources



                                                                                                          Latest Feature Updates
                                                                                                            Zoho DataPrep Resources


                                                                                                              Zoho DataPrep Demo

                                                                                                              Get a personalized demo or POC

                                                                                                              REGISTER NOW


                                                                                                                Design. Discuss. Deliver.

                                                                                                                Create visually engaging stories with Zoho Show.

                                                                                                                Get Started Now






                                                                                                                          Latest Feature Updates


                                                                                                                                  Latest Feature Updates

                                                                                                                                    • Related Articles

                                                                                                                                    • Working with CodeX Scripts

                                                                                                                                      CodeX Scripts allows users to define custom logic that runs automatically based on events in the default modules such as when a project, task and time log is created, updated, or deleted. These scripts help enforce validations, restrict actions, or ...

                                                                                                                                    • CodeX Scripts - Intro

                                                                                                                                      CodeX Scripts let you define custom logic that runs automatically when users interact with default modules such as tasks, projects, time logs. It allows users to control how the module behaves based on certain conditions. Users can write scripts ...

                                                                                                                                    • CodeX Scripts for Projects

                                                                                                                                      CodeX Scripts in Zoho Projects are advanced conditional logic scripts that help enforce specific rules and validations. Users can control how and when a project can be created, edited, or transitioned. This ensures better compliance and process ...

                                                                                                                                    • CodeX Scripts for Tasks

                                                                                                                                      CodeX Scripts in Zoho Projects are advanced conditional logic scripts that help enforce specific rules and validations. Users can control how and when tasks can be created, edited, or transitioned. This ensures better compliance and process ...

                                                                                                                                    • Time Logs List View

                                                                                                                                      Projects involve multiple activities by a number of people. These activities are time-sensitive and must be monitored to keep costs and timelines on track. Time logs are used to track the amount of time spent on various activities. Users can log time ...
                                                                                                                                      Bootcamp
                                                                                                                                      Community
                                                                                                                                      Pricing
                                                                                                                                      Webinars
                                                                                                                                      What's New
                                                                                                                                      Integrations
                                                                                                                                      Contact Support
                                                                                                                                      Contact Sales
                                                                                                                                      Wherever you are is as good as
                                                                                                                                      your workplace
                                                                                                                                      Workplace on mobile

                                                                                                                                        Resources

                                                                                                                                        Videos

                                                                                                                                        Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                                        eBooks

                                                                                                                                        Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                                        Webinars

                                                                                                                                        Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                                        CRM Tips

                                                                                                                                        Make the most of Zoho CRM with these useful tips.



                                                                                                                                          Zoho Show Resources