Google Sheets App Script improvements and restricted access

35.0 GBP

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

1. Project Title: Divi-Compatible Freight Calculator Plugin 2. Purpose: To create a WordPress plugin that seamlessly integrates a freight cost calculator (similar in function to https://globy.com/quick-logistics) into WordPress websites, with a particular focus on compatibility with the Divi theme. The plugin will allow website visitors to obtain freight cost estimates, with the stipulation that they must submit their contact details before the estimate is revealed. 3. Target Audience: Businesses involved in shipping and logistics. Website owners using the Divi theme who want to provide freight cost estimates to their customers. WordPress users seeking a customizable freight calculator plugin. 4. Functional Requirements: Freight Calculation: The plugin should provide a form-based interface for users to input shipment details, including: Origin and destination (country, city, zip code). Shipment type (e.g., parcel, pallet, container). Weight and dimensions. Cargo value. Service type (e.g., express, standard, economy). The calculation logic should, at a minimum, include the parameters mentioned above. The plugin should be designed in a way that the calculation logic can be easily modified or extended, to allow for future updates or customizations, without requiring core code changes. The plugin should calculate and display a freight cost estimate based on the user's input. The ability to add custom fields to the calculation form via the admin panel. The form should have a modern, user-friendly design, similar to the form on https://ship.freightos.com/, with clear sections and a logical flow. Contact Information Capture: Before displaying the freight cost estimate, the plugin must require the user to submit their contact information, including: Name. Email address. Phone number. Company name (optional). The contact information form should be clearly presented to the user. Admin Panel Configuration: The plugin should include an intuitive admin panel within WordPress. Customization Options: Base Rate Margin: A field to enter a percentage (%) that will be added to the base rate cost calculation. Styling: Font customization (family, size, color) for the calculator form and results display. Color customization for various elements (backgrounds, borders, buttons, text). Notification Settings: An option to enter an email address where notifications of calculator submissions (i.e., user contact details and their query) will be sent. An option to enter a phone number where submission notifications will be sent (e.g., via SMS, if supported by a third-party service). Form Fields: * Ability to add custom form fields. Divi Compatibility: The plugin should be designed to work seamlessly with the Divi theme. This could involve: Providing a Divi module for easy integration into Divi layouts. Ensuring that the plugin's output is styled in a way that is consistent with Divi's design principles. Providing clear instructions on how to integrate the calculator into Divi pages. Data Storage: All submissions (form data and contact details) should be stored in the WordPress database. The admin panel should provide a way to view and export the submission data (e.g., to a CSV file). User Experience: The calculator should be responsive and work well on all devices (desktops, tablets, and smartphones). The form should be user-friendly, with clear labels and instructions, and have a similar look and feel to the form on https://ship.freightos.com/. The process of entering shipment details and submitting contact information should be smooth and efficient. The plugin should provide clear feedback to the user, such as confirmation messages upon form submission. GDPR Compliance: The plugin must be built with GDPR compliance in mind. This includes: Providing a checkbox in the contact form for users to consent to data collection. Allowing users to request deletion of their data. Ensuring data is stored securely. Technical Requirements: The plugin should be developed using WordPress best practices. The code should be well-documented and easy to maintain. The plugin should be compatible with the latest version of WordPress and Divi. The plugin should be secure and protected against common vulnerabilities (e.g., SQL injection, cross-site scripting). The plugin should be optimized for performance. Deliverables: A complete, functional WordPress plugin. Installation and usage documentation. All necessary code files. Success Criteria: The plugin is easy to install and configure. The freight calculator functions accurately and provides reliable estimates. The contact information capture process is seamless and effective. The admin panel is intuitive and provides the necessary customization options. The plugin integrates seamlessly with the Divi theme. The plugin is responsive, user-friendly, and performs well.
100.0 GBP Technology & Programming peopleperhour Overseas
2 days ago
Looking to create a master referee and umpire app. This app will have the same core across all sports, but then each app will be downloaded separately with that sport's logic built in. We are looking at creating an app for football and futsal, rugby union and league, and tennis. I have attached a number of attachments, showing the overview of what we expect across all watches, then dive into each sport and what each app needs to have. We are looking to build an amazing app that covers these sports, which will have the same core but then each has its own sport logic. We need to do a deep review of all the laws of that sport to understand the role of a referee or umpire, what they record, and what logic and safeguards could we build in to help them. Amazing opportunity to build the world’s best referee platform. Goal Mobile App (Cross-Platform) • React Native 0.74+ (bare workflow) • Expo EAS (for OTA updates, builds, CI) • SQLite or WatermelonDB (offline-first storage) • react-native-ble-plx (for BLE communication) • react-native-biometrics (for Face ID / Touch ID / Android Biometrics) • On-device Whisper (PyTorch Mobile or TFLite) • SecureStore / Keychain / Android Keystore for sensitive data • Fastlane (App Store + Play Store deploy automation) ⸻ Apple Watch App • Native Swift + SwiftUI + WatchKit • WKExtendedRuntimeSession (for long-running match sessions) • CoreBluetooth (client-only BLE, sync with paired iPhone) • Local CoreData or file-based event logging • Background sync via paired iPhone ⸻ Wear OS (Android Watch) App • Native Kotlin + Jetpack Compose • ForegroundService (for match runtime) • BLE Peripheral + Central roles enabled • FusedLocationProviderClient for GPS • SQLite for offline event buffering • Android SpeechRecognizer (optional Whisper if hardware supports) ⸻ Other Smartwatches • No consistent BLE or dev support beyond Apple + Wear OS • Recommendation: Do not support Fitbit, Garmin, or proprietary platforms unless using their SDKs just for fitness/HR integration ⸻ Web Platform • Next.js 14 + React 18 • Tailwind CSS (utility-first responsive design) • Strapi or Directus (headless CMS for rule management, teams, config) • Firebase Auth or Clerk.dev (SSO, OAuth, email login) • Custom match review dashboard (React + Timeline for event/video sync) ⸻ Backend & Infrastructure • Node.js 20+ with NestJS (modular and scalable API framework) • PostgreSQL 16 (relational + geospatial queries) • Redis (caching, pub/sub, rate-limiting) • BullMQ or Temporal.io (match workflows, sync jobs) • WebSockets or Server-Sent Events (real-time updates) • Cloud provider: AWS or GCP • Infrastructure as Code: Terraform ⸻ AI & ML • OpenAI Whisper (on-device transcription, multilingual) • TensorFlow Lite or PyTorch Mobile (for gesture/foul detection) • MediaPipe or YOLOv7 (on-device or edge pose detection) • Firebase Remote Config or custom CDN for model delivery/versioning ⸻ BLE & Sync Logic • Buffered event logging (sync every 30–60 seconds) • BLE RSSI-aware retries and backoff • Apple Watch: BLE via iPhone bridge • Android Watch: direct BLE to phone or peer watch (if needed) ⸻ DevOps • GitHub Actions (CI/CD for web + backend) • Expo EAS Build + OTA • Docker for backend services • Firebase App Distribution for early testing • Sentry + OpenTelemetry (error tracking and performance) • Grafana + Prometheus (metrics and observability) ⸻ Cybersecurity & Compliance • Appdome (app shielding, anti-reverse engineering) • Firebase App Check + rate limiting via Redis • AES-256 encryption at rest, TLS 1.3 in transit • Keychain (iOS) / Keystore (Android) for biometrics + secrets • GDPR/CCPA-compliant privacy tools (OneTrust or Transcend) • Secrets management: Doppler or AWS Secrets Manager • Annual pen testing + SAST (Static Analysis) in CI ⸻ Optional / Enterprise Features • Match integrity scoring (GPS, BLE, behavior) • AI coach for referees (post-match performance feedback) • Video annotation + synced voice log review • Referee network platform (availability, scheduling, credentialing) • White-label capabilities for leagues or federations Apps creation Football referee app Futsal refeeee app Rugby union referee app Rugby league referee app Tennis umpire app. Full created, best platform and stack possible, fully tested, fully uploaded and a full website to go along with this for full marketing and dashboard for referee/umpires and all admin access to control and review issue
2000.0 GBP Technology & Programming peopleperhour Overseas
2 days ago