Assuming product is required, and product is required, the following 77 results were found.
-
What? This is an article to document how I downloaded an image held in a Zoho Creator form, and sent it to an API wanting the publicly accessible link or URL of the image. Why? I've got some other articles on handling images in Zoho Creator (see...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
What? This is a reminder on how to swap out a product in an invoice. Why? A client wanted one of their products to be swapped out with another as they had a 3rd-party feed that kept creating a product that they didn't stock. How? So editing the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
What? This is a quick article documenting how to update custom fields in a line items or product details section of a transactional module such as Quotes, Sales Orders or Invoices using code: Zoho Deluge. Why? At time of print, Zoho had recently...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
it does exist then to simply skip adding the product. v_Name = "Myproduct1"; // note the lowercase P l_ProductDetails = Product[Product_Name == v_Name]; b_Exists = if(l_ProductDetails.count() > 0, true, false); if(!b_Exists) { // insert into Product...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
What? This is an article which is the updated version of my article Zoho Deluge: Push Item to Shopify API for 2022 using the new policy that Shopify have implemented when creating a custom app. Why? My use-case scenario here is that we have a Zoho...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
What? A follow-on article from my previous article ZohoCRM & Xero: Function to pull most recent invoices - along with their Contacts and Items (accounts/contact & products respectively). Why? This took me so much longer than I thought it would. It was...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
GNU GENERAL PUBLIC LICENSE Version 3, 29 June 2007 Copyright © 2007 Free Software Foundation, Inc. Everyone is permitted to copy and distribute verbatim copies of this license document, but changing it is not allowed. Preamble The GNU General Public...
- Type: Article
- Author: Joel Lipman
- Category: Static Items
- Language: *
-
What? An article on removing duplicate products within ZohoCRM. Why? Product duplicates are a common issue during development, especially when we have products imported via a feed or API or simply by staff and their spreadsheets. There is a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
What? Thought I already had an article on this and I know my article Zoho Deluge - Connect to Xero API covered a quick query to pull some invoices but this one documents a pull and mapping into CRM invoices. Why? This took me a whole afternoon so I...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
What? An article to resolve my frustration in being able to ONLY retrieve the first 100 products using GraphQL, so page 1 of Shopify products. Why? Our use-case is that we retrieve the 100 most recently modified products at the end of each day and run...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
What? So this is an article documenting how to create an on/off toggle switch that hides and displays between 2 div layers in a Zoho Creator Page (so not a form or report but a page). Why? This is written at a time when Javascript or interactive pages...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
What? This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's Shopify. Why? The use-case was that I wanted to search Shopify using a Product SKU. Community forums could only...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
What? A quick article on retrieving all the products from a WooCommerce instance on a client's Wordpress website. Why? A client of ours wants the information entered against products in their WooCommerce to display on their estimates in Zoho Books; such...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
What? An article on the reasoning and steps to generate a dataset using Zoho's ANSI-SQL queries to generate the margins of each invoice in ZohoBooks. Why? We need to create a profits/losses dashboard in Zoho Analytics as we can't control the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Analytics
- Language: *
-
What? A quick article on how to count within a map. I didn't have too much difficulty getting this to work and I'm not sure if there are better ways of counting so I'm documenting it to see if I can refine the code or find a some short codes that will...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
What? An article on a client script used in CRM which is a working example of rewriting a subform (line items of an invoice) and calls a REST API fuction to return the custom fields of the line items. Pretty much a function which took me a day to write....
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
What? A quick article with the code to retrieve your product key in Windows 7 with a small VB script file. There are other articles on the web about this but the ones I found returned errors such as WshShell not valid. This article has a working example...
- Type: Article
- Author: Joel Lipman
- Category: Windows OS
- Language: en-GB
-
What? This is a quick article on generating a file with the Zoho Deluge function .toFile() and uploading it to a file upload field within Zoho Creator. Why? The use-case here is that we want a file to be hosted within Zoho Creator for use by a JS widget...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
What? There are already articles out there that document this but I use this more and more and would rather just find it on my site than going through multiple bookmarks. Why? This use-case is for a customer who simply wanted a quote template to be...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Applies to: - MS Windows 7 Enterprise What? So I can ping the server the Oracle 11g database sits on. I've installed the Oracle 11g client tools and can connect using sqlplus. But if I tnsping any oracle database, I get something along the lines of:...
- Type: Article
- Author: Joel Lipman
- Category: Oracle PL/SQL
- Language: en-GB