Taking Comment Timestamp and adding to a custom date field

Taking Comment Timestamp and adding to a custom date field

We are using Zoho Projects, including the comments field extensively, and I have had a request from one of our PMs as follows: They would like to be able to sort projects in their project list view, by 'latest comment'. i.e. they would like to see the project that was last commented on (NOT the last project to be generally updated) at the top of the list. I cannot see any native functionality that would provide this list sorting feature, so had an idea that we could use a workflow to say:

Each time a comment is added to a project, retrieve the comment timestamp, and write to a custom field ('Latest Comment Timestamp) on that project. That field would just be overwritten each time a new comment was added.

Does anyone have any advice on how I could do this? I am guessing I can use a workflow (which does have an option to be triggered by 'comment') and then execute a custom function. Advice on the script for that function anyone?


      • Sticky Posts

      • Tip of the Week: Task Sorting

        I believe that sorting of tasks helps managing the activities in a better fashion. You might second it too . By default, the tasks are listed chronologically. However, you can sort the tasks either by its title, start date, end date, priority, created by and percentage completion. All you have to do is, click the Task Sorting option and select the required criteria. Few points to be noted about task sorting: This option is available in the Classic View only (within My Tasks, Tasks & Milestones section).
      • Tip # 3 - Follow And Add Followers To Your Project Modules

        Besides owning effective managers and quick-witted employees, you need to have supportive followers for accomplishing your project goals. Accompanying this note, today, lets run through a quick and easy tip on  'How to follow and add followers to your project activities?' . Follow the project activities all by yourself -Follow to get real-time milestone updates Milestones are nothing but your project goals, which can ultimately uplift your projects' quality to the next level. Now, users in the portal
      • Tip of the Week: Task Dependency (Duration in Hours)

        I hope the tip on task dependency helped in understanding how it works in Zoho Projects. In a real-time, the successor task may or may not start on the predecessor's completion date. On either case, a project management tool should allow the users to set dependency between tasks. Ain't it? In Zoho Projects, the Task Duration in Hours option allows the users to set dependency between tasks that ends and starts on the same day. The Portal Owner and Admin role users can activate this option from the
      • Tip of the Week: Task Dependency

        Task Dependency - a feature that allows the users to establish dependency / linking between tasks within the project. Points to be noted with respect to this feature: Task Dependency can be set only from the Dependency View section within the Tasks & Milestones module Tasks setup with duration (start & end date) will only be displayed in the Dependency View The supported dependency model is Finish to Start Dependency can be established only between the tasks in the same project A task can be dependent
      • Tip of the Week: Drag and Drop option in Calendar

        As the thoughts flow in your mind, you plan the tasks, provide duration and assign users. While you go through the calendar later, you feel that a couple of tasks should needs to be postponed by a couple of days. Do you navigate to the Tasks & Milestones section and change the task duration? is the question I have for you. In case of YES, I would say that the task duration can be changed from the Calendar module itself. All you need to do is: Drag the task bar and Drop it on the required date. Note: