
Google Sheets App Script improvements and restricted access
- or -
Post a project like this83
£35(approx. $47)
- Posted:
- Proposals: 2
- Remote
- #4316325
- Awarded
Description
Experience Level: Entry
Currently we a Google sheets document that has the following tabs
Task Manager - this is the tab where all task are listed for all employees.
TCM - Employee Alan
PTL - Employee Gameel
Bookkeeping - Employee Sarah
When a row on the Task Manager tab is completed with details, it automatically duplicates the row to all the other sheets.
Column C on all sheets is where the employee name is inputted. This column has a filter so the individual employee can filter the rows to only show the tasks that apply to their name.
When an employee makes changes to any cell in the row on the other tabs the edits are updated in the Task Manager tab also. Two way sync. From Task Manager tab to other tabs and back to Task Manager tab.
The filters are also re applied on edit in the App Script.
The App Script currently does all this but the syc is a bit slow. and we need to hide the tasks and tabs that do not apply to specific employees. Only specific shared employees can view the entire document.
This is what we require the sheet to do..
Update all tasks for all employees on Task Master tab
Based on employee name the task is duplicated on a specific extra tab.
Any edits sync to and from the Task Master tab
Any filters are remembered (if they are require)
Faster syncing
There could be a better way to achieve this by replacing the current App Script but we also require...
Shared access to specific employees gives access only to their specific tab - basically they cannot view Task Manager tab or any other tab or filter other than the tab they have been granted access to.
Also the dates need to be a day picker style, currently this does not filter over on all sheets when programmed on the Task Manager tab.
Current sheet and App Script attached if required
Task Manager - this is the tab where all task are listed for all employees.
TCM - Employee Alan
PTL - Employee Gameel
Bookkeeping - Employee Sarah
When a row on the Task Manager tab is completed with details, it automatically duplicates the row to all the other sheets.
Column C on all sheets is where the employee name is inputted. This column has a filter so the individual employee can filter the rows to only show the tasks that apply to their name.
When an employee makes changes to any cell in the row on the other tabs the edits are updated in the Task Manager tab also. Two way sync. From Task Manager tab to other tabs and back to Task Manager tab.
The filters are also re applied on edit in the App Script.
The App Script currently does all this but the syc is a bit slow. and we need to hide the tasks and tabs that do not apply to specific employees. Only specific shared employees can view the entire document.
This is what we require the sheet to do..
Update all tasks for all employees on Task Master tab
Based on employee name the task is duplicated on a specific extra tab.
Any edits sync to and from the Task Master tab
Any filters are remembered (if they are require)
Faster syncing
There could be a better way to achieve this by replacing the current App Script but we also require...
Shared access to specific employees gives access only to their specific tab - basically they cannot view Task Manager tab or any other tab or filter other than the tab they have been granted access to.
Also the dates need to be a day picker style, currently this does not filter over on all sheets when programmed on the Task Manager tab.
Current sheet and App Script attached if required

Alan C.
100% (4)Projects Completed
4
Freelancers worked with
4
Projects awarded
50%
Last project
5 Mar 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies