Google Sheets App Script improvements and restricted access

35.0 GBP

35.0 GBP peopleperhour Technology & Programming Overseas
18 hour 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

Project Overview: We are seeking an experienced developer with expertise in artificial intelligence, particularly in natural language processing (NLP), to create a custom Large Language Model (LLM). This LLM will parse client data from a structured data capture form and interpret notes provided by our admin team. Using this information, it will generate a legally compliant will based on predefined question and answer sets. The goal is to streamline and automate the will-drafting process, ensuring accuracy, compliance, and efficiency. Project Goals: Data Parsing: The LLM must accurately extract and interpret data from structured forms and unstructured admin notes. Predefined Logic: Use predefined question and answer sets to guide the will-drafting process, ensuring legal compliance and adherence to client instructions. Automated Will Drafting: Generate a complete, professional, and legally compliant will document tailored to the client’s unique inputs. Validation and Error Checking: Include a mechanism to flag incomplete or contradictory data for review. Scope of Work: Data Integration: Develop functionality to parse structured data from client capture forms (e.g., JSON, CSV, or other formats). Process unstructured admin notes and combine them with form data for context. LLM Development: Fine-tune an existing LLM (e.g., GPT, Claude) or build a custom model to interpret client inputs and map them to the predefined logic. Ensure the model respects UK legal terminology and practices for will drafting. Question and Answer Logic: Implement predefined Q&A logic to guide the model's output. Ensure flexibility to adapt to complex client scenarios, such as multiple beneficiaries, trusts, or guardianship provisions. Will Document Generation: Output a professionally formatted will document (Word/PDF). Include all necessary clauses, conditions, and legal provisions required for compliance in the UK. Error Handling: Build a system to flag missing or inconsistent data. Provide actionable feedback for admin to correct inputs before generating the final document. Testing and Validation: Thoroughly test the model to ensure it generates accurate and compliant wills. Validate the outputs against multiple scenarios to cover edge cases. Deployment: Integrate the LLM into our existing system or provide a standalone solution with an intuitive user interface. Deliverables: Fully functional LLM tailored to parse client data and draft compliant wills. Integration with existing client data capture forms and admin note workflows. Predefined Q&A logic implementation for automated drafting. Documentation for the system, including user guide and technical specifications.
500.0 GBP Technology & Programming peopleperhour Overseas
1 days ago