Need Help with Creating a Sales Order Form on Creator

Need Help with Creating a Sales Order Form on Creator

I asked ChatGPT to write me some code for a sales order form that pulls data from Zoho Books and Zoho CRM. Essentially, I want to be able to check for duplicates using the email address, and also pull the auto-generated sales order number from Books. Then, when the sales order is filled, redirect to a page that says: Pending Appoval. Submit it for approval, when it's approved, automatically convert it to an invoice and go to a payment page.

This is my ChatGPT prompt:
1. Allow users to sign in using their Zoho Email and password. 2. User enters basic contact information into it. Check Zoho CRM / Books for duplicates using email address. If the record exists, use that record. If it doesn't exist, create a new record. Pull the tax rate from the record in Zoho Books if it exists. Allow users to change the tax rate from the available rates in the picklist that exists in Zoho Books. Apply this default tax rate to line items in step 2. 3. Allow users to select any number of products using a subform. Show images of each product, and allow sales reps to apply discounts to each line item. Pull these products from our product list inside of Zoho Books. We have already integrated Zoho Inventory with Zoho Books, so the products already display inside of Books. Show the tax rate for each product as well in each line item. Essentially copy the layout of sales orders and invoices from books in include it in this form. Include a grand total section, with a subtotal field, total tax field in dollars, shipping charge field, and price adjustment field. Apply tax only to subtotal, not shipping. 4. Once the sales order is good to go, show a button that says Submit for Approval. Then, send a webhook for the sales order that is pending approval, and a manager will approve the sales order. 5. Once the sales order is approved, automatically convert it into an Invoice and allow payment processing through Square. We have already integrated Square with Zoho Books. Get the payment link from the invoice, and redirect to that payment page. 6. After payment is processed, redirect to a thank you page.

