Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)http://mail.joellipman.com/articles/crm/zoho/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

14 February 2022 it an API version (eg. "2022-01" - or whichever is the latest stable version) Location ID if you know it, otherwise leave blank (eg. "123456789") Location Code if you know it (eg. "GB") Get access to the Shopify Admin Interface: Request access to the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Inventory: Mark a package slip as delivered and shippedhttp://mail.joellipman.com/articles/crm/zoho/zoho-inventory-mark-a-package-slip-as-delivered-and-shipped.html

14 July 2022 != null) { v_ShipmentID = r_PackageSlip.get("package").get("shipment_order").get("shipment_id"); // // if blank then create one if(v_ShipmentID == "") { m_Params = Map(); m_Params.put("date",zoho.currentdate.toString("yyyy-MM-dd"));...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM templatehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-send-an-email-with-a-crm-quote-using-a-given-crm-template.html

18 August 2022 details given a record ID r_QuoteDetails = zoho.crm.getRecordById("Quotes",p_QuoteID); // // check target email is not null/blank if(!isnull(r_QuoteDetails.get("Email"))) { v_Url = "https://zohoapis.com/crm/v2/settings/inventory_templates/" +...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCRM: Import Attachmentshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-import-attachments.html

16 January 2023 v_ProcessID v_FileName_Success := "Success_" v_ProcessID v_FileName_Prep := "Prep_" v_ProcessID ; to be set on setup (leave blank) v_TotalHours := 0 v_YourProfile := "" v_YourEmail := "" v_YourBrowser := "" v_YourName := "" v_Message := "" v_YourDate :=...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttp://mail.joellipman.com/articles/crm/zoho/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

13 February 2023 m_Message.put("role",v_Role); m_Message.put("content",v_Content); l_Messages.add(m_Message); } } // // if the message is not blank, send it to OpenAI if(!isBlank(v_Message)) { v_Question = v_Message; // // Need to add openAI token here v_Token =...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttp://mail.joellipman.com/articles/crm/zoho/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

18 September 2023 } // // ---------------------- ADDRESS ON QUOTE/ESTIMATE ---------------------- // if quote address is not blank, then push this to estimate if(v_BooksEstimateID != 0) { if(!isNull(r_QuoteDetails.get("Billing_Street"))) { m_BooksBillingAddress = Map();...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Books: System Values Mapshttp://mail.joellipman.com/articles/crm/zoho/zoho-books-system-values-maps.html

07 November 2023 v_CRMOwnerID = r_SoDetails.get("Owner").get("id"); v_Filter = "crm_reference_id=" + v_OwnerID; */ // set v_Filter to blank to retrieve all sales persons v_Filter = ""; r_AllSalesPersons = zoho.books.getRecords("salespersons", v_BooksOrgID, v_Filter,...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Get Images in Report to be Exported to PDFhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

26 January 2024 don't know how to refer to the public URL of a subform row other than making the subform link to an existing form and not a blank form. The document form contains the fields: Ticket (lookup to Ticket form), Image, File, Local Image, Subform Row ID...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoCreator: Basic Widget with Zoho Datahttp://mail.joellipman.com/articles/crm/zoho/zohocreator-basic-widget-with-zoho-data.html

14 March 2024 to find the preferred name for(var index in recordArr){ v_GreetingName = recordArr[index].Nick_Name; break; } // if not blank then let's display it if(v_GreetingName != "") { // can't seem to do jQuery references within this SDK...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Input Color Pickerhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-input-color-picker.html

14 October 2024 when the color palette is clicked, it hides itself and shows the button. Code for Onload of form: // // default to black on blank form, if loading an existing record, the value stored will be used. v_DefaultColor = if(isBlank(input.Hexadecimal),...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho People: Get Performance Records over APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-people-get-performance-records-over-api.html

18 September 2025 you all the fields that will be pulled from "Goals" and some records with data. Create the Zoho Analytics table Create a blank Excel file / spreadsheet / csv Copy the names of fields you want to store (I'm taking all of it), and paste them into the...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

How to make a HTML form post its variables to itselfhttp://mail.joellipman.com/articles/web-development/html/how-to-make-a-html-form-post-its-variables-to-itself.html

17 September 2009 PHP page to process the data. Solution I've seen a lot of people write CGI requests but if you left the action attribute blank, this would do the same thing:...

• Type: Article
• Author: Joel Lipman
• Category: Hypertext Markup Language
• Language: en-GB

Making a CD copy with only one drivehttp://mail.joellipman.com/articles/microsoft/windows-os/making-a-cd-copy-with-only-one-drive.html

23 September 2009 COPY SOURCE CD TO HARD DRIVE FIRST is selected Click on COPY and wait for the CHECK MEDIA dialog box to appear Insert your blank disk into the drive With the disc in the drive, click on RETRY In the Record CD Process dialog box, click on OK Eject your...

• Type: Article
• Author: Joel Lipman
• Category: Windows OS
• Language: *

List last modified files using FTP Command-linehttp://mail.joellipman.com/articles/web-development/ftp/list-last-modified-files-using-ftp-command-line.html

20 November 2012 you download or print output, it will save to this folder on your computer). Can type lcd if you want to change this (leave blank to simply display what current local working directory is). Type dir -S . temp.txt which will output all files including...

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *