New Sugar Field – Work Log

sugarcrmdevelopers —  August 2, 2011 — 18 Comments

Have you ever had a text area field that has been updated so much and you want to know who updated it and when it was updated?  Well this SugarField will solve that problem.  What it does is store each comment in the field like it does for a normal textarea but it adds the current user name and date/time stamp above it so you can see who wrote it and what time.  This will allow you to follow the converation with out relying on the user to remember to put their name, date and time of their post.

Edit View:

Detail View:

This can be downloaded from SugarForge or you can Fork it on Github and help fix bugs or add new features.

18 responses to New Sugar Field – Work Log


    That’s awesome! This field type should definitely be part of the core product. Thoughts?


    How does the field handle users in different timezones? If I have someone in Hawaii entering a comment, does the person in New York see the date/time localized to NY time?


    I’ve just updated this Worklog to v1.0 with support to store the worklog posts as notes with gives support for the users timezones and if/when it was modified.


    Can you please give us more details on how to make this work in version 6.5.2?
    I followed the instructions here: 
    1. added a textarea field in the Cases module
    2. added the php code to /custom/Extension/modules/Cases/Ext/Vardefs/sugarfield_work_log_c.php
    3. positioned the field in the Edit layout view.
    But this new field is working just like any other textarea field. What am I missing?
    Thank you.


       Did you do a quick rebuild and repair as well?


        Thanks jmertic.
        Did a “Quick Repair and Rebuild”. Still did not work.


          Use this
          Although this does work the note is not saving the content into the description field in version 6.5.2


      Just a question, did you happen to install the zip file from the downloads tab on github?  Also what di dyou put in your php file?


        I downloaded the code from github and followed the instructions. I then added all 4 lines to the relevant php file in the Vardefs dir:
        $dictionary[‘Bug’][‘fields’][‘work_log’][‘type’] = ‘notesworklog’;
        $dictionary[‘Bug’][‘fields’][‘work_log’][‘dbType’] = ‘text’;
        $dictionary[‘Bug’][‘fields’][‘work_log’][‘type’] = ‘worklog’;
        $dictionary[‘Bug’][‘fields’][‘work_log’][‘dbType’] = ‘text’;
        Now, looking at the actual 4 lines, I have just changed to only these two lines now:
        Still not working.


          $dictionary[‘Cases’][‘fields’][‘work_log’][‘type’] = ‘notesworklog’;
          $dictionary[‘Cases’][‘fields’][‘work_log’][‘dbType’] = ‘text’;


        $dictionary[‘Cases’][‘fields’][‘work_log_c’][‘type’] = ‘notesworklog’;
        $dictionary[‘Cases’][‘fields’][‘work_log_c’][‘dbType’] = ‘text’;


        Hi Jon,
        Would appreciate your further help with this.


    So – I made few comments here a few weeks back about this feature – and I think it is great and is a huge missing piece of the Case module puzzle – but can the developer please respond as to whether or not this will work with v 6.5.x? Still no response and my comments were deleted.

    howard Jennings August 8, 2014 at 9:06 am

    does it work for on demand version and Sugar 7+


    The field is great, and it is working fine, but i don’t know why it isnt editable? Like if you get confused or get a typo, there is no way to fix it. Once you save thats it, you actually have to open a new one…


    Quick question..The worklog field is working fine, but i need to display on top the newest or the latest log created…any help?

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s