Why ZOHO Function Can't Read Custom Field API In Quotes Module (Subform)

Why ZOHO Function Can't Read Custom Field API In Quotes Module (Subform)

I’m using a Deluge function to transfer data from a subform in the Quotes module to a subform in the Accounts module. Everything works except for a custom picklist field in Quotes—no matter what I try, the Zoho API can’t read that field ("Status_sb"). Below is my function, which transfers all line items except the “Status” field:

What am i doing wrong?

i checked that the field match in both modules, pick list is the same, i also changed the API name to match, the order of the items is in the same order, no extra spacing anywhere, its the exact same structure, i checked and doble checked a million times :(

FYI - I'm using the native quotes subform, the subform with the products that is already implemented in it i didn't create a new custom subform, i just added the status field (picklist) to the existing subform

thanks everyone

My Code:

string standalone.sync_sow_to_client_subform(string sow_id)

{

    respMap     = zoho.crm.getRecordById("Quotes", sow_id);

    accountId   = respMap.get("Account_Name").get("id");

    mp          = map();

    sub_forms   = list();

    subinfo     = ifnull(respMap.get("Product_Details"), list());

    for each rec in subinfo

    {

        subform     = map();

        prod        = rec.get("product");

        if(prod != null)

        {

            lookupMap = map();

            lookupMap.put("id", prod.get("id"));

            subform.put("Products_Name", lookupMap);

        }

        subform.put("Quantity",    rec.get("quantity"));

        subform.put("List_Price",  rec.get("list_price"));

        subform.put("Description", rec.get("product_description"));

        subform.put("Status_sb",   rec.get("Status_sb"));

        sub_forms.add(subform);

    }

    mp.put("ServicesSubForm", sub_forms);

    updateResp = zoho.crm.updateRecord("Accounts", accountId, mp);

    return updateResp.toString();

}



      • Sticky Posts

      • Function #46: Auto-Calculate Sales Margin on a Quote

        Welcome back everyone! Last week's function was about displaying the discount amount in words. This week, it's going to be about automatically calculating the sales margin for a particular quote, sales order or an invoice. Business scenario Where there is sales, there's also evaluation and competition between sales reps. A healthy rivalry helps to better motivate your employees to do smart work and close deals faster and more efficiently. But how does a sales rep get evaluated? 90% of the time, it's
      • Zoho CRM Functions 53: Automatically name your Deals during lead conversion.

        Welcome back everyone! Last week's function was about automatically updating the recent Event date in the Accounts module. This week, it's going to be about automatically giving a custom Deal name whenever a lead is converted. Business scenario Deals are the most important records in CRM. After successful prospecting, the sales cycle is followed by deal creation, follow-up, and its subsequent closure. Being a critical function of your sales cycle, it's good to follow certain best practices. One such
      • User Tips: Auto-Create Opportunity/Deal upon Quote Save (PART 1)

        Problem: We use quotes which convert to sales orders but Users / Sales Reps do not create opportunities / deals and go straight to creating a quote. This leads to poor reporting. Implementing this solution improves reporting and makes it easier for users.
      • Custom Function : Automatically send the Quote to the related contact

        Scenario: Automatically send the Quote to the related contact.  We create Quotes for customers regularly and when we want to send the quote to the customer, we have to send it manually. We can automate this, using Custom Functions. Based on a criteria, you can trigger a workflow rule and the custom function associated to the rule and automatically send the quote to customer through an email. Please note that the quote will be sent as an inline email content and not as a PDF attachment. Please follow
      • Function #50: Schedule Calls to records

        Welcome back everyone! Last week's function was about changing ownership of multiple records concurrently. This week, it's going to be about scheduling calls for records in various modules. Business scenario Calls are an integral part of most sales routines.. Sales, Management, Support, all the branches of the business structure would work in cohesion only through calls. You could say they are akin to engine oil, which is required by the engine to make all of it's components function perfectly. CRM

        • Recent Topics

        • Use Secure Public Links for Sharing Transactions

          Public links are the quickest way to send invoices or quotes to your customers. You can drop the link in an email, SMS, or WhatsApp message. But, links can be forwarded, and once they leave your customer's inbox, you can no longer control who sees your
        • 【開催報告】大阪 Zoho ユーザー交流会 NEXUS 2026/6/4(木)ZendeskからZoho Deskへ移行しコスト削減

          ユーザーの皆さま、こんにちは。コミュニティGの中野です。 6月4日(木)に、大阪 Zoho ユーザー交流会を開催しました。 本投稿では、その様子をお届けします。 当日の登壇資料などもこちらに共有しますので、参加できなかった皆さまもぜひご参照ください。 今回の大阪 ユーザー交流会では、ビープラスシステムズ株式会社 石井さんによるユーザー活用事例セッションのほか、 「Zohoで"これだけは外せない"ルーティーン」をテーマにしたグループワークを実施しました。 登壇いただいた石井さん、そしてご参加いただいたZohoユーザーの皆さま、ありがとうございました!
        • When will Zoho Books offer native NFS-e issuing, now with Brazil's National Standard?

          Hello Zoho Team and Community, I'd like to follow up on my previous suggestion regarding the critical need for Zoho Books to natively issue Brazilian Service Invoices (NFS-e). My original idea was that this could be achieved by extending the same integration
        • ZOHO FSM - Dispatch Console Drive time

          Is there a way to view drive time on a tech or estimate drive time from location to location? I need to see this on the Dispatch Console
        • Is there a way to update the forecast category independently from the deal's stage through an API?

          Hello, We're experimenting with the Forecast module and we've created custom categories to signal the top 10/50/100 deals currently in the pipeline. We would like to assign these categories automatically using custom functions but I found that the only
        • Small one person business needs everything in one place

          I just purchased a business and have a couple of your services. I would like to get everything in one place. I am a state trainer. I would like to get my invoices, payments, online classes, calendar for scheduling, maintenance, etc. in one place. can
        • Re-Apply SLA When Ticket Reopened from Closed Status?

          If you have an SLA applied, timers are deactivated when going to "On Hold" status type and reactivated when going back to an Open status type. What we discovered is when a customer replies to a closed case and it reopens, the SLA is not applied and timers
        • Conditional Drop Downs

          Am I the only one that has a problem when setting up the same project for multiple customers - resulting in a HUGE number of projects (e.g. Project A - customer 1, Project A - customer 2, Project A - customer 3 etc.). OR, am I doing it wrong? What results
        • Automating CRM backup storage?

          Hi there, We've recently set up automatic backups for our Zoho CRM account. We were hoping that the backup functionality would not require any manual work on our end, but it seems that we are always required to download the backups ourselves, store them,
        • Lead score decay timing and excluding specific campaigns from scoring

          Hi team, I have two quick questions about lead scoring: 1. When does a lead's score start going down? Like, after how many days of no activity does the score begin to drop? 2. Is there a way to stop certain campaigns from adding points to a lead's score?
        • Summer release '26 should be called Enterprise Summer Release '26

          Summer release '26 should be called Enterprise Summer Release '26 because almost all updates or the more useful ones, are limited for Enterprise subscriptions. us with Basic or Premium susbcriptions are basically left in the cold.
        • ZoHo Mail & MCP connectors

          Is ZoHo working an MCP connector for mail?? I find it very useful in Gmail to have Claude summarize messages for me. Thanks Jim P.S. Sorry if this is the incorrect forum. Mods please adjust as necessary.
        • FINALLY! 100% Responsive iFrame for HTML Page Snippet

          For the past two years or so I have been battling with Page Snippets' responsiveness (HTML, Embed, and ZML). Furthermore, if you use the native embedded reports, especially more than one report on a page, you have to set a static height because they're
        • Associate project with timer on iPhone

          When I start the timer without first associating a project (on my iPhone), its starts fine but now when I need to associate a project, and click on the link, I get a list of EVERY project I've ever put into Zoho Books. It used to just show active projects.
        • Import and Export of website.

          Hi, i have raised this ticket regarding challenges i am facing while importing a website on zoho sites. I have created my website on Squarespace and now i want to move it to zoho sites so i want to know what i am supposed to do whats the correct step
        • Important update on our transition to the new video platform framework

          As part of our ongoing platform changes, users in select regions, including the United States and other supported data center locations, have been migrated to our new video platform framework. Due to this migration, some participants may notice changes
        • Deleted User Emails

          I need to delete a user as I need to re-use their license, but I'd like to keep all their emails that are attached to various contacts in the CRM. Their emails are hosted externally on an M365 license. Anyone any idea how best to engineer this? TIA
        • #14 Get Paid Without Spending Time on Manual Follow-ups

          It's the end of the month. Payroll is due next week. A software subscription is about to renew. A vendor payment is waiting for approval. On paper, the business is doing great. Projects are getting completed. Customers are happy. Invoices have already
        • Client Script | Update - Client Script Support For Custom Buttons

          Hello everyone! We are excited to announce one of the most requested features - Client Script support for Custom Buttons. This enhancement lets you run custom logic on button actions, giving you greater flexibility and control over your user interactions.
        • Ability to select the attachment of a record when sending an email from FSM

          Hello FSM Team, FSM allows us to add attachments to any record (Estimate, Work Order, etc.). However, when we're sending an email from FSM, it is currently not possible to choose from the attachment in FSM to add to the email. When sending an estimate,
        • Function #11: Apply unused credits automatically to invoices

          Today, we bring you a custom function that automatically applies unused credits from excess payments, credit notes, and retainer payments to an invoice when it is created. Prerequisites: Create a Connection named "zbooks" to successfully execute the function.
        • Add spaces to input format

          In Zoho Inovices, I am trying to do a custom input format for a custom field. I have tried a few variations, but this is my most recent: ^[a-z][A-Z][0-9][,][-][_][:][ ]$ In this field, I will be entering different alphanumeric information, depending on
        • Zoho CRM Deal API returning null pipeline in case of default pipeline

          Hey team, We are writing to report an issue with the Deals module pipeline API behavior that we believe stems from how the default (Standard) pipeline is handled when no custom pipelines have been configured. When the "Manage Pipelines" page under CRM
        • Quebec Canada Tax GST and QST

          Hello Expert, Whenever we I create invoice for Quebec, Canada, it calculating wrong tax amount, can you please validate Attached the screenshot, which is calculating wrong tax amount on QST
        • Function #1: Convert an accepted Estimate to Sales Order automatically in Zoho Books

          As you’re aware, Zoho Books provides a default option to have the estimates automatically converted to invoices once your customer accepts them. Many of you wanted a similar option for sales orders, so here’s a workflow that converts accepted estimates
        • Facturation électronique 2026 - obligation dès le 1er septembre 2026

          Bonjour, Je me permets de réagir à divers posts publiés ici et là concernant le projet de E-Invoicing, dans le cadre de la facturation électronique prévue très prochainement. Dans le cadre du passage à la facturation électronique pour les entreprises,
        • Adding Taxes to paid consultations in Zoho Bookings

          I created a 'paid' consultation under Zoho Booking and integrated it with payment gateways for online/instant payment before a booking is done. How can I add 'taxes' to the price of consultation? I can add taxes to other Zoho apps (liks Books, Checkout,
        • What's New in Zoho Forms

          Hey there, We've been heads-down shipping this quarter. Because every update we ship is about making your forms do more, with less effort from you. This quarter too, we expanded what Zoho Forms can do. Here's everything that shipped. Spotlight Forms Some
        • Zoho Creator and Bluetooth Beacons?

          Hi all, Has anyone developed anything in Zoho Creator that leverages Bluetooth? Specifically to detect bluetooth beacons (iBeacon, Eddystone, etc.)? Thank you, Josh
        • Zoho Books | Product updates | June 2026

          Hello users, Welcome to this month's roundup of what's new in Zoho Books! We have an exciting line-up this time. The highlight is the launch of the all-new France Edition with full ISCA compliance. We're also introducing features such as Layout Rules
        • API to post drafts for social media

          I we want to post draft posts to our zoho social account and then approve and schedule them within Zoho social. is this possible with for example: https://apis.zoho.com/social/v2/post TIA Jon
        • Updating Zoho Books UI when a field is changed

          I have this script to update Quotes Expiry date. estimateID = estimate.get("estimate_id"); numberDaysTobeExtended = 14; estimatedate = estimate.get("date").toDate(); organizationID = organization.get("organization_id"); estDate = estimate.get("date");
        • What's New in Zoho Inventory | April & May 2026

          Hello users, We're excited to roll out the latest Zoho Inventory updates for April and May 2026. These enhancements are designed to make your daily operations smoother and more efficient, from advanced inventory management and flexible pricing to automated
        • Bullet Charts Stuck Loading Without Data

          I have a dashboard with some widgets in bullet chart format, but some of them do not have data. Since there is no data, they keep loading indefinitely instead of displaying “No Data,” as happens with the percentage widget next to them. This issue prevents
        • How to get Monday as 1st day of the week?

          Hi, The first day of the week is Sunday in Zoho Creator calendar.So it is hardly usable as in Europe the 1st of the week is always Monday. How can I get Monday as 1st day of the week? Best regards, Chris
        • Shall we play a game?

          Presenting the very first game created using ZOHO Creator: Tic-Tac-Toe (or noughts and crosses) I made this to challenge myself and employ some of the new features of ZOHO Creator. I must admit that the code is very literal and not too elegant. There are plans to improve on the machine AI and streamline the code over time. Currently the code makes extensive use of functions for the machine "AI" - there are 12 of these.   The machine AI can be tricked, so to counteract that I made it exceedingly arrogant
        • Check printing alignments always changes

          Hello, We have a frustrating problem with printing checks. We use Quickbooks voucher checks, which works okay for us. The problem is the printing alignment for the check's "Date, Pay to the Order of, Amount, and Amount in Words" changes every time we
        • name change of company in same GSTIN registration . how to retain historical company name for past transactions?

          hello I have recently change my company name from BHANU DIAM to BHANUMATI IMPEX in same GSTIN registration number While i have update the company name in profile name that change all my historic data like sale invoices and purchase bill , i would like
        • iOS Books app shows filtered view after changing to All sales orders

          My boss often checks sales orders on his iPhone. The app is mostly working fine, but there's an ongoing issue: When switching between different filters (also called custom views on the web), going back to All doesn't often work. It typically gets stuck
        • Recurring Invoices

          I'm looking to set up recurring invoices on a monthly basis, using GoCardless as a payment gateway. I've done this successfully, however there's a big problem with the Invoice Date and Due Date. We prefer to provide sufficient notice of collection (10
        • Next Page