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. 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
4. 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
5. 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
6. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... == 3000) { v_RelatedListXML = ""; l_SearchResults = r_SearchResults.get("data").toJSONList(); for each r_Result in l_SearchResults { // init v_DateTill= "-"; v_QuoteTotalDisp= "-"; v_Index ...; Created on 30 July 2021
7. 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
8. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... = List(); m_TaxOption1 = Map(); m_TaxOption1.put("percentage",20); m_TaxOption1.put("name","Sales Tax"); m_TaxOption1.put("value",v_LineItemTax); l_TaxOptions.add(m_TaxOption1); m_LineItem.put("line_tax",l_TaxOptions); } m_LineItem.put("total",5.94); m_LineItem.put("product_description","M ...; Created on 17 May 2021
9. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... r_CreateTimeLog; You will find I've included the Hours decimal calculation above but it's not used and just for future reference. The API wants the total hours and minutes in the format "HH:mm" (eg. "34:06 ...; Created on 30 April 2021
10. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... causes errors further down the line. Just add these parameters as per my above instructions for a more robust solution. [See below for full code] Enter the code to determine total number of employees ...; Created on 10 December 2020
11. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... l_Quotes) { v_ContactFname = ""; v_ContactSname = ""; v_SubTotal = 0.0; v_TotalVat = 0.0; v_Total = 0.0; v_Total_Tax_Factor = 0.2; for each r_Quote in l_Quotes ...; Created on 06 December 2020
12. MySQL: Count occurrences of words in a column: / MySQL /; ... of each word in your database column by order of most used first (replace 'mydbprefix_content' with the name of your database table AND `introtext` with the name of your column): SELECT SUM(`total_count`) ...; Created on 12 March 2020
13. Zoho Deluge - Counting in a Map dataType: / Zoho /; ... the code or find a some short codes that will do the same. Why? I'm aiming to automate a process which counts the number of products allocated to an account or in total for a purchase order. Let ...; Created on 02 September 2019
14. Zoho Deluge - Modify the product line items in an invoice module: / Zoho /; ... 1, "Discount": 0, "total_after_discount": 0, "net_total": 0, "book": null, "Tax": 0, "list_price": 0, "unit_price": 0, "quantity_in_stock" ...; Created on 22 August 2019
15. Zoho Deluge - Regex to Strip all non-numeric characters: / Zoho /; What A quick post on how I managed to build a regex to extract all non-numeric characters (all non-digits) from a string. Why? I only want the digits/numbers from a string: v_PaymentTerms = ...; Created on 25 March 2019
16. Excel - Check a column for values found in another column: / Excel /; ... purposes, I'm using a new Excel file with two worksheets called "Sheet1" and "Sheet2" respectively. Sheet1 contains the following: A B --------------- --------------- seize spell fence total thank fight noise terms thigh tasty light swarm shelf allow unity press board wreck shake decay Sheet2 ...; Created on 14 February 2019
17. MS Excel - Split Workbook into separate files per sheet: / Excel /; ... in the top right) ' Press F5 to run the code. ' You will be prompted for the total range (eg. $A1:$W36000) ' And then prompted for the number of rows per sheet (eg. 3000) ' Run everything Sub RunAll() ...; Created on 11 February 2019
18. AutoHotkey: Check Windows Folder Sizes: / AutoHotkey /; ... Subroutine: LoopThrough: loops through folders and counts file sizes (including subfolders) LoopThrough: SB_SetText("Reading current directory...") vTotalSize = 0 Loop, Files, %MyBaseDir%\*, F { ...; Created on 28 January 2019
19. SELECT COUNT(DISTINCT name) FROM table: / Joomla /; What? A quick article to remind me about this issue. Not sure whether it is specific to the Joomla Content Management System, but within the Joomla! CMS, an error 1054 comes up if you use the above ...; Created on 24 September 2015
20. XML Schema Reference: / Extensible Markup Language /; ... zero pattern Defines the exact sequence of characters that are acceptable totalDigits Specifies the maximum number of digits allowed. Must be greater than zero whiteSpace Specifies how ...; Created on 13 August 2014