Search - Joel Lipman .Com

21. Zoho Deluge: Generate and Send a CSV via Email: / Zoho /; What? A super quick article to remind me how to generate and send a CSV as an attachment to an email. Why? Because I often get casually asked "oh and can you archive the data and email it to me ...; Created on 16 June 2021
22. Zoho CRM: Update a custom field in line items / product details using REST API v2.1: / Zoho /; ... like the following instead (reminder: instead of Product_Details, post to the API name in this case "Quoted_Items"): // // init l_CrmLineItems = List(); // // some sample values v_CrmProductID = ...; Created on 17 May 2021
23. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; What? This is an article to demo some Deluge code on how to download a file that was uploaded in CRM in a custom module in field that was of type "File Upload". Why? Just to remind me where I went ...; Created on 02 February 2021
24. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; What? So I thought I'd write a quick article to remind me and to develop a simple notification system that will popup for any user on the submit of a form, or on the click of a button or on the click ...; Created on 06 November 2020
25. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; What? This is an article to remind me how to search for CRM records by a value that may contain an ampersand or parenthesis. Why? I wrote this article because some searches will work for me and ...; Created on 28 August 2020
26. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... file You might have tested using the trusty sendmail function and then got an error when adding the "attachments" parameter. As a reminder, content-type in the sendmail is not supported in Zoho Creator ...; Created on 15 May 2020
27. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; What? Thought I'd put an article here to remind me how to make the retrieval of a record case-insensitive. Why? Consider that I have the following creator table: Product_Name Product_SKU ...; Created on 21 November 2019
28. Zoho Deluge - Modify the product line items in an invoice module: / Zoho /; What? This is a reminder on how to swap out a product in an invoice. Why? A client wanted one of their products to be swapped out with another as they had a 3rd-party feed that kept creating a ...; Created on 22 August 2019
29. Zoho Deluge: Adding / Removing Total Tax from a Quote Record: / Zoho /; What? A quick reminder on when I want to apply overall Tax or remove Tax from a quotes product line items. Why? I would apply the standard update function and although the response would say it ...; Created on 20 August 2019
30. 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
31. CSS Ordered List 1, 1.1...1.10 Formatting and Alignment: / Cascading Stylesheets /; What? A quick article to remind me on how create an multi-level ordered list that indents and aligns correctly. Why? I'm finding that I need to do this quite often for some clients who want to ...; Created on 10 July 2019
32. Zoho Deluge - Store and repopulate a multi lookup list in Creator: / Zoho /; What? A quick reminder on how I got a working snippet of code to store the entries in the lookup already selected, check against another table/form for valid options, repopulate the list with the selected ...; Created on 28 June 2019
33. Convert Past Date to Time Ago in PHP: / Personal Home Page /; What? Just a quick note to refine a function that will take a date in the past and return the number of years, months, weeks, days, hours, minutes and seconds. Why? Here are some examples of what ...; Created on 16 May 2019
34. Excel - Check a column for values found in another column: / Excel /; What? This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook). How? So for demonstration ...; Created on 14 February 2019
35. Google Drive API v3 - OAuth2 using Service Account in PHP/JWT: / Google /; What? This is an article explaining the code needed to write a PHP script which generates an access token for a service account which in turn is used to list files in a team's Google Drive. This is ...; Created on 02 February 2019
36. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library): / Google /; ... in the above function: { "name": "'.$name.'", "parents": ["'.$folder.'"], "description": "'.$desc.'", "copyRequiresWriterPermission": true, "writersCanShare": false } Reminder: ...; Created on 29 October 2018
37. FTP on Mac: Failed to retrieve directory listing: / File Transfer Protocol /; Applies to: FileZilla for Mac macOS High Sierra A quick note to remind me how to enable FTP directory listing as it was working on my Windows PC but not on my Mac. The error I was getting was Error: ...; Created on 06 October 2018
38. Make bootstrap carousel responsive to swipe: / Bootstrap /; What? A quick reminder on how to make the carousel in bootstrap compatible with touch devices like smartphones and tablets. Why? Feed back was that the user was unimpressed with the image slideshow. ...; Created on 14 December 2016
39. Protecting your Joomla Administrator Section: / Joomla /; What? This is a quick article to remind me how to move a Joomla administration section and to lock it down to a specific IP address. The below does not involve installing any third-party extensions ...; Created on 23 October 2015
40. SELECT COUNT(DISTINCT name) FROM table: / Joomla /; What? A quick article to remind me about this issue. Not sure whether it is specific to the Joomla Content Management System, but within the Joomla! CMS, an error 1054 comes up if you use the above ...; Created on 24 September 2015