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. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; ... amount/total is a currency column we want aligned on the right l_HeaderColumns.add(); l_HeaderColumns.add(); // // build up related list rows l_RelatedListData = List(); for each m_DataRow in l_DataRows { // ...; Created on 09 July 2024
4. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... zcpage-pagenumber, currentPageNumber, and totalPageNumber which will output the current page number and total count of pages respectively: Page of Copyright © My ...; Created on 07 May 2024
5. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... How? So first, this article shows you how to setup an API connection, and then we'll include the code to count the total number of products, and then finallly show the code to loop through all the ...; Created on 15 April 2024
6. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... Not sure about the rest of you, but I've been using this for pagination purposes and for the system to work out how many pages or loops in total it would need to do. How? Here's a couple of working ...; Created on 14 November 2023
7. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... ) + "%"); m_BooksLineItem.put("item_total",r_CrmLineItem.get("Net_Total").toDecimal().round(2)); v_CrmVatPercent = r_CrmLineItem.get("VAT2").replaceAll("[^0-9]",""); v_BooksTaxID = ifnull(m_Taxes.get(v_CrmVatPercent),m_Taxes.get("20")); m_BooksLineItem.put("tax_id",v_BooksTaxID); m_BooksLineItem.put("tax_percentage",v_CrmVatPercent); break; } } } l_BooksLineItems.add(m_BooksLineItem); } m_CreateEstimate.put("line_items",l_BooksLineItems); // ...; Created on 18 September 2023
8. 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
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. 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
17. 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
18. 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
19. 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
20. 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