Programmatically Control Field's Value

Once you add Custom Code to the Event, you will see the code-editing window with the appropriate place to enter the new code.

1. Replace this line of code:

   # Write your own code here.

   with the following lines (Perl):

   if ($tasks->{user_id_assign_to}->GetValue() eq CCGetSession("UserLogin"))
   {
     $tasks->{task_name}->SetValue("<b><font color='blue'>" .
             $tasks->{task_name}->GetValue()."</font></b>");
   }

The following is how the above Perl code works:

if ($tasks->{user_id_assign_to}->GetValue() eq CCGetSession("UserLogin"))

This is an if condition that is true only if the value of the task_name field is equal to the login name of the employee that is currently logged into the system. The database field provides the value for the task_name field in the grid form. Once you login to the system, the program will recognize your tasks by comparing your login name to the emp_login value of the person that a task is assigned to. UserLogin is one of the session variables used by CodeCharge-generated programs, and it holds the Login name of the currently logged in user until the session expires.

Note:

The following are all default session variables created by CodeCharge Studio:

• UserID - the primary key field value of the logged in user
• UserLogin - login name of the user currently logged into the system
• GroupID - security level/group of the user currently logged into the system

This code is executed if the previous if condition is met. It modifies the value of the task_name field. The field value is replaced with its database value wrapped within HTML code that specifies the font color as blue, and adds HTML <b> tag to make the font bold as well. Additionally, notice that the code is object-oriented and you specify that you want to assign a value to the task_name field in the tasks grid. SetValue is a method of an object, which can be used to modify the object's value.

Next: Preview Tasks List Page