Search - Joel Lipman .Com

1. Excel: Find values in one column that are not in another: / Excel /; What? A quick note on how to compare two columns for values that are not found in another. I have a column with old values, and now that I have a new list, I want a quick way to see what values are ...; Created on 06 March 2014
2. MySQL: Find all non-alphanumeric rows: / MySQL /; What? Quick note on how to do this. I was tasked with cleaning up an english database by replacing all special alphabets (ë to e) and non-alphanumeric symbols with URL friendly characters. How? ...; Created on 09 September 2013
3. CharIndex Reverse - find occurrence starting from end of string in TSQL: / Transact-SQL /; What? This is a quick note on finding the last occurrence of a string in a longer string. This has to be in Transact SQL for a SQL Server instance only and not filtered by other code. Why? I ...; Created on 28 January 2013
4. MySQL: Find records in one table that are not in another.: / MySQL /; The Why So I find myself writing increasingly complex SQL scripts and it's at the stage where we need to optimize the queries because some scripts are noticeably slow (as observed by the customer...) ...; Created on 25 February 2011
5. Joomla: Unable to find install package: / Joomla /; This issue happened with a friend who was trying to upload extensions. You should find that the configuration file is unwriteable (and that you can't change it using the joomla interface). In the end to ...; Created on 05 September 2009
6. GoDaddy Apache cPanel: Install SSL Certificate: / cPanel /; ... for Select the Server Type and then click on "Download Zip File" button Decompress the ZIP and find the CRT file Return to your GoDaddy page and scroll down to "Web Hosting" then click ...; Created on 07 April 2022
7. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; What? This is an article documenting the process of publishing a Zoho Inventory image to eBay's Picture Hosting Services (EPS). Why? Because I couldn't find any other article in the whole world ...; Created on 31 March 2022
8. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... in a different CSS color, and which date to enter into the Selected_Date field: // creating map for offset (determine which CSS box was selected) m_Offset = Map(); v_StartDate = input.Starting_Date; v_RefIndex ...; Created on 09 March 2022
9. Zoho CRM: Schedule a Meeting using Deluge: / Zoho /; ... time of print, I couldn't find that much information on how to build up a JSON request to create a meeting (previously known as Event) in Zoho CRM. Here's a quick snippet of code to remind me. How? ...; Created on 02 March 2022
10. Zoho CRM: searchRecords with sorted results: / Zoho /; ... (CRM, Creator, Books) seems to interpret this sorting feature differently. This article is an effort to find clear and working solutions. It is working again as of 2022-02-10. How? Two methods ...; Created on 10 February 2022
11. Zoho CRM: Template: Empty Space between Header and Line Items: / Zoho /; ... > Select the template with this issue Click on the "Edit HTML" icon in the top right of the editor: Find the code "page-break-inside" Change this from "avoid" to "auto": And optionally, ...; Created on 03 February 2022
12. ZohoCRM: Template: not being able to edit a text box: / Zoho /; ... Tools" Caveats Only make the changes necessary to how you like it. You will find issues with trying to undo some parts and tweaks as these will consume a lot of time (anyone remember the day ...; Created on 25 January 2022
13. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... find the invoice in CRM v_CrmInvoiceID = 0; l_SearchCrmByXeroID = zoho.crm.searchRecords("Invoices","Xero_Ref_ID:equals:" + v_Xero_ResourceID); for each r_Result1 in l_SearchCrmByXeroID { if(!isnull(r_Result1.get("id"))) { v_CrmInvoiceI ...; Created on 10 January 2022
14. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng): / Zoho /; ... + l_Params.toString("&")); // // if we got a response from the third-party API, let's go through the CRM picklist options to find the relevant one if(!isnull(r_Timezone.get("zoneName"))) { v_TimeZone ...; Created on 15 December 2021
15. Zoho CRM: Schedule a Call using Deluge: / Zoho /; What? This is an article to document how to schedule a call with a reminder in Zoho CRM using Zoho Deluge. Why? Because I find a need to document anything that takes longer than 30 minutes to ...; Created on 18 November 2021
16. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... email m_MergedData.put("subject","Document for " + r_ContactRecord.get("Salutation") + " " + r_ContactRecord.get("Last_Name")); m_MergedData.put("message","Please find attached your document"); r_SendResponse ...; Created on 21 October 2021
17. Zoho Deluge: Generate List of TimeZones: / Zoho /; What? A quick article to take a list of options from a HTML select element and convert to a Zoho Deluge list that will eventually be used to populate a dropdown. Why? Because I find myself doing ...; Created on 19 October 2021
18. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... and perhaps if I find a better way to do this, then I'll put it here. But I like this snippet of code albeit a brute force to loop through every active product and list their IDs. How? So here' ...; Created on 12 October 2021
19. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... s if you don't want to sit on a call with eBay. If you use Oauth as above then contact eBay and ask them to enable it once you've run the above function. For me, I didn't have this patience and find it mo ...; Created on 20 September 2021
20. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... a blank page. Their only workaround is wait about 30 seconds or more for the loop to automatically cut out and then they can use the interface again only to find it may crash again. In the background ...; Created on 19 September 2021