Add an Hidden "Assigned By" Field to Auto-Update New Tasks

You've previously used the Before Show event to display the name of the person who assigns the task. However, Label fields are not updateable by nature, therefore even though the employee's name is displayed on the page, it is not written to the database. Since we want the database to record the name or id of the person who submits a task, we will need to add programming logic to accomplish this.

1. Add a Hidden field to your page from the Forms tab of the Toolbox.

   This field type isn't visible in the browser, but will be used to store a value and update the database.

2. Configure the new field by setting its properties as follows:
   • Name: assigned_by - the name of the newly added Hidden field.

     This can be any name you choose.

   • Control Source: user_id_assign_by - the database field/column that will be used to retrieve field's value and will be updated with the new value, if it changes.
   • Data Type: Integer - the type of the value bound to the control source. Our user/employee id's are numeric.
   • Default: DBUtility.UserId - default value for this field if it is empty.

     DBUtility.UserId is a CodeCharge property that retrieves the user id of the user that is currently logged in into the system. This way you can simply specify that you want to record the current user's id in the user_id_assign_by field for each new task that is being submitted.