Project Tracking

Project Tracking

We would like to use Zoho Creator to help us track a project. I'll provide you with the details of the project. The good news, we do have a working solution up and running, it is just manual and a lot of room for error. 

 I have looked at Zoho Creator and it looks like it may be a good fit. I am very technical and would like to either assist with the project or at least have some training on Zoho Creator. Thank you for your time. 

Scanning Project We have 1000 boxes of paper that needs to be scanned. Each box has a unique number identifier for tracking. There is a set number of tasks that need to be completed, for each box, in a certain order. Based on the completion of a task, the next task is scheduled to begin. We use a series of online reports for our contractors to know what is in the "queue" that needs completed. Our contractor use an online checkout form to check out a box and a task so we do not have duplicate tasks completed for the same box. 
 We are currently using excel to track the project and Wufoo Online Forms to collect the data. From Wufoo, we export the data as a csv to excel. In excel, we use two main worksheets for the project and a few other worksheets to maintain consistency with the drop downs. We use a vlookup to pull fields between the sheets. We use a "Stats" worksheet to track details about the box and known variables at the start of the project.
 The most import part of the "Stats" worksheet is to track which boxes have been delivered and the delivery date. We use a "Compensation" worksheet to track the tasks completed by the contractors. Contractor use an online form to submit their task completion. Stats Known Variables about the Box Box # Client Project Location Additional Tracking on Stats: populated as tasks are completed Status - i.e. Delivered Delivered Date Destruction Date Number of Records Number of Pages Compensation Our contractors our paid by production ever other Friday. Each task has a set rate based on client, project, task and location. The rate can be a flat rate per task or a rate based on a variable, for example the number of records or pages in the box. The contractors get paid for completed tasks, except for a task for Review / Rescans or QA - Reviews. But we still need to track how many Review / Rescans that a contractor receives to see if they are doing a good job. The records and pages are not collected until the final QA. For example; a task is completed for Prep / Scan. If there were not any mistakes, a QA - Final task is submitted . If there were mistakes, then a QA - Reviews task is submitted. During QA - Final, the records and pages are collected and both tasks can be paid on the next pay date. Contractors need access to a report listing each of their completed tasks and how much they paid. They also need access to a report listing each of their direct deposits to date. Workflow - Reports Upon completion of a task, the box # is added to a "To Do" report for the next task. Each task can be completed by multiple contractors on a first come first serve basis.

 Upon completion of each task, the box # goes on an report: Scan / Prep Task to a QA Report QA - Reviews to a Review / Rescans Report Review / Rescans to a Review / Rescans Completed Report QA - Final to a Delivery Processing Report Delivery to a Delivered Report Task List Prep / Scan Prep Only Scan Only QA - Reviews QA - Final Delivered Rates There are different rates based on the Client, Project, Task and Location. Hendrick-HIS-Prep / Scan-CO - is .0225 per page / .10 record Hendrick-HIS-Prep/Scan-WA - is .0250 per page / .10 record Hendrick-HIS-QA - Reviews - CO - is .005 per page / .03 record Hendrick-HIS-QA - Reviews - WA - is .005 per page / .03 record Etc. - I have an excel file with the rest of the rates Client / Projects Hendrick / HIS Kadlec / Maher Kadlec / Kalichman Kadlec / Dramis etc. Contractors Multiple contractors that change frequently. We need to collect information about each contractor. Contractor Name SS # Address (street, city, state) Phone DD collected and added Added to the online schedule Added to basecamp Task Completion Form - completed by contractors when they complete a task. The data needs to be collected via a web form. Date Task Completed Name of the Task Name of Contractor Name of Scan Person (if QA - Final task) Prep Time Indexing Time Scan Time Reporting Client Invoicing - tracking We invoice the client by box. We need to track completed boxes that have been delivered but not invoiced. Destruction - tracking 30 days after the delivery date, we notify the client that their box is ready for destruction. If they choose to "delay" the box destruction, they are charged a monthly rate until they notify us or give us a date for destruction.


