Search - Joel Lipman .Com

1. This file contains HTML or script code that may be erroneously interpreted by a web browser: / Hypertext Markup Language /; The Error: This file contains HTML or script code that may be erroneously interpreted by a web browser This is a common error when uploading files that the MediaWiki system does not allow. By making ...; Created on 08 October 2009
2. Zoho Creator: Input Color Picker: / Zoho /; ... = v_CssStyle; Code for On User Input of Color Picker: if(!isNull(input.Color_Picker) && !input.Color_Picker.contains("button")) { v_HeximalRef = input.Color_Picker.getsuffix("background-color:").getprefix(";"); input.Hexadecimal ...; Created on 14 October 2024
3. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... = zoho.currentdate.toString("yyyy"); if(!m_SubfolderNames.keys().contains(v_WorkingFolderName)) { m_Attr = Map(); m_Attr.put("name", v_WorkingFolderName); m_Attr.put("parent_id", v_ParentFolderID); // m_Params ...; Created on 11 September 2024
4. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... = ifnull(m_Body.get("requests").get("request_name"),"-"); if(v_RequestName.containsIgnoreCase("credit application")) { v_ZohoSign_DocumentType = "CreditApplication"; } v_DebugMessage = v_DebugMessag ...; Created on 06 August 2024
5. Zoho Projects: Get All Events: / Zoho /; ... convert a Zoho Project DateTime to a DateTime datatype (given 12/12/2023 12:00:00 PM... remove ambiguity: mm/dd or dd/mm?) if(!isNull(m_PastEvent.get("scheduled_on"))) { if(m_PastEvent.get("scheduled_on").contains(" ...; Created on 22 July 2024
6. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... was not accurate enough... but here's the snippet: r_CommentsHistory = Map(); l_Comments = ifnull(r_CommentsHistory.get("comments"),List()); for each m_Comment in l_Comments { if(m_Comment.get("description").containsIgnoreCase("Purchase ...; Created on 09 July 2024
7. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... item and description v_ItemDescDisp = "" + c_Quote.Product.Product_Name + " "; if(c_Quote.Special_Edition.containsIgnoreCase("yes")) { v_ItemDescDisp = "SPECIAL EDITION "; } // // ...; Created on 07 May 2024
8. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... :v_EndpointCategories + "?" + l_ConnectionParams.toString("&") + "&" + l_PaginationParams.toString("&") type :GET ]; if(r_Categories.toString().contains("count")) { v_TotalCategories = r_Categories.toJSONList().size(); } for ...; Created on 15 April 2024
9. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... I 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 ...; Created on 26 January 2024
10. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... Data Sources in the left sidebar Add Data Sources > Select Zoho Desk Do "Next" and select the Zoho Desk Portal Ensure that "Tickets" is selected (I'd tick most of the fields this contains) Create ...; Created on 05 December 2023
11. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... Why is this a challenge? The file contains bank details and should not be stored anywhere. Generating a text or CSV file and then having it emailed to anyone is an easy task but here we cannot have ...; Created on 02 October 2023
12. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... + p_QuoteID type :GET parameters:m_ApprovedConverted connection:"zcrm" ]; // should be checking here that data contains any rows but I'm going on the basis that this quote exists in CRM an ...; Created on 18 September 2023
13. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
14. Zoho Deluge: Get All Orders from eBay: / Zoho /; What? Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay. Why? Our use-case is a data migration from eBay to a fresh instance ...; Created on 29 March 2023
15. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... o m_CreatePayment; // r_CreatePayment = zoho.books.createRecord("customerpayments",v_BooksOrgID,m_CreatePayment,"zbooks"); //info r_CreatePayment; if(r_CreatePayment.get("message") != null) { if(r_CreatePayment.get("message").contains("paym ...; Created on 16 March 2023
16. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... = m_Node.get("updatedAt"); // // transforms if(v_ProductTitle.contains(",")) { v_ProductTitle = "\"" + v_ProductTitle + "\""; } if(v_ProductHandle.contains(",")) { v_ProductHandl ...; Created on 20 February 2023
17. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... contains a question mark, send it to OpenAI if(v_Message.contains("?")) { v_Question = v_Message; // // Need to add your own OpenAI token here v_Token = "sk-abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789"; // // ...; Created on 13 February 2023
18. ZohoCRM: Import Attachments: / Zoho /; ... contain names used on other records. Additional: Here's an AHK script I wrote that produces a GUI that takes an external file where column A contains the key/ID of the Contact in the 3rd-party ...; Created on 16 January 2023
19. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... so let's double-check if(r_Result.get("invoice_numbers").containsIgnoreCase(v_InvoiceRef)) { // retrieve payment mode, amount and date v_PaymentMode = ifnull(r_Result.get("payment_mode_formatted"),""); v_PaymentDate ...; Created on 17 August 2022
20. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... URL of the hosted image if(r_ResponseXML.containsIgnoreCase("Success") || r_ResponseXML.containsIgnoreCase("Warning")) { v_BiggestHeight = 0; x_RespondedXML = r_ResponseXML.replaceFirst("xmlns=\"urn:ebay:apis:eBLBaseComponents\"","",true); x_PictureSets ...; Created on 31 March 2022