Google Sheets App Script improvements and restricted access

35.0 GBP

35.0 GBP peopleperhour Technology & Programming Overseas
1 days ago

Description

Currently we a Google sheets document that has the following tabsTask Manager - this is the tab where all task are listed for all employees.TCM - Employee AlanPTL - Employee GameelBookkeeping - 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 tabBased on employee name the task is duplicated on a specific extra tab.Any edits sync to and from the Task Master tabAny 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

关注公众号,不定期副业成功案例分享
Follow WeChat

Success story sharing

Want to stay one step ahead of the latest teleworks?

Subscribe Now

Similar Teleworks

We are seeking a skilled **Website Developer** to create a platform connecting clients with independent lawyers. The site will include subscription features,Mpesa payment integration, and tools for seamless online consultations. --- ### **Responsibilities** 1. Design and develop a responsive, user-friendly website for desktop and mobile. 2. Create registration systems for lawyers and clients with tailored dashboards. 3. Build subscription management for lawyers, including billing and invoicing. 4. Integrate **MPESA API** for secure payments and support other payment options. 5. Enable clients to request on-demand legal services and make payments. 6. Integrate **Google Meet** and **Zoom** APIs for online consultations. 7. Implement secure communication and document-sharing features. 8. Develop an admin dashboard for managing users, payments, and analytics. 9. Ensure scalable architecture to accommodate growth and feature expansion. 10. Implement secure login, authentication, and data protection protocols. 11. Build intuitive scheduling tools with calendar syncing for consultations. 12. Provide real-time notifications for requests, updates, and payments. 13. Develop a rating and review system for lawyers. 14. Ensure platform compliance with legal and data privacy regulations. 15. Deliver documentation for APIs, subscription features, and payment systems. --- Examples include; Here’s a list of example websites you can share with potential developers for inspiration when building your legal services platform: - **UpCounsel** - [www.upcounsel.com](https://www.upcounsel.com) - **LawTrades** - [www.lawtrades.com](https://www.lawtrades.com) - **LegalZoom** - [www.legalzoom.com](https://www.legalzoom.com) - **Rocket Lawyer** - [www.rocketlawyer.com](https://www.rocketlawyer.com) - **Avvo** - [www.avvo.com](https://www.avvo.com) - **JustAnswer Legal** - [www.justanswer.com/legal](https://www.justanswer.com/legal) - **Clio** - [www.clio.com](https://www.clio.com) - **Priori Legal** - [www.priorilegal.com](https://www.priorilegal.com) - **LawDepot** - [www.lawdepot.com](https://www.lawdepot.com) These platforms demonstrate different approaches to connecting clients with legal services, offering features like on-demand legal advice, document creation, lawyer directories, and client-lawyer collaboration tools. This role requires expertise in full-stack development,UX, API integration, and secure, scalable architecture. If you’re up for the challenge, apply today!
148.0 USD Technology & Programming peopleperhour Overseas
8 hour ago