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

                                  • Split my account

                                    Hello, I recently bought an email service for a friend. But, looks like I used my personal account to buy the plan. Please split the account so that the email service stays in a different account than my personal account.
                                  • Have Mail Lite, wish to add/purchase 2nd domain and use email

                                    Hello, I have recently created two new businesses. I have successfully used Zoho to create a domain for one business and have set up two email addresses / users on that domain. I am trying to figure out how to create a second domain, just like I did the
                                  • Need support in setting up the company email and few other setups

                                    Need support in setting up the company email and few other setups
                                  • This mobile number has been marked spam.

                                    Dear zoho team, I am very happy to use zoho,because it india 🇮🇳 own app, but when we login into zoho account we facing some issue, please solve below issue ASAP. Add your mobile number As an added security measure for Accounts, you need to verify and
                                  • Add an external email to the allowed list

                                    I need to allow an external email to raise a ticket on Manage Engine ServiceDesk Plus. The external email is a outside of our domain and is not a domain user. The email address that needs to be allowed to raise a ticket request is noreply@formsatack.com.
                                  • Display name & account type change

                                    I made a mistake and subscribed with an individual account instead of business, how can I change the account type and enter the details of the business. The other question, if I can't, then I want the display name of our email to be 'Business name' instead
                                  • Request to change display name in Zoho mail

                                    Hello Zoho Mail Support, I am experiencing an issue with changing the display name on my Zoho Mail account. My email address is: info@witchcraftproduction.rs . I have already updated the display name in Settings > Mail Accounts, where it now shows as
                                  • Outbound IP address SPAM problem.

                                    Hello Zoho Support, We noticed that one of your outbound IP addresses (136.143.188.12), which delivers our domain’s mail, is currently listed on the UCEProtect blacklist. Because of this, our messages are sometimes flagged as spam by recipient servers.
                                  • Answer Bot and Personalized Questions

                                    Hi there, I have the same problem using the SalesIQ Answer Bot and the Zoho Desk Answer Bot (which really need different names, to be honest, in order to avoid confusion...) Customers that visit our website ask questions in the form of "What do you do?"
                                  • Forwarding

                                    How can I forward my Zoho account to my gmail account? Noël
                                  • Add a Way to Duplicate Cards in the Same Canvas (Retain All Settings)

                                    Dear Zoho SalesIQ Team, We would like to request a new feature in Zoho SalesIQ: the ability to duplicate an existing card within the same canvas while retaining all of its information and settings, including conditions, configurations, and display preferences.
                                  • Zoho Mail CC and BCC not working

                                    Zoho Mail CC and BCC not working. I have tried multiple combinations amongst my domain aliases but emails sent as CC or BCC never arrive, not even to Spam. I have checked that the DNS is set up correctly in Cloudflare and have even received a DMARC report
                                  • Zoho Autoplay Issue

                                    Currently, we run our graphics on a playlist with youtube videos interspersed in our office -- however, when we go to update the playlist (since last Thursday at around 8-9am EST) it no longer saves the autoplay function.  We have tried making a new account, manually saving with cntrl+s, making a new show, etc but nothing seems to work.  Even with our old program, we can't change it off of autoplay for ones that were created in the past. Another issue is that if we change a slide transition to anything
                                  • Critical Issue: Tickets Opened for Zoho Support via the Zoho Help Portal Were Not Processed

                                    Hi everyone, We want to bring to your attention a serious issue we’ve experienced with the Zoho support Help Portal. For more than a week, tickets submitted directly via the Help Portal were not being handled at all. At the same time no alert was posted
                                  • Adding hyperlinks in CRM emails time automatically

                                    It may just be me, but when I am writing an email to a lead, I find inserting a hyperlink very time consuming. Granted, I can use templates but there are a ton of scenarios where I might want to put a link in to an website that wouldnt require me to go though the effort of creating a template.  Ideally, the crm would identify that I that a string of text is a URL and insert the hyperlink automatically, just like microsoft outlook or gmail. Has anyone else had this same experience and found a way
                                  • Enhance "Applications Usage" with Date Filters, Historical Analytics & App-Level Breakdown

                                    Hello Zoho Creator Team, We are writing to request a critical enhancement to the Applications Usage section to improve our ability to monitor, analyze, and manage our platform consumption over time. While the current view of today’s usage is helpful for
                                  • External File Share - Allow delete

                                    Hi Team, when I share an external link and give it edit rights the external user can add but not delete files and folders. what am i doing wrong?
                                  • Where is the Global Search field?

                                    I am looking for an alternative to SF.com. Zoho CRM seems to be work fine, and be customizable in terms of the fields and reports. But there's one big thing missing and it's going to prevent us from using it: there's no global search box at the top of
                                  • How to notify all members on any updates to zoho crm?

                                    Hi, I am using the free version of zoho CRM and currently seeing this will work for our company. We are a small company and wanted to be more informed about all the changes in zoho. 1. How do I s et notifications that go to the team for any and all changes
                                  • How to change the format for phone numbers?

                                    Mobile phone numbers are currently formatted (###) ###-####.  How can I change this to a more appropriate forms for Australia being either #### ### ### or (#)### ### ###?
                                  • Unattended Access on Android without Play Store

                                    I'm testing Zoho Assist for remote config and maintenance of our IoT devices. The devices are running Android 8.1 and do NOT have Google Play Store installed, nor can it be installed. I've been able to install Zoho Assist on the devices and load the enrollment
                                  • Open Sans Font in Zoho Books is not Open Sans.

                                    Font choice in customising PDF Templates is very limited, we cannot upload custom fonts, and to make things worse, the font names are not accurate. I selected Open Sans, and thought the system was bugging, but no, Open Sans is not Open Sans. The real
                                  • Is it possible to embed Zoho Bookmarks in the Cliq sidebar?

                                    Is there any way that each Zoho user can access their bookmarks (that live in https://bookmarks.zoho.eu/ which is technically a part of Zoho Mail) directly within Cliq? As a widget, or an item in the sidebar? My team does not use Mail, it uses Cliq all
                                  • Show Attachments in the customer portal

                                    Hi, is it possible to show the Attachments list in the portal for the particular module? Bests.
                                  • Kaizen #142: How to Navigate to Another Page in Zoho CRM using Client Script

                                    Hello everyone! Welcome back to another exciting Kaizen post. In this post, let us see how you can you navigate to different Pages using Client Script. In this Kaizen post, Need to Navigate to different Pages Client Script ZDKs related to navigation A.
                                  • Navigate with Ease: Announcing Improvements to Your Zoho CRM for Everyone's Setup Experience

                                    Hello Everyone, We’re thrilled to announce new enhancements to the Setup Menu in our Zoho CRM for Everyone system, designed to simplify your workday and streamline your overall experience. What's New? Addition of a Setup Homepage Faster Search in Setup
                                  • Zoho Projects Webhook fails with HTTP Error 0

                                    Hello Zoho Community, I am pulling my hair out over this one. I have setup a very basic http(s) server that always responds "ok" and code 200 to incoming GET requests. It will accept any parameters, and any path. Really, all it does is say "ok," and log
                                  • API 500 Error

                                    Hello amazing ZOHO Projects Community, I get this message. How can we solve this? { "error": { "status_code": "500", "method": "GET", "instance": "/api/v3/portal/2010147XXXX/projects/2679160000003XXXX/timesheet", "title": "INTERNAL_SERVER_ERROR", "error_type":
                                  • ZOHO Campaignで表のカラムの幅を調整したい。

                                    表を作成した際、個々のカラムの幅を調整したいのですが、方法が分かりません。 どなたかご存じの方ご教示ください。
                                  • Auto-upload Creator Files to WorkDrive

                                    Hi everyone, I’m working on a workflow that uploads files from Zoho Creator to specific subfolders in Zoho WorkDrive, as illustrated in the attached diagram. My Creator application form has two multi-file upload fields, and I want—on successful form submission—to
                                  • Exciting Updates to the Kiosk Studio Feature in Zoho CRM!

                                    Hello Everyone, We are here again with a series of new enhancements to Kiosk Studio, designed to elevate your experience and bring even greater efficiency to your business processes. These updates build upon our ongoing commitment to making Kiosk a powerful
                                  • Kaizen #129 : Client Script Support for Blueprints

                                    Hello everyone! Welcome to another week of Kaizen. Today, let us discuss about how you can use Client Script during a Blueprint transtion to meet your requirements. This Kaizen post will provide solution for the post - Need non-mandatory fields in blueprint
                                  • Search Bar Improvement for Zoho Commerce

                                    Hey everyone, I've been using Zoho Commerce for a bit now, and I think the search bar could really use an upgrade. Right now, it doesn't show products in a dropdown as you type, which would make finding items a lot faster. On Shopify, for example, you
                                  • Making digital signatures accessible to all: Introducing accessibility controls in Zoho Sign

                                    Hi there! At Zoho Sign, we are committed to building an inclusive digital experience for all our users. As part of our ongoing efforts to align with Web Content Accessibility Guidelines (WCAG), we’re updating the application with support that will go
                                  • Account Owner Field From Accounts Module to be Displayed in Contacts module

                                    I have a field in the Accounts Module in the CRM called "Account Owner" i want that field to be also mapped into the Contacts Module custom single line field called "Account Manager".
                                  • Update a field in the ZOHO Form, basis numeric value in another field in the same form

                                    I am trying to create a questionnaire in ZOHO, where clients need to answer 10 questions, and basis response, values are assigned. I have created a total score field where the sum of the values is stored. But i am unable to create a rule whereby another
                                  • How to update "Lead Status" to more than 100 records

                                    Hello Zoho CRM, How do I update "Lead Status" to more than 100 records at once? To give you a background, these leads were uploaded or Imported at once but the lead status record was incorrectly chosen. So since there was a way to quickly add records in the system no matter how many they are, we are also wondering if there is a quicker way to update these records to the correct "Lead Status". I hope our concern makes sense and that there will be a fix for it. All the best, Jonathan
                                  • Meet up de Zoho en Bilbao

                                    Buenos días comunidad! Estamos estudiando hacer un Meet up en Bilbao desde zoho y varios Partners. Para que la experiencia sea excelente, queremos saber cuantas pesonas se vendrían a Bilbao al evento. Y para que sea lo mas útil posible, que temas dentro
                                  • Picklist reference value in REST

                                    picklist options can be configured to have a different reference value than the displayed one, should be helpful in things like multilanguage: https://help.zoho.com/portal/en/kb/crm/customize-crm-account/translations/articles/translations is there a way
                                  • In Zoho inventory Converting sales return to cerdit note from using Api from Creator Error details: {"code":-1,"message":"Invalid Sales Return ID."}

                                    In Zoho inventory Converting sales return to cerdit note from using Api from Creator Error details: {"code":-1,"message":"Invalid Sales Return ID."} this is button Function used in the Creator map Inventory.Create_Credit_note(int CRE_ID) { return_value
                                  • Next Page