Trying to do commission tracking with zoho crm, can i do a Lookup against multiple fields in a module?

Trying to do commission tracking with zoho crm, can i do a Lookup against multiple fields in a module?

So i'm still designing my zoho one crm as i come over from salesforce.

One of the things i'm trying to build is a commission tracking module.  At some point i'll probably hire someone to help with custom code, I'm just proof of concepting it.  I"m not sure if this will even be possible in zoho crm, it was very much  shoehorned into salesforce that we had built for us through a custom module that a 3rd party vendor made that we have severed ties with,  it worked, but was clunky.

Maybe another zoho one app would be better for this, and if it is, i'm open.  Maybe creator?

Commission statements have the following key fields.  Statement date, commission date, contract id, and sales agent.

I have a custom built contract module, however the contract name is a human readable field, and then there's a separate custom contract id field, along with a start date, and stop date.  I really wish I could rename the default required value of contract name to contract id, that would be helpful, but otherwise it's so incredibly counter intuitive to put the ID in the default  "Contract *name*" field.  I suppose I could do that and create "contract *description*" for something that's a human readable description.  For us contract name is auto generated with a function as something along the lines of "customer name - vendor name - product name(s)".   Even if I did that it still leaves us with 1 problem.

That is to make matters even more confusing is this: contract id, while being unique per customer, is not unique per contract.  One of our vendors reuses the same contract id for a customer if we cancel 1 contract and replace it with another.  IE contract 12345 for customer john snow was active for 1/1/2022-04/31/2022, then john snow decides he wants to change products we cancel the contract, and make a new one for 5/1/2022-12/31/2022 but it has the exact same id of 12345; the contract id id is tied to the customer number.  This is not what I would like, but it's what the vendor does and we can not change it.  

As such we also have to track comissions by contract id and comission date, so if the comission date falls in the window of 1/1/22-4/31/22 it gets applied to the first contract, but if it's between 5/1/22-12/31/22 it goes to the second contract.  we usually get paid quarterly commissions, so each contract can have multiple transactions.

What I would like to do is have a commission transaction module, that has an auto generated number as the primary "name", and then a lookup to the contract id and the start start date and stop date of that contract ID.  so we're dealing with 3 fields here to make sure we're assigning the transaction to the correct contract.  Commission Transaction Record X with a comission date of 1/15/22 and Record Y with a transaction date of 4/1/2022 would both need to be assigned to a Contract ID of 12345 with a start date of 1/1/2022 and an end date of 4/31/2022.  But then Comission Z would need to go to contract id 12345 but with a start date of 5/1/22 and end date of 12/31/22.

The goal is to upload a csv and have the commission transactions auto matched to the policy record and sales agent, manually reveiw the matches to make sure they are good, fix any errors.

There are standalone products that do this commission tracking but we would have to export a report from zoho every period, import it to a commission tool., and then manage it separately.

