Google Sheets App Script improvements and restricted access

35.0 GBP

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

need it doing today the groups on freshdesk is set Set Up Freshdesk Integration for 4 Shops via Slack/Teams (Group-Based Routing & Ticket Management) Job Description: We are a company with four retail shops, each using a separate Slack or Microsoft Teams channel for communication. Our head office uses Freshdesk to manage and respond to internal support requests. We’re seeking an experienced freelancer to configure a Freshdesk integration that connects all four shop channels to our single Freshdesk account, ensuring that tickets are routed and managed efficiently. Key Requirements: Integrate Freshdesk with four different Slack or Teams channels, each representing a different shop Use one Freshdesk account, configured with four separate groups (Shop A, Shop B, Shop C, Shop D) Configure routing so that: Tickets created in Shop A’s channel go to Group A Tickets from Shop B’s channel go to Group B And so on for Shops C and D Assign one user per shop who: Can create, view, and update tickets from their own shop’s Slack/Teams channel Can follow the full ticket thread and updates within their platform Ensure the head office team in Freshdesk can view, manage, and respond to all tickets centrally Project Scope: Set up and test integration across all 4 Slack/Teams channels Ensure end users at each shop can easily submit tickets Enable designated shop users to manage tickets and see responses directly within Slack/Teams Set up Freshdesk automation rules or workflows to assign tickets by channel to the correct group Provide documentation or a short training walkthrough for shop users and head office Requirements: Strong experience integrating Freshdesk with Slack and/or Microsoft Teams Knowledge of Freshdesk groups, ticket assignment rules, and agent permissions Ability to route tickets based on source channel and notify the correct managing user Experience with automation tools (Zapier, Power Automate, or similar) or Freshdesk APIs if needed Nice to Have: Ability to recommend efficient workflows for retail teams and head office Experience building or managing custom Slack/Teams bots Familiarity with Freshdesk reports and visibility settings for centralized tracking Deliverables: Functional ticketing system across all 4 shops via Slack/Teams Channel-based routing to appropriate Freshdesk groups Ticket visibility and update capabilities for one shop manager per location Central management capability for head office via Freshdesk Setup documentation or recorded walkthrough
50.0 GBP Technology & Programming peopleperhour Overseas
1 days ago