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

                                  • Need more details on API Usage Dashboard

                                    Hi Team, We have implemented Zoho Expense for a client and has done some integrations with well known third party ERP via api. Recently we have noticed a huge spike in the API consumption. But we couldn't get the root cause for the same. I accept there
                                  • Rendering PDF to view on page

                                    My company upload lots of PDF files onto Zoho. But every time we open it, it downloads the file instead of viewing it on the web page. Does Zoho allow uploaded PDF files to be rendered to view on web page yet? I've been trying to use <embed> or <object> but it cannot be loaded.  (similar thread: https://help.zoho.com/portal/community/topic/how-to-open-a-pdf-file-of-a-view-in-preview-mode)
                                  • Dynamically Fetching Lookup Field Display Value

                                    I have an audit trail form, Audit_Changes, that tracks old vs new values across different forms. For lookup fields, the old/new value is the ID, but I also need the display value. What's a best practice for dynamically fetching the display value of the
                                  • Ability to Create New Items When Zoho Trident is Minimized via tray or taskbar icon

                                    Allow users to create new items (emails, calendar events, tasks, etc.) directly from the system tray icon or by right clicking the task bar icon, even when the window is minimized or not actively running in the foreground. This enables quick access to
                                  • I can not see Undeliverable emails from my Mass Email Leads activity in CRM

                                    I am sending email templates and I can not see the Undeliverables? I only receive the "Out of Office" replies and any manual replies from the lead. Can you please let me know where the Undeliverable emails are sent so I can use the information to clean up the database?
                                  • Select Zoho Contacts as Meeting Participants in Zoho Cliq

                                    Hello Zoho Cliq Team, We hope you're doing well. We would like to request an enhancement to the meeting scheduling functionality in Zoho Cliq. Current Limitation: When scheduling a meeting in Zoho Cliq, participants can only be selected from: Organization
                                  • Ability to Select External Users from Participants List When Scheduling Meetings

                                    Hello Zoho Cliq Team, We hope you're doing well. We would like to request an enhancement to the meeting scheduling experience in Zoho Cliq. Current Limitation when scheduling a meeting in Zoho Cliq: External users can be selected from the list only under
                                  • Kaizen #212 - Map Dependency Fields in Zoho CRM using APIs

                                    Hi Everyone!! Welcome back to another week of Kaizen series! Over the past few weeks, we have been addressing your questions and feedback shared through our Kaizen 200th feedback form. Thank you for your continued engagement and thoughtful queries. We
                                  • Outdated state in mexico

                                    Hello Zoho team, the drop down to add the state for customers, when they introduce their state in mexico has a city named “Distrito Federal” that name changed many years ago to “ciudad de mexico”. could you please update this so my clients can find the
                                  • Is anyone using Zoho Flow with airtable?

                                    I need to build a flow that collects data from airtable and uses some of that data to create folders and files in google drive. I have fully function version of this in zapier and want to migrate to zoho. I am trying to perform a very basic fetch from
                                  • SOME FEATURES ARE NOT IN THE ZOHO SHEET IN COMPARISION TO ZOHO SHEET

                                    TO ZOHO sir/maam with due to respect i want to say that i am using ZOHO tool which is spreadsheet i want to say that some features are not there in zoho sheet as comparison to MS EXCEL like advance filter and other Features which should be there in ZOHO
                                  • AI in Zoho Workplace: A Sneak Peek into What’s Coming!

                                    Hello everyone, We’re super excited to share something we’ve been working on and we want you to be part of it! You may have seen our announcement blog post introducing a major evolution in how AI works within Zoho Workplace. Want to be among the first
                                  • Display Client Name in Zoho Creator Client Portal Dashboard

                                    Hello Zoho Creator Team, We hope you are doing well. Zoho Creator recently introduced the option to set a client’s display name in the Client Portal settings, which is very helpful for providing a personalized portal experience. However, there is currently
                                  • Meet Canvas' Grid component: Your easiest way to build responsive record templates

                                    Visual design can be exciting—until you're knee-deep in the details. Whether it's aligning text boxes to prevent overlaps, fixing negative space, or simply making sure the right data stands out, just ironing out inconsistencies takes a lot of moving parts.
                                  • Best way to share/download presentation files in Zoho without losing formatting?

                                    Hello Zoho Community, I often work with PPT/PDF files in Zoho Docs and share them with colleagues. While PDFs usually give a direct download option, I’ve noticed that PPT/PPTX files sometimes only open in the viewer without a clear download link. Is there
                                  • Workflow Failure - Notifications

                                    Good afternoon, I have just experienced an error whereby a Workflow failed, for a reason currently unknown. The problem is that one of my users had to flag this manually (thankfully he's very thorough) and this otherwise would have flown under the radar.
                                  • Introducing Bin Locations In Zoho Inventory

                                    Hello users, We are excited to let you know that your wait for the Bin Locations feature has now come to an end! Yes, you heard us right! We are here to introduce the much-awaited Bin Locations now in Zoho Inventory. But before we dive into the feature
                                  • Error "Invalid client task found corresponding properties" only when triggered from workflow ?

                                    Hi All, I am facing an error message I never encountered previously: Error in executing On Add - On Load script Error in executing thisapp.get_all_projects_api_call function. Line:(2) Error in executing thisapp.getAccessTokenFromRefreshToken function.
                                  • How to interpret Campaign report statistics - definitions/explanation

                                    I am trying to make sure I understand the Campaign report correctly Do you have a list of definitions for: Delivered - it has reached the recipient's inbox Campaign reach - is this the number that have opened the campaign email? Unique Opens Clicks/Open
                                  • Feature request - pin or flag note

                                    Hi, It would be great if you could either pin or flag one or more notes so that they remain visible when there are a bunch of notes and some get hidden in the list. Sometimes you are looking for a particular name that gets lost in a bunch of less important
                                  • Schedule a Call by Date and Time when a specific lead status is selected

                                    Hi Wanting to create a workflow where a call can be scheduled by date & time when a specific lead status is selected. Can only currently set the date by Due Date - Trigger Date - Plus 'x' day(s) Thanks
                                  • Zoho CRM's Copy Customization functionality now works across DCs, for customized accounts, and more

                                    Availability This feature is available in Standard, Professional, Enterprise, and Ultimate editions. These changes have been rolled out to all users in all DCs. For more information, please refer to these help documents: Overview | Instructions Hello
                                  • How can I bold text on Zoho Forms submit buttons?

                                    In the old theme builder, I could bold the text on a form's submit button. With the new theme builder, I can only change the text of the header or fields in the form, and not the button itself.
                                  • Hiding Pre-defined Views

                                    You can enhance Zoho with custom views - but you cannot hide the pre-defined views. Most users focus on 4 or 5 views. Right now for EVERY user EVERY time they want to move to one of their 4 or 5 views - they have to scroll down past a long list of pre-defined views - we don't use ANY of the pre-defined views. Adding the feature to allow a predefined view to be hidden completely or only visible to certain users would be a big improvement in usability for Zoho CRM. This feature is already available
                                  • Rich-text fields in Zoho CRM

                                    Hello everyone, We're thrilled to announce an important enhancement that will significantly enhance the readability and formatting capabilities of your information: rich text options for multi-line fields. With this update, you can now enjoy a more versatile
                                  • [Integration Edition] Deluge Learning Series – Third-Party Integrations with Deluge | October 2025

                                    We’re excited to continue this three-month edition of the Deluge Learning Series: Session 1 – Integrating Zoho Apps with Deluge Using Built-In Integration Tasks Session 2 – Integrating Zoho Apps with Deluge Using invokeURL and invokeAPI Session 3 – Third-Party
                                  • Feature Request: Tag, Search, and Report on Individual Private Comments

                                    Zoho Desk Team, First, I want to say that we are extensive users of Zoho Desk and it is a core part of our support operations. We rely heavily on the private comments feature for internal communication, knowledge sharing, and maintaining a clear history
                                  • Zoho CRM Community Digest - August 2025 | Part 2

                                    Hello Everyone! Here's a quick round-up of handy tips, clever workarounds, and product updates from late August. Product Updates: Meeting Enhancements in Zoho CRM! Track whether a meeting is online, in-office, or at the client’s location using the new
                                  • Assistance Needed: Ticket Status Not Updating and Sorting by Last Customer Reply in Zoho Desk

                                    Hello, I’m facing two issues in Zoho Desk that I’d like your guidance on: Ticket Status Not Updating: When a customer replies to a ticket, the status does not change to Reopened. Instead, it remains in Waiting on Customer, even after the customer’s response
                                  • Round robin

                                    Hi, I'm trying to set up a round robin to automatically distribute tickets between agents in my team but only those tickets that are not otherwise distributed by other workflows or direct assignments. Is that possible and if so which criteria should I
                                  • Time Entry Notifications

                                    Hi All - I have support staff who place notes of their work in the time entry section of Zoho Desk. Is there a specific workflow or setting I need to enable to have the ticket holder updated via email when an entry is saved?
                                  • Change text in help desk

                                    Hi, Please let me know how can i change the this text, see screenshot.
                                  • Customer happiness customisation

                                    Hi, I was wondering if it's possible to somehow customise to whom and when customer happiness request is sent? Can you enable it only for selected tickets for example based on workflow or any other criteria (customer name, tag or anything else)? Also
                                  • No Zoho Support Response in Months

                                    I want to say that I love Zoho FSM, Books, and CRM, but the support is scary bad. About 2-3 months ago, I emailed Zoho FSM support with two specific issues I needed help with, and I have still not received one single response. I also submitted a support
                                  • Has anyone built a custom AI support agent inside Zoho (SalesIQ/Zobot)?

                                    Hi all, I’ve been experimenting with building my own AI support assistant and wanted to see if anyone here has tackled something similar within Zoho. Right now, I’ve set up a Retrieval-Augmented Generation (RAG) pipeline outside of Zoho using FAISS. It
                                  • Null

                                    If a result is null how do I make it so that a custom error pops up instead of the default error? Can someone write an example as if I were using the script builder?
                                  • Format a "return" message

                                    Good day, Is there a way to format the message of the "return" function in CRM deluge script?
                                  • 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
                                  • Having Trouble Opening The Candidate Portal

                                    Recently am having trouble opening the Candidate Portal. It keeps loading but cannot display any widgets. Tried Safari, Chrome and Edge. Non of them work. Please solve the problem ASAP.
                                  • Tip of the Week - Spot Risky Sales with Conditional Formatting

                                    In Zoho Analytics, small tweaks can lead to big insights. One such feature is Conditional formatting based on other columns, your key to instantly spotting where sales success is overshadowed by product returns. Our tip this week shows you how to apply
                                  • Next Page