Search - Joel Lipman .Com

1. Merge the content of two similar tables in MySQL: / MySQL /; ... In MySQL, I only know how to do this with a UNION ALL clause. Scenario: I have a Joomla module which should take the keywords from a specified number of different but similar tables. I'm looking ...; Created on 11 January 2011
2. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... output response to console info "Response of attempt to upload to Zoho Inventory:"; info r_UploadPhoto; You should get a response similar to the following: Caveat(s) The code above only ...; Created on 21 June 2022
3. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... app without building a JS Widget or using Nodejs... Or we can make do with the tools provided. The brief was similar to the Zoho Bookings interface where their Creator app is to present the user with ...; Created on 09 March 2022
4. Zoho CRM: Schedule a Meeting using Deluge: / Zoho /; ... Similar to how to create a call or task, but with some variation: // // initialize m_ScheduleMeeting = Map(); // // specify parent module m_ScheduleMeeting.put("$se_module","Leads"); // // all ...; Created on 02 March 2022
5. Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time field: / Zoho /; ... to add 10 minutes to a date/time field in ZohoCRM and wanted a refresher for use in a client system. The usual error is something similar to the following: { "code": "INVALID_DATA", "details": { ...; Created on 11 November 2021
6. 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
7. ZohoCRM: Deluge: Map a custom field from user profile: / Zoho /; ... (similar to team name) and wanted any Opportunity record to have a field showing the user's Division. This would help in reporting later down the line. How? The following code snippet will get the ...; Created on 01 September 2021
8. Zoho CRM & Zoho Bookings Issue: Full Name appears in Last Name (first name first name last name): / Zoho /; ... pencil icon to edit this Alongside "Field Type", select "First Name, Last Name" Now your booking form will be similar to the following: And if the account is integrated with Zoho CRM, ...; Created on 01 September 2021
9. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; What? This is an article to demonstrate how to log a time event under a Zoho Projects Issue using code (Zoho Deluge) rather than the graphical user interface (GUI). Note this would probably be similar ...; Created on 30 April 2021
10. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API: / Zoho /; ... but I have since sent something similar to an API expecting nested arrays (not sure if they were PHP) and it works. Why? This took me several days and in the end only going through various forums ...; Created on 03 February 2021
11. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments: / Zoho /; ... response somewhat similar to the following: // this is sample JSON with replaced IDs "My_CRM_File": [ { "extn": "pdf", "is_Preview_Available": true, "download_Url": "/crm/org12345678901/specific/ViewAttachment?fileId=aaaabbbbccccddddeeeeffff1111222233334&module=CustomModule1&parentId=123456789012345678&creatorId=987654321098765432&id=234567890123456789&name=dummy1.pdf&downLoadMode=default", ...; Created on 02 February 2021
12. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... in your browser which is the root folder of your app: In the browser url, type https://127.0.0.1:5000/app/widget.html, your browser page should now display something similar to the following: ...; Created on 24 October 2020
13. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... I have found to work each time is using the CRM Object Query Language or Zoho's COQL. Similar to SQL but subject to similar issues of escaping special characters... 1. Setup a CRM Connection to Search ...; Created on 28 August 2020
14. AutoHotkey: Get Media Information and Display: / AutoHotkey /; Applies To: Microsoft Windows 7 Professional v6.1.7601 32-bit AutoHotkey v1.1.33.02 What? This is a copied article just to store a permanent reference for if I ever need to build an app similar ...; Created on 07 August 2020
15. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... the file to the CRM and Books record A successful response to the Zoho Books attachment (per file) should be something similar to the following: { "code": 0, "message": "Your file has been attached ...; Created on 15 May 2020
16. Zoho CRM/Creator - Common Errors & Gotchas: / Zoho /; ... invokeurl [ url :v_DataEndpoint type :PUT parameters:m_CreateRecord headers:m_Header ]; Problem: Value is empty and 'get' function cannot be applied Following a post similar to the above ...; Created on 06 February 2020
17. Zoho Deluge - First Monday of Month or Last Tuesday of Month: / Zoho /; What? An article on setting a date field to either the first Monday of the next month or to the last Tuesday of the current/next month. What I mean by the last Tuesday is if the last Tuesday of the ...; Created on 27 September 2019
18. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktops: / AutoHotkey /; ... system, you will know of a feature where you can have another virtual desktop on your device. For those that don't know it, the feature is similar to mobile phones where you swipe left/right to reveal ...; Created on 18 July 2019
19. GDPR Privacy Policy: / Static Items /; ... robots, or similar data gathering and extraction tools. This site or any portion of this site may not be reproduced, duplicated, copied, sold, resold, visited, or otherwise exploited for any commercial ...; Created on 14 February 2019
20. PHP Issue: simplexml_load_string parser error : Input is not proper UTF-8, indicate encoding !: / Personal Home Page /; ... in PHP with the function simplexml_load_string(). The error I get is something similar to: PHP Warning: simplexml_load_string(): Entity: line #: parser error : Input is not proper UTF-8, indicate encoding ...; Created on 02 August 2016