Beam Help — independent expert support for Zoho; this article explains how to locate and retrieve fields in Zoho CRM and when to use field mapping, custom fields, and queries to surface data you need[4]. This is not official Zoho support; it is practical guidance from Beam Help[4].
Why this matters
You need to retrieve fields when you want to view, map, or extend record data across modules, external data sources, or integrations such as Zoho Forms and Zoho Campaigns[4][6]. Knowing where fields live, how custom fields behave, and how to surface external data saves time when creating leads, syncing campaign data, or showing third‑party records in a related list[2][6][8]. Beam Help shows the common paths you’ll use to get the exact fields you need for mapping, display, or automation[4][6].
Step-by-step
Step 1. Open the record or module where the field should appear and check the visible fields to confirm the field exists and contains data[5].
Step 2. If the field is missing, check whether it is a standard field on the module you expect — Zoho CRM provides standard modules such as Leads, Accounts, Contacts, Deals, and others, and each module has its defined standard fields[4].
Step 3. Add or edit a custom field if needed: Zoho CRM supports multiple custom field types and lets you add fields to modules so they are available to all users in your organization[4].
Step 4. When collecting data from external forms, map the form fields to the corresponding Zoho CRM fields from the field‑mapping screen so new leads or contacts populate with the right CRM fields[1][6].
Step 5. If a form field fails to map because a CRM field does not yet exist, create the matching custom field in Zoho CRM first, then complete the mapping in the integration mapping screen[6].
Step 6. To show or retrieve related external system data inside a CRM record, use Zoho CRM’s query feature: register the external data source, create and save a query with SQL, and then add that query as a related list on the record’s page so the external rows appear when you open the record[8].
Step 7. In the query, pass the CRM field as a variable so the external query filters by the CRM record’s ID or other key — for example, bind a company or customer ID variable so the query returns only rows related to that CRM record[8].
Step 8. For integrations like Zoho Campaigns, toggle sync from Zoho Campaigns to Zoho CRM and map campaign fields (for example Email Opt‑out or Contact Score) to the CRM fields that should receive them, then save the mapping to enable sync[6].
Step 9. Verify mobile number format and required contact data before syncing: some integrations require specific formats (for example E.164 for mobile numbers) and require either email or mobile number to be present for a contact to sync[6].
Step 10. After creating or mapping fields, open a record and confirm the field values and record log display as expected in the record card view[5].
Common pitfalls
- If a mapping step errors with a message such as “Please create the Contact Score field in Zoho CRM,” that means the target field is missing in CRM and you must create it first before mapping[6].
- Number fields can strip leading zeros when used for values that require fixed-width formatting; use a text field when leading zeros must be preserved[2].
- Query-linked displays are read-only views of external data inside Zoho CRM; they show the results but do not make the external data editable from CRM — use Zoho Analytics if you need reporting or aggregation on external datasets[8].
What to check
- Confirm the target field exists in the CRM module (standard or custom) and is visible on the record layout you use[4][5].
- After mapping or creating fields, open a sample record to verify the mapped values appear and external queries return the expected rows filtered by the bound CRM field[5][8].
- For integrations, ensure the external data formats meet the integration requirements (for example mobile number format) so records sync without errors[6].