Search - Joel Lipman .Com

1. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; What? This is an article detailing the client script to fix any fields which exceed their decimal places limit in ZohoCRM. Why? So we have a customer that has some decimal fields on the products ...; Created on 13 December 2023
2. Excel: convert degrees minutes seconds to decimal: / Excel /; ... I tend to use Excel to reduce the decimal point to only 7 decimal places (for importing to a database where DECIMAL(10,7) ). Merging the lot If B1 contains the coordinates and there is a space ...; Created on 06 November 2014
3. Convert Decimal (Person Days) to Time in Excel: / Excel /; ... ---------- ----------- Task 1 0.14 1:00:00 Task 2 0.07 0:30:00 Task 3 4.80 34:15:00 Excel needs the decimal number to be representative of a 24 hour slot. ...; Created on 13 February 2013
4. Zoho Creator: Input Color Picker: / Zoho /; ... users to learn about hexadecimal color references and Red Green Blue (RGB) values is somewhat difficult. What would be nice-to-have is if they could be presented with a bunch of colors and they click ...; Created on 14 October 2024
5. 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
6. 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
7. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... integer, currency, decimal and double. You can search for a maximum of 10 criteria (with same or different columns) with equals and starts_with conditions. The only operator that is supported for encrypted ...; Created on 14 November 2023
8. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... each r_Result2 in r_SearchResults2.get("items") { if(r_Result2.get("item_name") == v_CrmProductName) { m_BooksLineItem.put("item_id",r_Result2.get("item_id").toLong()); m_BooksLineItem.put("name",v_CrmProductName); m_BooksLineItem.put("description",r_CrmLineItem.get("Description")); m_BooksLineItem.put("quantity",r_CrmLineItem.get("Quantity")); m_BooksLineItem.put("rate",r_CrmLineItem.get("List_Price").toDecimal().round(2)); m_BooksLineItem.put("discount",ifnull(r_CrmLineItem.get("Discount_Percent"),0 ...; Created on 18 September 2023
9. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... build the update or create request m_CreateBooksItem = Map(); m_CreateBooksItem.put("name",v_ItemTitle); m_CreateBooksItem.put("sku",v_ItemSKU); m_CreateBooksItem.put("rate",v_ItemPrice.toDecimal()); // // ...; Created on 04 May 2023
10. 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
11. Zoho Deluge: Get All Orders from eBay: / Zoho /; What? Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay. Why? Our use-case is a data migration from eBay to a fresh instance ...; Created on 29 March 2023
12. ZohoCRM: Get All eBay Active Listings: / Zoho /; What? Another one of these articles talking about getting all the active product listings from eBay for a specific client. Why? Our use-case scenario here is that we want to get an inventory ...; Created on 01 March 2023
13. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... = r_Result.get("date"); v_Last4Digits = ifnull(r_Result.get("last_four_digits"),""); } } } // // if fully paid and payment date is not null if(v_BalanceDue.toDecimal() == 0.0 && v_PaymentDate ...; Created on 17 August 2022
14. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... as 10.00%. And they need the decimal because sometimes they might offer 12.5%. But when it displays in a template, it isn't that pretty to look at: Instead, could they have 10% to display instead of 10.00%, ...; Created on 08 February 2022
15. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
16. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... " + r_Event.get("eventType"); // // get the xero ID of the record (hexadecimal) v_Xero_ResourceID = r_Event.get("resourceId"); // // do different things based on the category of the update if(r_Event.get("eventCategory").containsIgnoreCase("CONTACT")) { / ...; Created on 10 January 2022
17. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... record under "Attachments". As a quick outline of the below: Create a connection to Workdrive/Writer Get the Merged Template ID (hexadecimal) Create the all-in-one button and function to generate ...; Created on 21 October 2021
18. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; What? This is an article to document how I downloaded an image held in a Zoho Creator form, and sent it to an API wanting the publicly accessible link or URL of the image. Why? I've got some other ...; Created on 17 October 2021
19. Zoho Creator / eBay: Get all Active Products: / Zoho /; What? This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's eBay store. Why? The use-case was that I wanted to retrieve ...; Created on 13 October 2021
20. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... of the fields is changed Add an eTag field: Will hold a 32 hexadecimal character string / a hash of the fields to monitor Add the if statement to compare etags on your main workflow. Other fields ...; Created on 19 September 2021