Asking for timesheet period of timesheet for new user
Quote from Deepa Kapoor on November 28, 2025, 2:00 amWhen a new user clicks on the 'New Timesheet' button, the application by default creates a 'Weekly' timesheet for him. Instead of this, the timesheet should ask once before setting the default as 'Weekly'. General users can't change time sheet period and they have to work with 'Weekly' time sheet till it is changed by admin.
When a new user clicks on the 'New Timesheet' button, the application by default creates a 'Weekly' timesheet for him. Instead of this, the timesheet should ask once before setting the default as 'Weekly'. General users can't change time sheet period and they have to work with 'Weekly' time sheet till it is changed by admin.
Quote from Deepa Kapoor on November 28, 2025, 2:01 amIn order to do this effectively, what you need to do is to create a new role that you want user to be a member of. You can create this role using the OfficeClip Setup. Now go to the database and list the content of the roles table. Note the value of the role_id (which is a unique key).
Now go to the stored procedure InsInviteMemberSP (in file Sql\Queries\invitemember.sql) and at the bottom of the stored procedure add the following code:
Code:
EXECUTE GetUserPayrollInfoSP @userIdA more robust way of doing is to add a group property that will allow this selection by the administrator
In order to do this effectively, what you need to do is to create a new role that you want user to be a member of. You can create this role using the OfficeClip Setup. Now go to the database and list the content of the roles table. Note the value of the role_id (which is a unique key).
Now go to the stored procedure InsInviteMemberSP (in file Sql\Queries\invitemember.sql) and at the bottom of the stored procedure add the following code:
Code:
EXECUTE GetUserPayrollInfoSP @userId
A more robust way of doing is to add a group property that will allow this selection by the administrator
