Changes in lookup field column headers

Changes in lookup field column headers

Hello everyone,
This post serves to inform you about a minor change we've made to data backup files, wherein we've modified lookup field column headers for consistency. Previously, these headers were formulated to end with "space Id", whereas they're now formulated to end with "dot id". Example: "Account Id" is being changed to "Account".
The below image clearly shows the changes implemented. 

A detailed explanation about the changes and impacts caused by the changes are addressed below. 

Before the update 

In the data backup file downloaded from Zoho CRM, the column headers of lookup fields adhered to the format shown in the following examples:
  • {Module} Owner Id
  • Created By Id,
  • Parent {module} Id
  • {Custom lookup field label} Id

After the update 

In this update, the entire field label appears to be the column header with .id added as a suffix. As of this update, the column headers follows the format as shown in the following examples:
  • {Module}
  • Created
  • Parent {module}.id
  • {Custom lookup field label}.id


This update will affect certain scenarios, such as the following:
  • When a CRM data backup file is to be imported into an analytics tool, the column header should be re-mapped accordingly based on the new column header, as the data imported previously would have had a different column header.
  • When the CRM data backup file is used to automate data in the user's system via API.
  • When the data in the CRM data backup file is being used for a formula or a custom function. 
If you don't re-map fields or make changes to the API code (used internally), it could result in a breakage of those integrations. It's therefore important for users to make the required changes after the update. The table below shows the changes implemented in all the lookup fields:

Release details 

Beginning on April 10, 2023, the changes will be in effect. This change will happen over all the DC's and editions. 

Let us know your thoughts and feedback in the comments below!


              Zoho Marketing Automation
                        • Sticky Posts

                        • Introducing Built-In Telephony in Zoho CRM

                          Dear All, Greetings! We are excited to introduce the bespoke "Built-In Telephony" in Zoho CRM. Built-in telephony is designed to allow organizations to build their own telephony framework, manage subscriptions and payments, generate call reports, and
                        • [Webinars] Enhancements in Zoho CRM Customization, Analytics, and Forecasts

                          Hi everyone, Recently, 10 brand-new features were added to Zoho CRM’s core functionalities spread across field customization and control and, analytics and forecasting. To help you all implement and make the most of them, we're scheduling two webinars
                        • Canvas templates can now be shared with different CRM organizations

                          ----------------------------------------Moderated on 14th February, 2023------------------------------------------- Dear all, This feature is now open for all users in all DCs. To learn more about importing and exporting canvas templates, read our help
                        • Gamescope is leveling upto Motivator for Zoho CRM

                          Hello,   As you are aware, we recently made Motivator for Zoho CRM available for Zoho One, CRMPlus and CRM Ultimate editions. Since Motivator has all the features of Gamescope and even more advanced gamification, we are planning to EOL Gamescope on 30th
                        • Announcement! Early 2023 Release | Zoho CRM & You–Go Further Together

                          Greetings from the Zoho CRM team! Zoho CRM is evolving at an unprecedented rate– new features and enhancements are constantly being added that elevate its capabilities and help businesses make the most of the tool as well as the information they have,

                        New to Zoho Social?

                          Zoho Pagesense Resources

                            Zoho SalesIQ Resources

                                  Zoho TeamInbox Resources

                                    Zoho DataPrep Resources

                                      Zoho CRM Plus Resources

                                        Zoho Books Resources

                                          Zoho Subscriptions Resources

                                            Zoho Desk Resources

                                              Zoho Projects Resources

                                                Zoho Sprints Resources

                                                  Qntrl Resources

                                                    Zoho Creator Resources

                                                      Zoho WorkDrive Resources

                                                        Zoho Campaigns Resources

                                                          Zoho CRM Resources

                                                                Design. Discuss. Deliver.

                                                                Create visually engaging stories with Zoho Show.

                                                                Get Started Now