Search - Joel Lipman .Com

1. Outputting PHP files into different file formats: / Personal Home Page /; I'm beginning a list as I've just spent an age trying to get PHP output to create a text file. Then my client showed me how she then opens the text file in Excel, so I said we could get the script to do ...; Created on 12 February 2010
2. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; ... downloading a JSON file. Looked a bit suspicious. The code below opens a new tab in their web-browser displaying a plain output message. How? So there are 2 caveats to this solution: 1 is that ...; Created on 04 November 2024
3. Zoho Deluge: Convert Hex to RGB: / Zoho /; What? A quick article to document a Zoho Deluge function converting a hexadecimal color reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some ...; Created on 11 October 2024
4. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... off the contact record to send a credit application form for signing via ZohoSign Inputs: Contact Record ID Outputs: Attachment to the CRM record a ZohoSign Document record in CRM Date ...; Created on 06 August 2024
5. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... display related POs linked by a custom Sales Order lookup field on the Purchase Order line item. Inputs: salesorder Outputs: Related List Date Created: 2024-07-09 (Joel Lipman) ...; Created on 09 July 2024
6. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... warn system managers if a sync started failing. Inputs: None Outputs: Emails system manager if any failures. Date Created: 2024-07-02 (JoelLipman.com - Joel Lipman) ...; Created on 02 July 2024
7. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... a lead is created and not converted within 1 day send an email and notification to sales person everyday for 3 days then escalate to Dan Inputs: The Lead Record ID Outputs: A task with ...; Created on 14 May 2024
8. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... pages but then you hit the PDF button and it pretty much vomits your output back to the 90s. The code snippet below is just for a standard template with a modern design. How? Ok, admittedly, when ...; Created on 07 May 2024
9. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... - Order Update Trigger: Function executed when a webhook from Shopify is sent to ZohoCRM (Order Update) Inputs: String crmAPIRequest Outputs: String crmAPIResponse Date Created: ...; Created on 22 April 2024
10. Zoho Books: Error 7008: There are no contact persons associated with this Invoice: / Zoho /; ... Zoho Creator record ID of the order Outputs: - Date Created: 2023-03-06 (Joel Lipman) - Initial release Date Modified: ??? - ??? More Info: Error 7008: ...; Created on 07 March 2024
11. Zoho CRM: Client Script Confirmation Box and Popup Mailer: / Zoho /; ... it, just show it in the logs) console.log(e); //ZDK.Client.showMessage("Client Script error"); } Output Source(s): Zoho CRM Community - Kaizen #71 - Client Script ZDK ...; Created on 06 February 2024
12. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... users from saving a record without changing this. This script will round up decimal fields onload. Inputs: - Outputs: - Date Created: 2023-12-13 (Joel Lipman) - ...; Created on 13 December 2023
13. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... to Zoho Analytics Inputs: - Outputs: - Scope(s): Date Created: 2023-11-29 (Joel Lipman) - Initial release Date Modified: ??? - ??? ******************************************************************************* ...; Created on 05 December 2023
14. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... an image to workdrive and returns a publicly-accessible link/URL for use in your email signatures. Inputs: Loginuser Outputs: Email Scope(s): WorkDrive.team.ALL, WorkDrive.workspace.ALL, ...; Created on 05 December 2023
15. Zoho Books: System Values Maps: / Zoho /; ... - Outputs: - Date Created: 2021-09-24 (oel Lipman) - Initial release Date Modified: 2024-05-21 (Joel Lipman) - Change of API domain from https://books.zoho.com to https://www.zohoapis.com/books ******************************************************************************* ...; Created on 07 November 2023
16. Zoho Creator: Find Duplicates by Customer Name for Large Datasets: / Zoho /; ... v_CountDuplicates + " record" + v_Grammar + " are duplicates!"; // // return a distinct list l_Customers2.removeAll(l_Customers1); // // loop through and output to user for each v_DistinctCustomer ...; Created on 12 July 2023
17. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... = 1; v_PerPage = 10; m_Output = Map(); l_Costs = ; b_DebugMode = true; l_DebugMessages = List(); l_DebugMessages.add("eBay Order ID: " + p_eBayOrderRef); l_DebugMessages.add("eBay Order Date: " + ...; Created on 27 April 2023
18. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... of Zoho Inventory. In this task, we are simply getting a CSV with all the order IDs for a particular year output as a spreadsheet. How? Similar to how we retrieved the eBay active listings (see ...; Created on 29 March 2023
19. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... output to developer for debug purposes v_Date = zoho.currentdate.subDay(v_Index).toString("yyyy-MM-dd"); info v_Date; // // set criteria of what shipment orders to retrieve m_Criteria = Map(); m_Criteria.put("date",v_Date); // // ...; Created on 21 March 2023
20. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... invoice Outputs: - Date Created: 2023-02-24 - Initial release - Reads Books Invoice and sends the amount to the reader for a payment atempt Date Modified: 2023-02-24 ...; Created on 16 March 2023