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!

Zoho Developer Community

New to Zoho LandingPage?

Access Zoho LandingPage

Zoho LandingPage Resources

New to Zoho Survey?

Access Zoho Survey

Latest Feature Updates

Explore our Pricing & Plans

Zoho Survey Resources

Android Mobile Surveys

Insurvey Blogs

Insight Blogs

Tips & Tricks

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho CRM Plus?

Deliver unforgettable customer experiences

ACCESS ZOHO CRM PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Zoho Marketing Plus?

Everything you need to run your marketing

ACCESS ZOHO MARKETING PLUS

New to Bigin?

Signup Now

Access Bigin

Latest Feature Updates

Zoho Desk Resources

Desk Community Learning Series
Digest
Functions
Meetups
Kbase
Resources
Glossary
Desk Marketplace
MVP Corner
Word of the Day

Tout forum

France ZUGs

Zoho SalesIQ Resources

Topic Participants
Saishree T K

Sticky Posts
Effortlessly advance through your CRM blueprints by including optional fields in transitions
Editions: Professional edition and above DCs: All Release plan: This enhancement is being released in a phased manner to customers. It will soon be available to all users. Hello everyone, Blueprints streamline processes and ensure users adhere to required
Enhancement in Field update and date/time based triggers in Workflow
Hello everyone, Workflows allow to automatically execute a set of actions whenever the defined criteria is met. For example, whenever a new lead is created an introductory email is sent. So this action will keep occurring automatically as long as the
Notes and Attachments visibility can now be restricted based on profiles
Dear All, We hope you're well! We are here with a quick update about Notes and Attachments profile permissions. In the past, a record's Notes and Attachments were visible by default to all users with record access. However, as notes and attachments can
FAQs on Assignment rules - Post your questions
Dear All, Greetings! Assignment rules benefit organizations with effortless queue management capabilities. To bring more clarity on assignment rules, we are constantly publishing FAQs in our knowledge base. To ease the navigation across these FAQs further,
Assign records based on user roles in an organization
Dear Customers, We hope you're well. We are excited to share a new addition to the assignment rules in Zoho CRM. When setting assignment rules, administrators can choose to automate all records or only records which match specific criteria. The criteria