Search - Joel Lipman .Com

1. MS Excel - Open CSV with Long Numbers: / Excel /; What? This is a quick reminder for myself on opening a CSV in MS Excel but without converting long numbers into exponential notations (which are incorrectly rounded anyway). My Data: Account ...; Created on 23 July 2019
2. Trim values along with the tab: / MySQL /; What? A quick article on how to trim in MySQL along with getting rid of any leading or trailing tab characters. Why? I use MS Excel for organizing data and then converting to MySQL commands. ...; Created on 13 June 2016
3. Background Gradient Disappears on Long Pages: / Cascading Stylesheets /; ... contents background (white) shows. When I visit a very long page on the site, the contents background disappears and reveals the overall background (blue) making the text very hard to read. Why? ...; Created on 20 November 2012
4. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... Go back to the contact record, and upload the file to the attachment... Some customers say this is unworkable and takes far too long, especially the part of adding the various field placeholders ...; Created on 06 August 2024
5. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; ... long as I can get to the 3rd tab of the widget (it becomes enabled once you've completed enough on the 1st tab): I'll click on the 3rd tab called "Settings" then on the sub-tab "Image", and click on ...; Created on 25 July 2024
6. Zoho Projects: Get All Events: / Zoho /; ... = l_ThisTimeEventParts.get(1); v_ThisDateEvent_Hour = l_ThisTimeEventParts.get(0); // // convert 12-hour to 24-hour v_ThisDateEvent_Hour = if(l_ThisDateTimeEventParts.get(2)=="PM", v_ThisDateEvent_Hour.toLong() ...; Created on 22 July 2024
7. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; What? An article to ensure I never spend this long on such a request again. The brief is: "Follow up when a lead is created and not converted within 1 day send an email and notification to sales person ...; Created on 14 May 2024
8. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; ... Description Quantity Unit Price Unit Discount 0) { v_LineItemTotal = 0.00; v_ThisQuantity = ifnull(c_Quote.Quantity,1).toLong(); v_TotalQuantity = v_TotalQuantity ...; Created on 07 May 2024
9. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... > Functions: then hover your mouse over the function and select "REST API". Enable the API Key option and copy the long URL to your clipboard for use in the above function: Set up a schedule If ...; Created on 22 April 2024
10. Zoho Deluge and Wordpress/WooCommerce API: Get All Products: / Zoho /; ... product count as products can belong to multiple categories. Consider just using the WooCommerce interface to check the total number of products (wp-admin > Products > All Products). Source(s): WooCommerce ...; Created on 15 April 2024
11. ZohoCreator: Using .toFile and Uploading to a Creator field: / Zoho /; ... HTML entity equivalent and enclosing the ID in double-quotes in case I open it in MS Excel or another system that likes rounding 64-bit signed integers (long numbers): // // Generate a CSV of a ...; Created on 25 March 2024
12. Zoho Books: Error 7008: There are no contact persons associated with this Invoice: / Zoho /; ... you can lock it down to just the scopes you need. void ZohoBooks.fn_SendZohoBooksInvoice(int p_OrderID) { v_OrderID = ifnull(input.p_OrderID,0).toLong(); /* ******************************************************************************* Function: ...; Created on 07 March 2024
13. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... Functions" Click on the Plus icon alongside this, scroll down to "Custom Functions" and click on "New" I give it the function name fn_Tickets_OnCreateEdit I click on "Edit Arguments" and give it th ...; Created on 05 December 2023
14. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... to be unable to handle a lot of code or long URLs such as a base64 source URL for an image. The Plan Get company phone and website from Organization Details in ZohoCRM. Upload and get publicly-accessible ...; Created on 05 December 2023
15. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... :GET connection:"zcrm" ]; v_MaxCount = ifnull(r_MaximumCount.get("count"),0).toLong(); v_Pages = ceil(v_MaxCount / v_PerPage); info v_Pages; Call with a criteria: v_PerPage = 200; v_CountCriteria ...; Created on 14 November 2023
16. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... you have sent the code to either create or update the estimate in ZohoBooks. You will need the returned estimate ID and I'm not 100% sure the attention/phone number goes along as my client didn't include ...; Created on 18 September 2023
17. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... the week number: c_Order = Order[ID == 123456890123456890]; if(c_Order.Order_Date != null) { v_ThisDate = c_Order.Order_Date.toString("EEEE, dd-MMM-yyyy u w"); v_ThisWeek = if(c_Order.Order_Date.toString("u").toLong()==7,c_Order.Order_Date.subDay(1),c_Order.Order_Date).toString("w"); } // ...; Created on 06 July 2023
18. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; What? A quick article on getting the payment terms in Zoho Books along with their IDs. Why? I often need to send through an automatic payment term on the creation of an invoice but lots of my ...; Created on 06 July 2023
19. Zoho Finance Suite Schedule: PATTERN NOT MATCHED: / Zoho /; What? A super quick article on resolving this issue if it ever appears again. Why? At time of print, this error was happening to schedules in Zoho Books, Zoho Inventory, and Zoho Subscriptions. ...; Created on 12 June 2023
20. Zoho Inventory: Enable Tracking using the API: / Zoho /; What? One of these articles because I spent so long trying different snippets of code to enable tracking when using Deluge code to create an item in Zoho Inventory: Why? Who uses ZohoInventory ...; Created on 04 May 2023