Search - Joel Lipman .Com

1. Zoho CRM & Zoho Books: Get Books Currency and Tax IDs: / Zoho /; What? A quick note for when I want to quickly generate maps of a currency or a tax from a client's Zoho Books. Why? The use-case here is that we are creating a Sales Order in Zoho Books from Zoho ...; Created on 24 September 2021
2. 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
3. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... + v_ThisQuantity; // v_PriceDisplay = if(c_Quote.Unit_Price && c_Quote.Unit_Price > 0,v_CurrencyHtmlEntity + c_Quote.Unit_Price.round(2),"-"); v_PriceValue = if(c_Quote.Unit_Price && c_Quote.Unit_Price ...; Created on 07 May 2024
4. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... value ZDK.Page.getField("Weight_kg").setValue(v_ProductWeightFormatted); // now for currency fields var v_ProductPrice = ZDK.Page.getField('Unit_Price').getValue(); var v_ProductPriceFormatted ...; Created on 13 December 2023
5. 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
6. Zoho Books: System Values Maps: / Zoho /; ... ]; for each m_Currency in r_Currencies.get("currencies") { m_Currencies.put(m_Currency.get("currency_code"),m_Currency.get("currency_id")); } info m_Currencies; // // --------------------------------- / ...; Created on 07 November 2023
7. 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
8. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... = Map(); l_JsonOrders = List(); // // start preparing CSV file to email for export v_ReportCSV = "Date,Order ID,Status,Amount,Currency,Notes"; l_CsvFileRows = List(); l_CsvFileRows.add(v_ReportCSV); // // ...; Created on 29 March 2023
9. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... = Map(); m_Params.put("amount",v_StripeAmount); m_Params.put("currency","gbp"); //m_Params.put("automatic_payment_methods[enabled]", false); m_Params.put("payment_method_types[]","card_present"); m_Params.put("capture_method","manual"); v_DescriptionString ...; Created on 16 March 2023
10. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... in a JSON or ZohoDeluge Map format m_Response = Map(); l_JsonProducts = List(); // // start preparing CSV file to email for export v_ReportCSV = "ItemID,ItemName,Price,CurrencyCode,QuantityAvailable,SKU,DateCreated"; l_CsvFileRows ...; Created on 01 March 2023
11. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... console.log("Joel Lipman - 20221018 -------------------------"); // get some values from the current record var v_CurrencyCode = ZDK.Page.getField('Currency').getValue(); var v_ConsultantLocation ...; Created on 09 December 2022
12. 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
13. 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
14. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... query v_CoqlQuery = "select distinct Currency from Quotes where Subject!=''"; // // build up parameters m_Params = Map(); m_Params.put("select_query",v_CoqlQuery); // // invokeUrl r_Coql ...; Created on 08 October 2021
15. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... the following request to create a Sales Order in Zoho Books would be enough: { "date": "2021-09-08", "zcrm_potential_id": "123456789012345678", "currency_code": "GBP", "reference_number": "Salespersons ...; Created on 22 September 2021
16. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... = ifnull(r_Result.get("Quote_Stage"),"-"); v_QuoteCurr = ifnull(r_Result.get("Quote_Currency"),"GBP"); v_QuoteTotal = ifnull(r_Result.get("Total_Amount"),0.0).toDecimal(); v_ExchangeRate = ifnull(r_Result.get("Exchange_Rate"),1); v_ModifiedTime ...; Created on 30 July 2021
17. Windows OS: Alt Codes / Symbols / Special Characters: / Windows OS /; ... that are to be entered in their specific order. Search for "Alt Codes" or "Symbol Codes" in a search engine for a full list. Meanwhile, here's some that you may need frequently: Currency ¢ Cent ...; Created on 03 June 2021
18. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... and sent in JSON would look something like the following request: { "Subject": "My Test Quote", "Product_Details": [ { "product": { "Product_Code": "TEST1", "Currency": ...; Created on 17 May 2021
19. Zoho Deluge - Modify the product line items in an invoice module: / Zoho /; ... Item: "Product_Details": [ { "product": { "Product_Code": null, "Currency": "USD", "name": "Test Product", "id": "1642130000000104087" ...; Created on 22 August 2019
20. Submit form as a server and not the client with cURL: / API Miscellaneous /; What? A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache ...; Created on 20 February 2015