Search - Joel Lipman .Com

1. 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
2. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... user, and authorized as the system account (a separate Zoho user we have named SYSTEM ADMIN); this reduces the amount of blame on the system manager believed to be assigning these manually. Source(s): Zoho ...; Created on 14 May 2024
3. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... > 0,c_Quote.Unit_Price,0); v_PriceTotal = v_PriceValue * v_ThisQuantity; v_TotalPrice = (v_TotalPrice + v_PriceTotal).round(2); // v_DiscountDisplay = if(c_Quote.Discount_Amount && c_Quote.Discount_Amount ...; Created on 07 May 2024
4. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... 2022-01-17 (Joel Lipman) - Initial release - Forwards webhook to Zoho Creator Date Modified: 2024-04-22 (Joel Lipman) - Minimized amount of processing ...; Created on 22 April 2024
5. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... StaticAlias) - Resolved fix of inventory adjustment level (Error:9205:Insufficient Stock) - Resolved fix of overpaid amount (Include Shipping Cost in SO) Date Modified: 2023-03-16 (Joel ...; Created on 27 April 2023
6. 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
7. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... or on the phone. They bring up the invoie in ZohoBooks, click on the button, and the Stripe terminal will ask for the amount on the invoice. Well almost. We've gone the extra step in that we added ...; Created on 16 March 2023
8. 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
9. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... ID" AS "PO Product ID", poi."Item ID" AS "PO Item ID", poi."Item Name" AS "PO Item Name", poi."Item Price (BCY)" AS "PO Item Price", poi."FCY Tax Amount" / if(poi."Quantity" = 0, 1, poi."Quantity ...; Created on 03 November 2022
10. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... so let's double-check if(r_Result.get("invoice_numbers").containsIgnoreCase(v_InvoiceRef)) { // retrieve payment mode, amount and date v_PaymentMode = ifnull(r_Result.get("payment_mode_formatted"),""); v_PaymentDate ...; Created on 17 August 2022
11. 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
12. Zoho Creator / eBay: Get all Active Products: / Zoho /; ... the active listings as well as specific fields so my function doesn't get overwhelmed with the amount of data in the response: map API.fn_eBayQuery_GetActiveProducts(int p_Page, int p_PerPage) { /* ...; Created on 13 October 2021
13. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... article to go through various methods I tried to prevent this from happening: First - Off: The one workflow to rule them all In the first instance, we don't want large amounts of code to be copied ...; Created on 19 September 2021
14. Xero API: Send Multiple Invoices: / Xero /; ... "Date": "2021-08-13", "LineItems": [ { "Description": "My expensive product #1", "Quantity": 1, "UnitAmount": 240, "TaxType": "OUTPUT2", ...; Created on 15 August 2021
15. 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
16. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... = r_QuoteDetails.Product_Quantity; v_LineItem_TaxAmount = r_QuoteDetails.Product_Tax_Amount; // v_LineItemTotalExclVat = v_LineItem_Price * v_LineItem_Quantity; v_LineItemTotalVat ...; Created on 06 December 2020
17. 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
18. List of Font Awesome: / Web-Development /; ...  fa-sort-amount-asc []  fa-sort-amount-desc [] ...; Created on 04 September 2015
19. MS Excel: Convert a text to a number: / Excel /; ... space which had been copied in between the currency amount and the currency symbol. Microsoft could argue this is a problem with your data but the way I see it is it's a space character and TRIM() should ...; Created on 15 November 2013
20. Basic Joomla 2.5 Mootools Form: / Joomla /; ... stability, you will want this to use an XML file depending on the level of detail you want back. The biggy The following code is basically the least amount of code (or near enough) you will need ...; Created on 20 August 2012