Search - Joel Lipman .Com

1. Zoho Deluge: Adding / Removing Total Tax from a Quote Record: / Zoho /; ... p_QuoteID is the ID of the quote): // init Map m_UpdateQuote = Map(); // r_QuoteDetails = zoho.crm.getRecordById("Quotes", p_QuoteID); v_SubTotal = r_QuoteDetails.get("Sub_Total").toDecimal() * ...; Created on 20 August 2019
2. Convert seconds to total time in PHP: / Personal Home Page /; ... to properly convert seconds into total hours, minutes and seconds (taking into account regional settings and without using a date function). How? $total_time =intval(intval($total_seconds)/ 3600).":"; $total_time.=str_pad(intval(($total_seconds/60)%60),2,"0",STR_PAD_LEFT).":"; $total_time.=str_pad(intval($total_seconds%60),2,"0",STR_PAD_LEFT); // ...; Created on 31 January 2012
3. 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
4. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... now let's generate the page list to have all the available pages v_TotalNumberOfPages = ceil(v_MaximumOrders / v_PerPage); l_AddPages = leftpad(" ",v_TotalNumberOfPages).replaceAll(" ",",").toList(); for ...; Created on 29 March 2023
5. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... = 1500; // // now let's generate the page list to have all the available pages v_TotalNumberOfPages = ceil(v_MaximumProducts / v_PerPage); l_AddPages = leftpad(" ", v_TotalNumberOfPages).replaceAll(" ...; Created on 01 March 2023
6. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; What? An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this ...; Created on 28 February 2023
7. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... API.fn_ShopifyQuery_UpdateAllProducts() { // init v_CountTotal = 0; v_CountUpdated = 0; v_PerPage = 10; b_HasNextPage = true; v_Cursor = ""; l_CsvFileRows = List(); // // start preparing ...; Created on 20 February 2023
8. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... list of pages to loop through (note: issues with multiple pages, do 1 at a time) l_Pages = ; v_PerPage = 200; for each v_Page in l_Pages { v_CountTotal = 0; v_CountProcessed = 0; v_FromIndex ...; Created on 08 February 2023
9. ZohoCRM: Import Attachments: / Zoho /; ... := "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 := ...; Created on 16 January 2023
10. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... AS "PO Item Tax", poi."Quantity" AS "PO Qty", poi."FCY Tax Amount" AS "PO Line Tax", if_null(pshipping."PO Delivery", 0) AS "PO Total Shipping", if_null(pdiscrepancy."PO Discrepancy Total", 0 ...; Created on 03 November 2022
11. Zoho Recruit: Rollup Number of Recruit Candidates to CRM Account: / Zoho /; ... in the Future Total Number of Candidates I'll flesh this out some other time but here's the code I used: r_CandidateDetails = zoho.recruit.getRecordById("Candidates",p_CandidateID,"zrecruit"); //info ...; Created on 19 October 2022
12. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... Cable (White) 1 £19.99 Build & Cost Breakdown Initial Build Total (functional PC, onboard GPU, 32Gb RAM, Previous O/S): £1,099.81 Second Part Build Total (GPU, RAM doubled, Windows 11 Pro, other): ...; Created on 12 March 2022
13. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; What? A quick article to demonstrate code that creates a task in CRM based on the time logged against an Event/Meeting. Why? As developers, we're keep account of our time and we are currently ...; Created on 02 December 2021
14. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... type: GET connection: "joels_connector" ]; info r_Templates; // // yields something like: /* { "total_count": 5, "templates": [ { "created_time": "2019-08-28T16:30:33Z", ...; Created on 21 October 2021
15. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... exclude variations m_Params.put("HideVariations","true"); // // restrict what fields to return l_OutputFields = List(); l_OutputFields.add("BuyItNowPrice"); l_OutputFields.add("ItemID"); l_OutputFields.add("SKU"); l_OutputFields.add("StartTime"); l_OutputFields.add("TotalNumberOfPages"); l_OutputFields.add("TotalNumberOfEntries"); m_Params.put("OutputSelector",l_OutputFields); // // ...; Created on 13 October 2021
16. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... It then outputs a JSON list as a response and the total record count: void API.fn_ShopifyQuery_GetActiveProducts() { m_Header = Map(); m_Header.put("Content-Type","application/json"); // // ...; Created on 12 October 2021
17. Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestamps: / Zoho /; ... + ", " + v_Minutes + " " + v_MinGrammar + ", " + v_Seconds + " " + v_SecGrammar ; // yields: 0 DAYS, 23 HRS, 54 MINS, 11 SECS Convert Total Minutes to Hours:Minutes This is for other scenarios: v_TotalMinutes ...; Created on 21 September 2021
18. Zoho CRM: Standard Setup for Tax Rates: / Zoho /; ... ticked, the same popup will appear if you click on the edit icon in the header "Tax" (applies to subtotal). Note: If you do not do the second section as per this article, even having customized ...; Created on 02 September 2021
19. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... "-"; v_QuoteTotalDisp= "-"; v_Index = v_Index + 1; v_RelatedListXML = v_RelatedListXML + ""; // // retrieve v_CreatorQuoteID = r_Result.get("ID"); v_LinkUrl2 = "https://creatorapp.zoho.eu/" ...; Created on 30 July 2021
20. Zoho Creator: Add a subform while creating a record: / Zoho /; ... = m_LineItem.get("List_Price"); r_Row.Tax = m_LineItem.get("Tax"); r_Row.Discount = m_LineItem.get("Discount"); r_Row.Total = m_LineItem.get("Line_Item_Total"); ...; Created on 14 July 2021