Search - Joel Lipman .Com

1. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... = zoho.crm.createRecord("zohosign__ZohoSign_Recipients",m_CreateRecipient); // // create CRM zohosign document event m_CreateEvent = Map(); m_CreateEvent.put("Name",v_TemplateName + "-SENT"); m_CreateEvent.put("Owner",v_LoggedInUserID); m_CreateEvent.put("Email",v_RecipientEmail); m_CreateEvent.put("zohosign__Date",zoho.currentdate); m_CreateEvent.put("zohosign__ZohoSign_Document",r_ZCrm_ZSDoc.get("id")); m_CreateEvent.put("zohosign__Description","Se ...; Created on 06 August 2024
2. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... 'https://analytics.zoho.eu/clientapi/imageLibrary/fetchImage?ZDBFILEID=12345000034567890&ZSOID=20240725001' ) ) AS "Status" FROM "Accounts" ORDER BY "Modified Time" DESC /**** Pseudo: Select Modified ...; Created on 25 July 2024
3. 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
4. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... "Scheduler" header information such as the name, description, start date/time, frequency, and timezone. While you're here, click on "Connections" at the top of the IDE (where you paste the code) and ensure ...; Created on 02 July 2024
5. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... Description Quantity Unit Price Unit Discount 0) { v_LineItemTotal = 0.00; v_ThisQuantity = ifnull(c_Quote.Quantity,1).toLong(); v_TotalQuantity = v_TotalQuantity ...; Created on 07 May 2024
6. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... to display on their estimates in Zoho Books; such as product image, product name, product description. Granted that in some cases, the design should go in the other direction, as in enter the products ...; Created on 15 April 2024
7. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... ",", true)); l_CsvRow.add(c_Product.Product_Desc.replaceAll(",", ",", true)); l_CsvRow.add("\"" + c_Product.ID + "\""); l_CsvLines.add(l_CsvRow.toString()); } Generate ...; Created on 25 March 2024
8. Zoho Creator: Get Images in Report to be Exported to PDF: / Zoho /; ... the fault/description, and a subform to a form called "Documents" linked by a bi-directional ticket lookup. The document form is a subform derived from an existing form (called "Document"). Mainly, because ...; Created on 26 January 2024
9. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... - Correct Decimals" Give it a description, I'm giving it the one I have in the function header below Category is "Module" Page is "Edit Page (Standard)" Module is "Products" Layout is "Standard" Event ...; Created on 13 December 2023
10. Zoho CRM: ZDK Client Script: Auto-Select Pipeline based on User Department: / Zoho /; ... a system administrator > Go to Setup > Client Script Clicking on the "New Script" button in the top right. For this demo, we give it the name "On Deal Creation" and in the description I've commented that ...; Created on 16 October 2023
11. Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSON: / Zoho /; ... zoho.creator.createRecord() and wanted to update the first name of a name field but I was getting the following error: { "code": 2945, "description": "EXTRA_KEY_FOUND_IN_JSON" } How? So the ...; Created on 04 October 2023
12. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... each r_Result2 in r_SearchResults2.get("items") { if(r_Result2.get("item_name") == v_CrmProductName) { m_BooksLineItem.put("item_id",r_Result2.get("item_id").toLong()); m_BooksLineItem.put("name",v_CrmProductName); m_BooksLineItem.put("description",r_CrmLineItem.get("Description")); m_BooksLineItem.put("quantity",r_CrmLineItem.get("Quantity")); m_BooksLineItem.put("rate",r_CrmLineItem.get("List_Price").toDecimal().round(2)); m_BooksLineItem.put("discount",ifnull(r_CrmLineItem.get("Discount_Percent"),0 ...; 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. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... your details > Confirm via Email Create an app as described under Get Access section Click My Apps on the portal website Click on the App you created Note the API Key by clicking on "Show Key" ...; Created on 21 March 2023
15. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... = Map(); m_Params.put("amount",v_StripeAmount); m_Params.put("currency","gbp"); //m_Params.put("automatic_payment_methods[enabled]", false); m_Params.put("payment_method_types[]","card_present"); m_Params.put("capture_method","manual"); v_DescriptionString ...; Created on 16 March 2023
16. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... Lamp Gel Lighting &l;;color1> Halfrear Lighting Hard Light High Key Light Incandescent Lamp Key Light Light Pollution Low Key Light Moody Lighting Moon Light Natural Lighting Ray Tracing ...; Created on 11 February 2023
17. ZohoCRM: Import Attachments: / Zoho /; ... Language: English ; Platform: Microsoft Windows 11 ; Author: Joel Lipman ; Version: 1.0 ; Description: This program will generate a clean Attachments.zip and its Attachments.csv to upload ...; Created on 16 January 2023
18. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... CT TOP 100 "Customer ID", "Sales Person ID" FROM "Estimates" ORDER BY "Estimate ID" DESC ) e ON e."Customer ID" = c."Customer ID" LEFT JOIN "Sales Persons" sp2 ON sp2."Sales Person ID" = e. ...; Created on 03 November 2022
19. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; What? This is an article describing a custom function built into Zoho Flow that will accept as parameter the document_id and request_id. It then retrieves the Deal Reference (entered by an office signee) ...; Created on 17 October 2022
20. Zoho Creator: Populate a Multi-Lookup: / Zoho /; ... hasn't been populated l_Appointments = Appointment[Zoho_Inventory_Package_Slips == null] sort by Added_Time desc range from 0 to 100; for each c_Appt in l_Appointments { // // get package references ...; Created on 18 August 2022