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 Name.id".

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} Owner.id
Created By.id
Parent {module}.id
{Custom lookup field label}.id

Notes

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!

Thanks!

France ZUGs

Topic Participants
Saishree T K

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,