Fetch Subform values through a lookup of a lookup

Fetch Subform values through a lookup of a lookup

Hi, I'm having an issue fetching the values of a subform through a lookup field through another lookup field.

The code works perfectly to show me the subform row ID, but the second I try to get any readable data, it says "Error occurred. Please contact support"

The code is the following:
fet = Schedule_Appointment [ ID == input.Job_Number ];

for each rec in fet{
for each serviceRec in rec.ServicesSubForm{
servicesData = serviceRec.Services.Tasks_to_be_Completed;
for each taskList in servicesData{
info taskList.Task ;
}
}
}


Where "Schedule_Appointment" has a subform called "ServicesSubForm". That "ServicesSubForm" has a lookup field called "Services" which is a form with a subform called "Tasks_to_be_Completed". I need the data in "Tasks_to_be_Completed".

When I do just "info taskList" there is no error, but adding the "info taskList.Task" causes the error. "Task" is the field name in the subform.



I know it's probably very confusing, but does anyone know what I'm doing wrong? Or any other ways to do this?

    Nederlandse Hulpbronnen


      • Recent Topics

      • Sorting of invoices keeps changing

        Hi there, I log into Zoho invoice around 2-3 times a week. Usually I sort my invoice list by "Date created". Every now and again when I log in, this sorting criteria has changed. It's not clear to what criteria it is changing and how/why, but I find it a little annoying not seeing the latest invoices at the top. Can you please look into this and make sure the sorting function is stored in a cookie or on the server? Thanks, Kai
      • Feature Request: Add Sort by Cell Color and Text Color functionality

        Hello Zoho Sheet Development Team, I am writing to suggest a feature enhancement for Zoho Sheet. Currently, the platform supports "Filter by Color," which is incredibly useful. However, there is no native option to "Sort by Color" (by cell fill or text
      • Multi-Day Installations

        We schedule technicians on multi-day installations. A single appointment from Monday 8 AM through Friday 5 PM counts as 105 working hours, causing false overbooking. We need one appointment spanning five days but only 40 hours counted toward technician
      • Rebrand your CRM with the all-new custom domain mapping setup

        UPDATES TO THIS FEATURE! 19th Jan, 2024 — Custom domain mapping has been made available for portal users in Zoho One and CRM Plus. 23rd June, 2023 — Custom domain mapping has been made available for all users, in all DCs. Hello everyone! We are elated
      • How to manage additional required address information for Customers and Vendors.

        Has anybody figured out a way to incorporate relevant delivery information in the limited address fields for customers and vendors? For example, most carriers have an additional 'delivery instructions' field to add important information like delivery
      • Action required: Authenticate your sender domain before December 14, 2026

        Starting December 14, 2026, Zoho Campaigns will enforce a daily sending cap for unauthenticated custom sender domains. If you're sending email campaigns from your own domain but haven't authenticated it yet, you'll only be able to send up to 5,000 emails
      • Change default "Sort by"

        Is there a way to change the default "sort by" when searching across modules?" in Zoho CRM? Currently the default sort method is "Modified time" but i would like to utilize the second option of "relevance" as the sort by default and not have to change
      • Enhanced access controls and smoother authentication for organization emails

        Available to customers in all DCs. Hello everyone, We've improved how organization emails work in Zoho CRM, which are used when multiple users need to send emails from a common address, like sales@company.com or support@company.com. Admins can set up
      • Error AS101 when adding new email alias

        Hi, I am trying to add apple@(mydomain).com The error AS101 is shown while I try to add the alias.
      • Transaction rules for "Owner's Contribution" ?

        I have a bank account where a lot of the deposits are "Owner's Contributions" (i.e., the business owner investing money in the company). Is it possible to create a Transaction Rule to automatically recognize these? They all have the same verbiage from
      • Print a price list or price book

        Hi Community. Am I right in concluding that Zoho has no functionality to print a price list from either Zoho CRM, Zoho Inventory or Zoho Books? I won't get stuck on the fact that Zoho doesn't sync price books between Zoho CRM and Books/Inventory (more
      • The Social Wall: October 2026

        Hello everyone This month, we're making it easier to organize your monitoring workspace with Monitor Groups in Zoho Social. Organize your monitor columns into groups You can now organize your monitor columns into custom groups based on your preferences.
      • Field of Lookup - 5 Field Association Limit.

        This query relates to the post at: https://help.zoho.com/portal/en/community/topic/introducing-the-field-of-lookup-in-crm-public-early-access-2023 My simple (and common) scenario: I select an account / customer lookup and want their address pulled into
      • Feature Request - Electronic submission of tax returns in Canada

        Allow the user to submit Canada Revenue Agency GST/HST returns with NETFILE. Provide the same functionality for provincial revenue agencies for PST/RST remittances. Today Zoho Books only provides the math required to calculate each line, requiring the
      • Ability to translate Zoho CRM Kiosks

        Hi team, Is support for translating kiosk text and screen names in the Zoho CRM translation tool planned on the roadmap? Thanks,
      • Files in Teamspaces: keep your team's documents where the work happens

        Release Note: This feature is available for all accounts across all DCs Hello Everyone, A Teamspace is built around a specific team and a shared objective, and it holds the modules and projects that team works with every day. The document that team depends
      • How to download multiple files in Creator?

        I'm trying to download multiple files from a creator report using a for loop but it only seems to be downloading one file. It seems like no more code can be run after downloading this one file. Is there a way to download multiple files? I'm currently
      • Request for Zoho Desk Version and Module Details

        Kindly help us confirm the version of Zoho Desk currently being used in our portal, along with the module/edition name. We require this information urgently for our internal documentation.
      • ZohoMail_get_mail_attachment corrupts binary attachments (PDFs) over MCP

        Hi all, The Zoho Mail MCP tool ZohoMail_get_mail_attachment returns binary attachments as UTF-8 text, so PDFs come back corrupted and an AI client can't read or save them. What we see: - The response header is content-type: application/octet-stream;charset=UTF-8.
      • Request: Custom CSS Theme

        I would really like a custom CSS theme that enables me to completely customize the look and feel of the survey page based on the typography of my company brand. Unfortunately, there does not appear to be complete customization with existing themes. This
      • Découvrez le nouveau Zoho Analytics : l’analytique agentique pour toutes les entreprises

        Nous sommes ravis de vous annoncer le lancement du tout nouveau Zoho Analytics ! Cette nouvelle version marque un tournant majeur dans l’évolution de la plateforme. Initialement conçue comme une solution de BI en libre-service permettant de créer des
      • Zia Agents in Zoho CRM: a better way to set up digital employees

        Hello everyone, If you've been using Zia Agents in Zoho CRM, so far using Connections was the only deployment method you're familiar with. You create an agent in Zia Agents (define its objective, write instructions, use tools, add knowledge base) and
      • Admin Logging in as another User

        How can a Super Admin login as another user. For example, I have a sales rep that is having issues with their Accounts and I want to view their Zoho Account with out having to do a GTM and sharing screens. Latest Update (27th April 2026): With the early
      • Tool Parameter UI - Freeze Header

        When one has a number of tools with a number of parameters, scrolling down hides the heading information, forcing one to scroll back up to get confirmation which radio button is which: Seems like simply freezing the header would eliminate that issue.
      • Cannot replace custom tools

        This is so incredibly frustrating. Create a tool group. Add your custom schema to create your custom tools. Attach to an Agent. Now you need to update your schema to make an adjustment? You can't edit the schema or even re-upload a new schema. It blocks
      • Testing Tools - Can't View Response

        When adding a custom tool and trying to test it, one can see whether or not the test has a successful http response, but the actual payload cannot be viewed to verify the tool's performance. I thought that's what the little hover link was for, but mousing
      • Unbundle feature for composite items

        We receive composite items from our vendors and sell them either individually or create other composite items out of them. So, there is a lot of bundling and unbundling involved with our composite items. Previously, this feature was supported in form
      • Quick Reference Guide on join.zoho.com

        Joining a remote session can be difficult for the people who need it the most. Please add a quick reference guide and better documentation that my Grandma can read on the join.zoho.com site. It's not uncommon to spend 10minutes or longer in a session
      • Times prepopulating in Date/Time field on deal records

        Support tells me that there is no workaround to having the time auto-fill on a date/time field in our deal records -- that is HUGELY inconvenient and creates massive opportunity for error. Our deals involve several parts over various days/times, none
      • Making shared forms available offline

        Hi, We used to be able to have our forms available offline even if it was a shared form. now we can't. Is this a new bug?
      • Zoho Forms API

        Is there any way to get all form entry list using API? Looking forward to hear from you
      • Documents greater than 40MB Preview

        hello, Documents bigger than 40 MB cannot be previewed in WorkDrive Web App or Mobile App. would it be resolved in future?
      • Calendar Booking - Related Deal

        Is it possible to automatically associate a Calendar Booking with an existing Deal in Zoho CRM? We're trying to use the native Calendar Booking feature. Our goal is to send a booking link to a customer from an existing Deal record, so that when the customer
      • Approval Process configuration is now more flexible and fully customizable

        Hello everyone! Approval Process is back with a better user experience that makes it easier to add rules to your processes. This enhancement includes some UI updates that help you create highly structured approval stages—and more. Let's look at the enhancements
      • Kaizen #268: Using Zoho MCP to Build and Configure Zoho CRM Cadences

        Hi everyone! Welcome back to the Kaizen series! In the previous Kaizen posts, Kaizen #265 and Kaizen #266, we explored how Zoho MCP can be used to work with Zoho CRM records, retrieve metadata, customize CRM, configure automation, and even coordinate
      • Deliverability Update: Impact of the Ongoing Microsoft 365 Service Disruption on Email Delivery

        Update (November 16, 2026): This incident is resolved. In its final update on November 14, Microsoft confirmed that all affected services have fully recovered and the backlog of email messages has been processed. Microsoft lists the end of impact as November
      • Zoho Inventory - Imporoved Order Fulfillment Reporting

        Hi Inventory Team, i've tried to contact you through support@eu.zohoinventory.com but haven't received a response. I am contacting you on behalf of a client. Our client is a car parts wholesale business and we set them up on Zoho Inventory earlier this
      • Say Hello to Telephony in Zoho FSM

        Zoho FSM now brings complete telephony support so your team can manage inbound and outbound calls without switching tabs. Faster responses, smarter routing, and total call visibility—all in one place. Choose the telephony setup that works for you Zoho’s
      • Increasing API Credits

        Hello everyone! Organizations consume Zoho CRM APIs for various business needs, and it's a show-stopper when you exhaust your API credits before the 24-hour rolling window replenishes your credits. To meet your growing needs and help you keep your business
      • [Online Training] Zoho RPA masterclass: Fundamentals, SAP® automation, & AI workflows

        Hello everyone! Greetings from the Zoho RPA Training Team! We're excited to announce our upcoming Online Training on Zoho RPA. Manual, repetitive tasks like entering data, updating spreadsheets, managing files, and extracting information from documents
      • Next Page