Budget : $1000 | Duration : Two Weeks

To leave a private message, please click the link for private response in post Action section.

      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

                            Writer is a powerful online word processor, designed for collaborative work.

                              Zoho CRM コンテンツ



                                ご検討中の方

                                  • Recent Topics

                                  • Pricing Strategies: #4 Counting on Discounts

                                    "Is there any chance I can get a little discount on this month's service?" Maya hears this almost every time at her fitness studio. She offers monthly subscription plans for various services, including yoga, strength training, wellness sessions, and personal
                                  • Introducing Query Workbench in Zoho CRM

                                    Hello everyone! We’re excited to announce the Query Workbench, a brand-new interface designed to improve developer experience of building Queries in Zoho CRM faster, simpler, and more intuitive. In the past, constructing queries required navigating across
                                  • Limitation with Dynamic Email Attachment Capture

                                    I've discovered a flaw in how Zoho Creator handles email attachments when using the Email-to-Form feature, and I'm hoping the Zoho team can address this in a future update. The Issue According to the official documentation, capturing email attachments
                                  • Add Customer in Books on Creator Form Submit Params

                                    Hi guys, Were integrating a creator app with books however what were doing is adding a books customer on submit of creator form.  We have some parameters but some fields aren't coping, All were seeing is the contact name in books,.  Any help of the params for this would be great. below is a sample of the script... response = zoho.books.createRecord("contacts", "XXXXXXXXX", { "contact_name" : input.Name, "address" : input.Email }); 
                                  • Weekly Tips: Protect Confidential Information with PGP in Zoho Mail

                                    We deal with confidential information almost every day, whether it is being sent out or received. Though emails sent using Zoho Mail are encrypted both during transit and at rest, attempts to access and steal your sensitive data are always a threat that
                                  • Suggestion : link KB with Accounts

                                    Hi Zoho teams.  I think it could be good to link KB articles with  : accounts in order to easily  find articles dedicated to some account specificities. I tried to use tags , but tags are free text with not easy way  to retrieve it directly from ticket or list article for one tag. Tickets : It would be a good way to measure usage of KB directly from ticket when we don't need to copy/paste KB in solution. And : Great Tool , keep going ! 
                                  • Drag and Drop in Creator Application

                                    Hi, I am in the planning phase of a new application and I would like to use 'Drag and Drop' in the user interface of my new Creator application that I am sketching out, but I don't seem to be able to find any reference that this is available to developers. In my instance I have table of entries and I would like to be able to allow users to move an entry to another table (much like you do in your own interface when creating a Pivot Table report. In addition, I would like the user to be able to re-order
                                  • Is there any way to integrate Zoho with Zapier?

                                    Is there any way to integrate Zoho with Zapier? I'd like to use it to create a workflow, sharing posts from our Wordpress website to all our channels.
                                  • Popular Articles Report

                                    From data to decisions: A deep dive into ticketing system reports Content management teams can use various metrics to assess the effectiveness of knowledge base articles, improve content quality, and ensure articles are regularly updated. Predefined article
                                  • Invoice Ref. Field

                                    Hello Team, Currently, the Invoice Ref. field is set to a Number type with a maximum limit of 9 digits. However, we often receive customer invoices that contain up to 12 digits. In some cases, the invoice reference includes not only numbers but also letters
                                  • 60 Days Into Zoho - Tiktok Branding Startup -7 Questions?!

                                    Wsp Everybody I co-own a TikTok Branding / Consulting Startup & have been using Zoho for the past 60 days - Am now looking to make our overall operations & processes more Efficient & Effective! Curious to know how others are using the platform & what's
                                  • Turning off the new UI

                                    Tried the new 'enhanced' UI and actively dislike it. Anyone know how to revert back?
                                  • XML format to import knowledgebase into Zoho Desk

                                    Hi, We just started to use Zoho Desk and want to import our knowledgebase from our old support system (Freshdesk) to Zoho Desk. Can anyone give us information about the format of xml file to import? There is no explanation on the related page.
                                  • Pushing Zoho People leave into Microsoft calendar: how to chose how "event" is shown (busy, free etc)

                                    Hi, how can I select how a "leave" event is pushed into Microsoft calendar? I want for leave "working elsewhere" to show as working elsewhere and NOT as busy.
                                  • Duplicate Accounts

                                    Hi There, I am looking for a solution, script, workflow or anything to solve an issue we have - in our customers section we have a rule that doesn't allow duplicates, however Zoho will allow customers with xxxxx and xxxxx PLC or LTD so effectivley we
                                  • Error with If formula

                                    I've got this super simple If formula, what is the reason for the error? If ( LEN(${Leads.Trial Slot Option}) == 3,'y','n') Syntax Error. Check the examples for any functions you're using to see if you formatted them correctly. Make sure your fields are
                                  • Announcing Multi-language Support in Zoho FSM

                                    Zoho FSM now speaks your language. The much-awaited multi-language support is now available in Zoho FSM. The following languages are supported in Zoho FSM: Dutch (Nederlands) English - United Kingdom English - United States French (français) French -
                                  • Creating multiple CRM leads from a Zoho Forms subform

                                    Hi all, We have a heavily used intake form that is used for new leads as a part of our intake. There is a subform that allows the lead to add additional team members, their titles and other basic info. That form submission creates a new Lead and the subform
                                  • Free webinar! Build smarter apps with Zoho Sign and Zoho Creator

                                    Hello, Bring the power of digital signatures to the apps you build in Zoho Creator! Connect Zoho Sign as a microservice and enable seamless e-signature workflows in your applications. This integration allows you to automate signing tasks using Deluge.
                                  • Restrict Addresses in Zoho Forms?

                                    In the address field, is there a way to restrict the addresses that auto populate (via Zoho Maps or Google Maps) to a specific state (I know it's possible with the country). Additionally, how often does the address in Zoho Maps get updated? Certain addresses
                                  • Weekly Tips: Secure your attachment downloads with Zoho Mail

                                    Safety is one of our main concerns, whether it’s about device security or online protection. We use tools like fingerprint scanners, facial recognition, and two-factor authentication to keep our devices and email accounts secure. We use methods like OTP
                                  • Resume Harvester: New Enhancements for Faster Sourcing

                                    We’re excited to share a set of enhancements to Resume Harvester that make sourcing faster and more flexible. These updates help you cut down on repetitive steps, manage auto searches more efficiently, and review candidate profiles with ease. Why we built
                                  • Looking for best practices to import data from SAP Business One (on-prem) into Zoho Analytics via Zoho DataPrep / Databridge — daily automated schedule

                                    Hi all, I’m using SAP Business One on-prem (SQL Server / or HANA — depending on DB backend) as our ERP. I want to build a pipeline that, every morning at 9:00 AM IST: pulls transactional data (invoices, customers, products, stock, etc.) from SAP B1, loads
                                  • Zoho One Unified Portal - Applications

                                    Hello, It is great to see the work on the New Unified Customer Portal. Thanks for that. The number of applications is limited though. It is now only around the Zoho Books ecosystem (Books, Expense...) and Zoho Social. = Are other applications planned
                                  • Marketing Tip #10: Start a customer loyalty program

                                    Winning a new customer is great, but keeping them coming back is even better. A loyalty program rewards repeat buyers with points, giving them more reasons to shop again. Over time, this builds trust and long-term relationships. Try this today: Set up
                                  • Zia Actions: AI-powered Workflow Automation for Faster and Smarter Execution

                                    Hello everyone, Updated on 12th Dec 2025 Zia actions for Workflow is available for Enterprise edition ONLY. These features are currently available in the following DCs: US, CA, EU, IN, and AU Email Auto reply and Content Generation are available as Early
                                  • Do Individual Forums within Categories, in Desk Community, Produce Their Own RSS Feed?

                                    Do Individual Forums within Categories, in Desk Community, Produce Their Own RSS Feed? If not, can anyone share a work-around that could help me get an RSS feed for individual category forums?
                                  • Incremental Migration Issue – Ticket Showing Resolution on Dec 9 Despite Urgent MX Cutover (Ticket ID: 152080262)

                                    I am experiencing an issue with Zoho Mail incremental migration from Rackspace. The initial full migration completed successfully, but the incremental migration for one mailbox failed immediately with the message: “User not exist” This appears to be a
                                  • Change Last Name to not required in Leads

                                    I would like to upload 500 target companies as leads but I don't yet have contact people for them. Can you enable the option for me to turn this requirement off to need a Second Name? Moderation update (10-Jun-23): As we explore potential solutions for
                                  • Resend Client Portal Invitation + View Email Delivery Status

                                    Hi Zoho Team, We hope you are doing well. We would like to request two important enhancements related to the Zoho Creator Client Portal invitation process. At the moment, when we add a user to the Client Portal, Zoho Creator automatically sends an invitation
                                  • Get user last login

                                    1. Is there a way to programmatically get the last user login to trigger certain workflows? 2. Is there a way to programmatically access the custom fields on a user's account?
                                  • Seeking Zoho Creator Expert (Delivery Management App / Logistics Ops) — Built & Deployed Before

                                    Hi everyone, We’re building a Delivery Management App (focused on delivery operations for now) using Zoho Creator. We’re looking for a Zoho Creator expert who has already developed and deployed a similar delivery/workflow system and can assist us with
                                  • Adding Multiple Files to a Zoho Vault Entry

                                    There is a old blog post talking about adding multiple file attachments to one Zoho Vault Secret: https://www.zoho.com/blog/vault/introducing-new-features-in-zoho-vault-powerful-password-sharing-wider-storing.html Is that still possible, I can see how
                                  • FNB South Africa Bank Feed

                                    I should've thought this wouldn't work. As suspect, Zoho claims to be able to pull bank feeds from First National Bank (South Africa), but fails everytime. I suppose Xero (or even Sage One) is the way to go? If they (miraculously) get it to work again,
                                  • Dropshipping Address - Does Not Show on Invoice Correctly

                                    When a dropshipping address is used for a customer, the correct ship-to address does not seem to show on the Invoice. It shows correctly on the Sales Order, Shipment Order, and Package, just not the Invoice. This is a problem, because the company being
                                  • Zoho unreliable

                                    Some mails are delivered, others not. How can I trust Zoho any more? Some friends get my e-mail, some don't. Same with receiving e-mails: Some I get, some not. If I use Google, everything works well. But Zoho?!!! How to solve this problem? I already reported this problem before, but didn't get any reply. Thanks, Kim
                                  • the custom domain forwards by default to the old career site / how to switch it off??

                                    dear friends, how to switch off the old version of the career site?? The set up custom domain forwards directly to the old site, so that I cant publish it... Any ideas? Thank you! KR, Victoria
                                  • Preserve Ticket Issue Mapping When Migrating from Jira to Zoho Projects

                                    Hello Zoho Projects Team, We hope you are doing well. We are currently exploring a full migration from Jira to Zoho Projects, and we identified a critical limitation during the migration process involving Zoho Desk integration. Current Situation: We use
                                  • Recording Shopify/Amazon fees in Zoho Books - Zoho Inventory

                                    We are currently flushing out the connections between Shopify/Amazon and Zoho Inventory. For other users of Zoho Books - Zoho Inventory, where and at what point do you record the merchant fees associated with theses channels? I have gotten mixed responses
                                  • Pre-fill webforms in Recruit

                                    I don't want to use the career site portal (as I have my own already), but I would like to direct users to the application forms for each role, from my website job pages. Is there a way to pre-fill fields in Recruit application forms, so that I only have
                                  • Next Page