Search - Joel Lipman .Com

1. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; What? A very quick article on a cool snippet of code, another regular expression, I've been trying out to round up a number or at least to remove the trailing zeros. I could have added this to my Zoho ...; Created on 08 February 2022
2. Zoho Deluge - Pad with leading Zeros: / Zoho /; ... So going through the forums you may find the following example: string padWithLeadingZeros(int finalStringLength, int startingNumber) { return leftpad(toString(input.startingNumber), input.finalStringLength).replaceAll(" ...; Created on 07 February 2020
3. SSRS Zero Padding: / SQL Server Reporting Services /; Quick Reminder I didn't want to do this at the database level, mainly because it meant modifying the SQL query. The zero padding would need to be applicable within an MDX query. The Situation We ...; Created on 10 November 2011
4. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... ssage = v_DebugMessage + "Document: " + v_ZCRM_DocRecordID + " :: " + v_ZCRM_DocRecordOwnerID + " If this is zero then no matching record was found. "; } // // get ZohoSign Document ID (only if te ...; Created on 06 August 2024
5. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... could be the same under price total. Where a price is applied, values should be retained in decimal format with currency symbol prefixed if value is greater than zero. Source(s): To convert Page ...; Created on 07 May 2024
6. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... = 0; v_Page = 1; // do not set this to zero!!! v_PerPage = 100; // // API keys v_MyWordPressSiteUrl = "https://mysite.com"; v_ConsumerKey = "ck_aaaabbbbccccddddeeeeffff1111222233334444"; v_ConsumerSecret ...; Created on 15 April 2024
7. Zoho Deluge: Determine if Daylight Savings are in effect: / Zoho /; ... How? Based on the fact that the United Kingdom is on the Prime Meridian and when no daylight savings are in effect, the hour difference to UTC (Coordinated Universal Time) should be zero, then for ...; Created on 03 July 2023
8. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... "ITEM CREATE RESPONSE FOR " + v_ItemID; info r_CreateItem.get("message"); Error(s) Encountered items with opening stock cannot be deleted, set the opening stock to zero: Guess who's going to hav ...; Created on 04 May 2023
9. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... (Joel Lipman) - If custom field "Amount To Be Taken" is not greater than zero, then defaults to balance due of invoice. More Information: TEST PAYMENT SCENARIOS WITH PHYSICAL TEST ...; Created on 16 March 2023
10. Zoho Creator: Disable/Hide the add and delete subform row buttons: / Zoho /; ... a list of services. The client does not want their operations team adding/deleting rows and instead simply specifying quantity (defaulting to zero) alongside each serviceable item. How? So at time ...; Created on 28 February 2023
11. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... if Deal ID is not zero, then it was found! if(v_DealID != 0) { r_DealDetails = zoho.crm.getRecordById("Deals",v_DealID,); // // do stuff here such as updating the deal if required m_UpdateDeal ...; Created on 17 October 2022
12. Zoho CRM: Standard Setup for Tax Rates: / Zoho /; ... Tax" @ 20% and a "Zero Vat" @ 0% Click on "Save" and you've pretty much specified the tax rates that this CRM can use; but... do the next steps for users to be able to use these. Done, sorta To ...; Created on 02 September 2021
13. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... es Tax"); m_TaxOption1.put("value",v_LineItemTax); l_TaxOptions.add(m_TaxOption1); } else { m_TaxOption0 = Map(); m_TaxOption0.put("percentage",0); m_TaxOption0.put("name","Zero Tax"); m_TaxOption0.put("value",0); l_TaxOptions.add(m_TaxOption0); } m_LineItem.put("Line_Tax",l_TaxOptions); m_LineItem.put("Discount",0); m_LineItem.put("Description" ...; Created on 17 May 2021
14. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... = zoho.people.getRecords("P_Employee",0,200,l_SearchCriterias); v_TotalDeptEmployees = l_DeptEmployees.size(); // ensure total is not zero as we need to divide by it (defaulting to 2 because if 1 the ...; Created on 10 December 2020
15. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; ... DON'T insert into Product table v_ProductID = l_ProductDetails.ID; } What Happens: In the example above, the count to see if "Myproduct1" exists counts as zero (0). It doesn't think the product ...; Created on 21 November 2019
16. Zoho Deluge: Adding / Removing Total Tax from a Quote Record: / Zoho /; ... if you want this to be zero, you need to pass the option of tax as zero and remove all other options. Take the following code for example, this will add 20% tax to the overall Tax on this record (where ...; Created on 20 August 2019
17. Convert Past Date to Time Ago in PHP: / Personal Home Page /; ... we want to achieve: 1 year 2 months 3 weeks 4 days 5 hours 6 minutes 7 seconds // full string 1 year 3 weeks 5 hours 7 seconds // where shown values are not zero Actually ...; Created on 16 May 2019
18. Joes Word Cloud (JWC) Download: / Downloads /; ... (regresses to strtolower). - Additional parameters (eg. Word Background) do not load if not enabled. - Added Joomla! Admin Option: Module width. - Corrected division by zero if no words found (?) sets ...; Created on 07 September 2015
19. XML Schema Reference: / Extensible Markup Language /; ... than zero length Specifies the exact number of characters or list items allowed. Must be equal to or greater than zero maxExclusive Specifies the upper bounds for numeric values (the value ...; Created on 13 August 2014
20. SSIS: How to loop through multiple flat files as data sources: / SQL Server Integration Services /; What? This is an article to demonstrate a quick step-by-step on having an SSIS package loop through a directory/folder of files in order to populate a database table. We could add each file as a separate ...; Created on 13 June 2014