I'd like to do something in the zoho world, even if i have to get a little custom development done, that can have some integration and bidirectional data flow back to the CRM that's ultimately our central 'hub'.

      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

                                  • Client Customer

                                    I purchased a customer user license, but we cannot see the project I added in the customer account. I would like to ask for support on what we should do.
                                  • Add Ability to Use Zoho Finance Tags

                                    For Zoho Finance (Books and Inventory), the current actions do not allow us to affect the tags associated with the entities in question (customers, vendors, items, etc.). Please consider adding this functionality into the actions.
                                  • Embeded Signing doesn't work on Safari Browser

                                    We have implemented Zoho Sign in our website by using embeded signing, It works perfectly on Chrome. But it fails on Safari, We get stuck on Zoho Sign Page during redirection from Zoho Sign to our website after signing the document, Please let us know
                                  • Dataprep Webhook Limits and Cannot update column with Dataprep

                                    I have two problems : 1 - I am using Airflow to trigger my pipeline, and when I tested it, it worked fine a couple of times. However, after that, I received an error: {"code":429,"message":"Request rate limited"}. I didn’t send too many requests — maybe
                                  • New in Zoho Forms: Google reCAPTCHA v3 for smarter spam protection

                                    Hello form builders, Spam submissions are one of the biggest challenges when you share your forms online. They not only clutter your data but can also waste valuable time. To help you combat this without making life harder for genuine respondents, we’re
                                  • Project Management Bulletin: August, 2025

                                    We’ve touched a grand 19 years since we started pioneering project management solutions with Zoho Projects. What started as a simple one-page interface is now a suite of products with Zoho BugTracker, Zoho Sprints, and our new debut Zoho Projects Plus,
                                  • Zoho Sign and Zoho Workdrive Integration

                                    Hello, there. I want to know if it's possible to save a signed document from Zoho Sign in an specific folder for each signer in Zoho Workdrive.  For example: If John Doe signs the document in Zoho Sign I want to save it automatically in a folder named
                                  • Empowered Custom Views: Cross-Module Criteria Now Supported in Zoho CRM

                                    Hello everyone, We’re excited to introduce cross-module criteria support in custom views! Custom views provide personalized perspectives on your data and that you can save for future use. You can share these views with all users or specific individuals
                                  • How do you list multiple contacts for a lead?

                                    My sales team wants to be able to add additional contacts for leads, how do we do that? Is there a different way we should be using the lead / contact functionality? Moderation update (9th September 2025): Our developers have built an extension to achieve
                                  • Modifying Three Dot Menu Options

                                    Is there a way to modify the three dot menu options that display in a Report header? They currently display: Show As (List, Calendar, Timeline), Print, Import, Export. I'd like to remove the Show As and Print options, since they aren't applicable for
                                  • Field Not Updating in FSM Script - Service and Parts module.

                                    Dear Team, I am reaching out regarding a script I have implemented in Zoho FSM to automate the calculation of the End of Service date based on the End of Sale date in the Service and Parts module. Overview of the script: Fetches the End_of_Sale__C and
                                  • Zadarma + Zoho CRM Integration – Missed Calls Saved as Contacts Instead of Leads

                                    Hello everyone, I’m looking for input from anyone with experience using the Zadarma + Zoho CRM integration. Currently, I’m seeing that missed calls are automatically being created as Contacts instead of Leads. From a CRM perspective, this doesn’t make
                                  • Zoho Books | Product updates | September 2025

                                    Hello users, We’ve rolled out new features and enhancements in Zoho Books. From PayNow payment method to applying journal credits to invoices and bills in other locations, explore the updates designed to enhance your bookkeeping experience. Integrate
                                  • How to update Multiple Users field in Quote Module from Deal Module

                                    Scenario : Deal Module having Multiple User Field (Presales Engineer) which having more than 1 User and through Deluge Script I need to get that Users Details and need to put into Multiple User Field (Presales Engineer) of Quote Module. Note: Both Module
                                  • Auto-sync field of lookup value

                                    This feature has been requested many times in the discussion Field of Lookup Announcement and this post aims to track it separately. At the moment the value of a 'field of lookup' is a snapshot but once the parent lookup field is updated the values diverge.
                                  • Clone a Module??

                                    I am giong to repurpose the Vendors module but would like to have a separate but very similar module for another group of contacts called Buyers. I have already repurposed Contacts to Sellers. Is it possible to clone (make a duplicate) module of Vendors
                                  • Advance PDF creation from CRM data

                                    I'm trying to create a PDF export of data in the CRM. My problem is I want a pretty complicated format for the data. I'm trying to export multiple modules worth of data, with nested one-to-many relationships between the modules. Along with that, I want
                                  • how to disable staff selection Zoho Booking integrated to SalesIQ?

                                    currently there is only one Consultant in my Zoho Bookings like this I integrate Zoho Bookings into Zoho SalesIQ to create a chatbot. Unfortunately, even though I only have one consultant for a consultation, the user have to pick the consultant. It will
                                  • How to change the text in WhatsApp Zobot integrated to Zoho Booking?

                                    I have integrated Zoho Bookings into Zoho SalesIQ, I want to change the text in WhatsApp when creating a booking in Zobot how to change those text?
                                  • Updating Subform Record from other Form

                                    Just wanted to ask how to properly approach this. I have 2 forms and would like to trigger an auto update on the subform once record submitted. block below only updates 1 row for each recordRow in input.AV_System { AssetRecord = Site_Asset_Services[SOR_No
                                  • Zoho Books - Hide Convert to Sales Order if it can't be used.

                                    Hi Books team, I noticed that it is not possible to convert a Quote to a Sales Order when a Quote is not yet marked as accepted. My idea is to not show the Convert to Sales Order button when it is not possible to use it, or show it in a grey inactive
                                  • How do I bulk archive my projects in ZOHO projects

                                    Hi, I want to archive 50 Projects in one go. Can you please help me out , How can I do this? Thanks kapil
                                  • Cross-Data Center Collaboration and / Or allowing users to choose DC

                                    Dear Zoho Cliq Support Team, We are writing to request a significant enhancement to Zoho Cliq that would greatly benefit our geographically dispersed development team. Current Challenge: Currently, Zoho Cliq automatically routes users to specific data
                                  • New Mandatory One-Click Unsubscribe Link Overshadowing Custom Unsubscribe Link

                                    I was recently informed by Zoho CRM Support that they are now mandated by the large email service providers like Google and Yahoo to provide a one-click unsubscribe option in the header (not the body) of all mass emails. I have a custom unsubscribe link
                                  • Send / Send & Close keyboard shortcuts

                                    Hello! My team is so close to using Zoho Desk with just the keyboard. Keyboard shortcuts really help us to be more efficient -- saving a second or two over thousands of tickets adds up quickly. It seems like the keyboard shortcuts in Desk are only for
                                  • Is it possible to register webhooks in Zoho CRM using API?

                                    Hello, I am trying to register a webhook in Zoho CRM programmatically (using the API). Specifically, I want to register a webhook that is fired when new Contacts are created in the CRM. I was able to setup a webhook using the UI, by creating a rule that
                                  • Calls where the local audio is shared, have echo

                                    When another user is sharing their screen with audio, I get echo from my own voice. We tested this with multiple users, with different audio setups, and there's no obvious way to fix it. Is this a bug you could look into, or are we missing something?
                                  • Update application by uploading an updated DS file

                                    Is it possible? I have been working with AI on my desktop improving my application, and I have to keep copy pasting stuff... Would it be possible to import the DS file on top of an existing application to update the app accordingly?
                                  • Markdown support, code cells...

                                    Hi Zoho I'd like to vote for a feature that markdown is supported with: Headings Code highlighting Quoteblocks ... Furthermore a inline card(like inline sketch card) for special text like Code would be great. And just to add my vote as well for "Tags"!
                                  • Minimise chat when user navigates to new page

                                    When the user is in an active chat (chatbot) and is provide with an internal link, when they click the link to go to the internal page the chat opens again. This is not a good user experience. They have been sent the link to read what is on the page.
                                  • How do I fix this? Unable to send message; Reason:554 5.1.8 Email Outgoing Blocked.

                                    How do I fix this? Unable to send message; Reason:554 5.1.8 Email Outgoing Blocked.
                                  • Reports: Custom Search Function Fields

                                    Hi Zoho, Hope you'll add this into your roadmap. Issue: For the past 2yrs our global team been complaining and was brought to our attention recently that it's a time consuming process looking/scrolling down. Use-case: This form is a service report with
                                  • Zoho Projects app update: Voice notes for Tasks and Bugs module

                                    Hello everyone! In the latest version(v3.9.37) of the Zoho Projects Android app update, we have introduced voice notes for the Tasks and Bugs module. The voice notes can be added as an attachment or can be transcribed into text. Recording and attaching
                                  • zurl URL shortener Not working in Zoho social

                                    zurl URL shortener Not working in while creating a post in Zoho social
                                  • In the Zoho CRM Module I have TRN Field I should contain 15 digit Number , If it Contain less than 15 digit Then show Alert message on save of the button , If it not contain any number not want to sh

                                    Hi In the Zoho CRM Module I have TRN Field I should contain 15 digit Number , If it Contain less than 15 digit Then show Alert message on save of the button , If it not contain any number not want to show alert. How We can achive in Zoho CRm Using custom
                                  • Power of Automation::Streamline log hours to work hours upon task completion.

                                    Hello Everyone, A Custom Function is a user-written set of code to achieve a specific requirement. Set the required conditions needed as to when to trigger using the Workflow rules (be it Tasks / Project) and associate the custom function to it. Requirement:-
                                  • Zoho Bookings know-how: A hands-on workshop series

                                    Hello! We’re conducting a hands-on workshop series to help simplify appointment scheduling for your business with Zoho Bookings. We’ll be covering various functionalities and showing how you can leverage them for your business across five different sessions.
                                  • Custom report

                                    Hello Everyone I hope everything is fine. I've tried to To change the layout of the reports, especially the summary page report, and I want to divide summary of each section in the survey but I can't For example: I have a survey containing five different
                                  • Zoho Journey - ZOHO MARKETING AUTOMATION

                                    I’ve encountered an issue while working with a journey in Zoho Marketing Automation. After creating the journey, I wanted to edit the "Match Criteria" settings. Unfortunately: The criteria section appears to be locked and not editable. I’m also unable
                                  • Custom Fields in PDF outputs

                                    I created a couple of custom fields. e.g Country of Origin and HS Tariff Code. I need these to appear on a clone of a sales order PDF template but on on the standard PDF template. When I select "appear on PDFs' it appears on both but when I don't select
                                  • Next Page