Search - Joel Lipman .Com

21. Error during processing - Converting Date/Time: / Transact-SQL /; ... Conversion failed when converting date and/or time from character string. Basically I had to look at a previous report and it was just the way I was inserting the parameters into my query. Once ...; Created on 13 July 2010
22. Converting SQL date in PHP to European date format and vice-versa: / Personal Home Page /; ... specify a date (so excludes hours, minutes and seconds). For demonstration purposes, I'm going to be using the European date format so DD/MM/YYYY. The Solution This is what I use to convert a given ...; Created on 17 September 2009
23. Zoho Projects: Get All Events: / Zoho /; ... convert a Zoho Project DateTime to a DateTime datatype (given 12/12/2023 12:00:00 PM... remove ambiguity: mm/dd or dd/mm?) if(!isNull(m_PastEvent.get("scheduled_on"))) { if(m_PastEvent.get("scheduled_on").contains(" ...; Created on 22 July 2024
24. 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
25. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; What? A quick article with the code to download image attachments from a Zoho Ticket and then to upload the attachment to Zoho Analytics. Why? First of all, we couldn't find how to sync attachments ...; Created on 05 December 2023
26. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRM: / Zoho /; ... How? So there are a few issues with displaying images which would have other solutions, such as hosting the images on a web-server, or converting to a base64 or an SVG. ZohoCRM signatures seem ...; Created on 05 December 2023
27. Zoho Books: Generate Bank Text File for Download: / Zoho /; ... a variable: // // initialize v_CSVString = "Bank Sort Code,Bank Acc. No,Account Holder"; v_CSVString = v_CSVString + "12-34-56,012345678,Joel Lipman"; // // convert to a TXT file (not a CSV...) f_BillsExport ...; Created on 02 October 2023
28. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; ... + p_QuoteID type :GET parameters:m_ApprovedConverted connection:"zcrm" ]; // should be checking here that data contains any rows but I'm going on the basis that this quote exists in CRM an ...; Created on 18 September 2023
29. Zoho Deluge: Proper Case for Names: / Zoho /; ... other entry does not... This article is a start and adaptation of my previous article Convert to Proper Case in T-SQL which I had previously used for the migration of a HR system. This is intended ...; Created on 13 July 2023
30. Zoho CRM: Change System Field Length: / Zoho /; ... but it is a workaround I have used and that worked when converting a lead to a deal. Note that this hack doesn't work on the system field label name (I tried) just on the length field. Use the translations ...; Created on 19 June 2023
31. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... / send an order array l_OrderIDs = List(); m_OrderID = Map(); m_OrderID.put("OrderID",p_eBayOrderRef); l_OrderIDs.add(m_OrderID); m_Params.put("OrderIDArray",l_OrderIDs); // // convert to xml and repla ...; Created on 27 April 2023
32. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // //info "Request Sent ...; Created on 29 March 2023
33. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // info "Request Sent t ...; Created on 01 March 2023
34. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // // send the request XM ...; Created on 28 February 2023
35. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... // convert this row to an object o_SkillName = JSON.parse(JSON.stringify(l_SkillsSubform[i])); // check the skill is not blank if (o_SkillName.Skill != null) { // parse out ...; Created on 09 December 2022
36. Zoho Deluge: Generate a loop or list of any size: / Zoho /; What? This is an article on a trick I picked up from one of our interviewees as well as apparently in one of the Zoho documentation manuals. It uses leftpad to create a string of a length, converts ...; Created on 21 October 2022
37. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; What? This is an article describing a custom function built into Zoho Flow that will accept as parameter the document_id and request_id. It then retrieves the Deal Reference (entered by an office signee) ...; Created on 17 October 2022
38. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; ... create a button that sits on the view page of a record and the staff simply click on and it does all the aforementioned. How? The difficult part here was to figure out how to convert the CRM record ...; Created on 18 August 2022
39. Zoho Inventory: Mark a package slip as delivered and shipped: / Zoho /; ... r_Delivered; } } } } Error(s) Encountered : Not sure about what ended up fixing this one. I think I converted the sales order to an invoice and created a package slip for it. The invoic ...; Created on 14 July 2022
40. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... ID with the PDF file attached to it. Also, you can send multiple PDF files at the same time, as it is with any email client. You can also use ‘Convert’ as the subject and send it to Kindle. The file ...; Created on 29 June 2022