This is what is responded with:

  1. // Step 1: Allow users to sign in using their Zoho Email and password.
    // Assuming you have a form with username and password fields

    // Step 2: Check for duplicates in Zoho CRM/Books and handle contact information
    // Here's a basic example of how you might do this

    // Check if contact exists in Zoho CRM or Books
    existingContact = zoho.crm.searchRecords("Contacts", "email:email_address");

    if(existingContact.isEmpty()) {
        // Create new contact
        newContact = zoho.crm.createRecord("Contacts", {"Email": input.email});
        // Check for tax rate in Zoho Books and set default tax rate
        // Code to pull tax rate from Zoho Books and set default tax rate
    } else {
        // Use existing contact
        existingContact = existingContact.get(0); // Assuming only one contact is found
        // Code to pull tax rate from existing contact in Zoho Books and set default tax rate
    }

    // Step 3: Allow users to select products and apply discounts
    // Assuming you have a subform for selecting products with fields like product name, quantity, price, discount, etc.

    // Step 4: Submit for Approval and send webhook
    // Assuming you have a button to submit for approval

    // Submit data to webhook
    response = postUrl("<webhook_url>", inputData);

    // Step 5: Convert sales order to invoice and process payment through Square
    // Assuming you have a button to convert to invoice and process payment

    // Convert sales order to invoice in Zoho Books
    invoice = zoho.books.createInvoice(inputData);

    // Get payment link from invoice (assuming Square integration is already set up)
    paymentLink = invoice.get("payment_link");

    // Redirect to payment page
    openUrl(paymentLink);

    // Step 6: Redirect to thank you page after payment processing
    // Assuming you have a thank you page URL to redirect to
    redirectUrl("<thank_you_page_url>");




        • Recent Topics

        • Powering Customer Support with our women

          In Zoho Desk support, women make up 50% of our team. We see this as one of our strengths, reflecting the spirit of this year’s theme, "Give to Gain". Our women find their balance Women carry many responsibilities — they represent frontline support, lead

        • Can't rename groups on Mac desktop app

          I'm working on an up-to-date Mac with a freshly downloaded Notebook app. I'm trying to rename a group within a notebook. Here I have, left to right, a note, a group, and a note. I select the group. On the top left, I select Action. On the dropdown, "Rename"

        • Zoho Forms - Feature Request - Year Field

          Hi Zoho Forms Team, You currently have the following date and time fields: Date Time Date and Time Year and Month It would be useful if you could include a "Year" field For example a recent application I completed said "What year was your house built?"

        • I need help to take Reports for tickets moved between departments.

          Hi, I need help to take Reports for tickets moved between different departments. Pls guide Shyam

        • Export to excel stored amounts as text instead of numbers or accounting

          Good Afternoon, We have a quarterly billing report that we generate from our Requests. It exports to excel. However if we need to add a formula (something as simple as a sum of the column), it doesn't read the dollar amounts because the export stores

        • Increase Round Robin Scheduler Frequency in Zoho Desk

          Dear Zoho Desk Team, We hope this message finds you well. We would like to request an enhancement to the Round Robin Scheduler in Zoho Desk to better address ticket assignment efficiency. Current Behavior At present, the Round Robin Scheduler operates

        • Automation #6 - Prevent Re-opening of Closed Tickets

          This is a monthly series where we pick some common use cases that have been either discussed or most asked about in our community and explain how they can be achieved using one of the automation capabilities in Zoho Desk. Typically when a customer submits

        • Zoho Desk EU slow/unresponsive

          Has anyone else got issues with ZohoDesk today in the EU? It takes an age to come back and if you do start typing something and try and send or save it looks like it times out. We are also getting this pic. ot I can't see anything on https://status.zoho.eu/

        • EU DC Partial Outage Resolved: A Detailed RCA

          Incident Summary Due to an overload on one of the nodes in the EU DC for Zoho Desk, the system was unable to handle the heavy load, causing a slowdown in requests and resulting in a partial outage for customers with data residing in that node. On May

        • Use Zoho Creator as a source for merge templates in Zoho Writer

          Hello all! We're excited to share that we've enhanced Zoho Creator's integration with Zoho Writer to make this combination even more powerful. You can now use Zoho Creator as a data source for mail merge templates in Zoho Writer. Making more data from

        • Perfomance Management - Zoho People

          Hi team, I am looking for performance management data such as KRA, goals, feedback, appraisals, etc., in Zoho Analytics. However, I am unable to find these metrics while editing the setup. Could you please confirm whether these fields are available in

        • Deprecation of the Zoho OAuth connector

          Hello everyone, At Zoho, we continuously evaluate our integrations to ensure they meet the highest standards of security, reliability, and compliance. As part of these ongoing efforts, we've made the decision to deprecate the Zoho OAuth default connector

        • Good news! Calendar in Zoho CRM gets a face lift

          Dear Customers, We are delighted to unveil the revamped calendar UI in Zoho CRM. With a complete visual overhaul aligned with CRM for Everyone, the calendar now offers a more intuitive and flexible scheduling experience. What’s new? Distinguish activities

        • Zoho - Please explain difference between Thread view and Conversation view on Ticket

          I have reviewed the help document here but am still not clear on the difference between the two views. As an example, I just had a back and forth on a ticket: - Customer emails support email. - I email back from Desk. - Customer responds back. - I email back from Desk. On the upper left drop down box on the ticket Zoho Desk now says this is "4 Threads" and "4 Conversations" . How is that 4 threads?? By my count it is 1 thread and 4 conversations (assuming by "conversation" Zoho means number of total

        • Mobile phone version not working well

          I am working on the Zoho Site Builder. In the preview the desktop version looks okay, but in the mobile phone preview many words are cut off in the weirdest (wrong) way. How can I fix that?

        • Zoho Mail iOS app update: Display recipient's nickname on contact suggestion

          Hello everyone! In the most recent version(v3.3.1) of the Zoho Mail iOS app update we have brought in support to display recipient's nickname in contacts suggestion. Please update the app to the latest version directly from the App Store or using the

        • Digest Février - Un résumé de ce qui s'est passé le mois dernier sur Community

          Bonjour chers utilisateurs, Le 26 février, nous avons organisé notre première session Ask the Expert de 2026. Nous sommes heureux de partager que ce fut une session très interactive, avec de nombreuses questions intéressantes posées par nos clients. Si

        • Zoho CRM Case Notes - Share to Customer

          Hi team does anyone know the Api to set a note, against a case, to shared with customer? i cant seem to find it  cheers 

        • Zoho Forms - Feature Request - Past Into Scanning/OCR Field

          Hi Zoho Forms Team, You recently introduced the OCR/Scanning field which I have found great use for with one client who receives work orders as a screenshot from one customer. I want to raise a feature request here which would make that field even more

        • Synching changes to Stripe when changes are made in Zoho Billing

          We have a situation where we have merged customers in Zoho BIlling and then found out later that the payment in Stripe was not updated and still associated with the old customer record. The card gets updated and billed, but that payment is still associated

        • Send out follow-up email in the same thread (threaded conversations in individual emails) from Zoho CRM

          Hi, I'm new to Zoho. I'm trying to send individual emails to my leads one by one. And I'll send out follow up email if I don't hear back from them later. However, instead of sending a new email, I want to reply in the same email thread so that the recipients

        • Depositing funds to account

          Hello, I have been using Quickbooks for many years but am considering moving to Zoho Books so I am currently running through various workflows and am working on the Invoicing aspect. In QB, the process is to create an invoice, receive payment and then

        • Is Zoho Sites still actively being developed?

          Hello, Is Zoho Sites still actively being developed as part of the Zoho ecosystem? I noticed that the What's New page (https://www.zoho.com/sites/whats-new.html) does not show any updates since Q1 2025. We were considering migrating our website from Squarespace

        • FSM integration with Books

          Hi, I have spent a few months working with FSM and have come across a critical gap in the functionality, which I find almost shocking....either that, or I am an idiot. The lack of bi-directional sync between Books and FSM on Sales Orders/ Work Orders

        • web to lead

          Can anyone help me how to create web to lead from zoho marketing automation

        • Introducing Workqueue: your all-in-one view to manage daily work

          Hello all, We’re excited to introduce a major productivity boost to your CRM experience: Workqueue, a dynamic, all-in-one workspace that brings every important sales activity, approval, and follow-up right to your fingertips. What is Workqueue? Sales

        • UI issue with Organize Tabs

          When looking at the organize Tabs window (bellow) you can see that some tabs are grayed out. there is also a "Add Module/Web Tab" button. When looking at this screen it's clear that the grayed out tabs can not be removed from the portal user's screen

        • I created a signup form in Zoho Marketing Automation with the correct field mapping, but the data is not being reflected under Leads in Zoho CRM.

          web to lead from zoho marketing automation

        • Pasted Images not being embedded in custom mail

          Hi, I'm making a custom report by email based on commentaries. I have the email ready, all working great except for images that are being pasted in the commentaries. Zoho deals with them as temp images and so it requires authentication to view them, something

        • Kaizen #232 - Building a Ticket Escalation Mechanism from Zoho CRM

          Howdy, Tech Wizards! Picking up the thread from last week, we will continue our Zoho CRM and Zoho Desk integration. In Kaizen #231 - Embedding Zoho Desk Tickets in Zoho CRM, we built a Related List widget that displays open Zoho Desk tickets within the

        • Inactive License for free account.

          I recently upgraded my Cliq subscription not my team (on the free version), are unable to login to their accounts. The error message received is Inactive License Looks like you have not been covered under the current free plan of users. Please contact

        • Deluge scripts

          Why is there not a search function to make it easier to find the script of interest when modifications are required.

        • Zoho Sheet for Desktop

          Does Zoho plans to develop a Desktop version of Sheet that installs on the computer like was done with Writer?

        • Zoho Books (and other Finance Suite Apps) - Clickable Item Name on Invoices and Reports

          Hi Zoho Books team, It would be really helpful if the Item Name on Reports were clicable to take me to the item. The same on Invoices, often I am looking at an invoice and I want to look at the deails of a product. A link here would be helpful to jump

        • Zoho Books - Payment Gateway - Revolut

          Hi Books Team, My feature request if to include the popular platform Revolut as a payment collection option on invoices in Zoho Books. Please upvote if you are also looking for this option.

        • Searching for an item from within an invoice should show any item containing the string, not just those that begin with the string.

          Hello, I've found myself becoming increasingly frustrated with the limited line-item seach when adding new items to an invoice. The problem is that the characters being typed are only being matched from the beginning of the item name.  This might be usable

        • How to Rank Tables by Row Count in Descending Order

          I am trying to understand the consume of lines that grow up so fast in the last week. Is there any way to create a pivot table or query to get TABLE NAME LINES in descending order?

        • Dealing With One-Time Customers on Zoho Books

          Hello there! I am trying to figure out a way to handle One-Time customers without having to create multiple accounts for every single one on Zoho Books. I understand that I can create a placeholder account called "Walk-In Customer", for example, but I

        • Marking a meeting 'done'.

          I would like to somehow mark a meeting 'done' and placed under the contact's page rather than deleting it and having no record of it. Am I missing a button that does this?

        • Feature Request: Render Markdown (.md) files in Zoho Cliq

          Hi, We regularly share Markdown (.md) files in Zoho Cliq. However, when we open these files in Cliq, the content does not render as Markdown—it displays as plain text. This forces us to copy/paste the content into an external Markdown viewer to read it

        • Next Page