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. 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
7. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; ... v_EmailMessage = "Hi " + v_ContactName + ", Please find attached your quote. Kind Regards, The Team"; // sendmail [ from :zoho.loginuserid to :v_EmailTo subjec ...; Created on 18 August 2022
8. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... print (6 June 2022) and I wanted to make sure it didn't just disappear or be difficult to find in future. How? The process of sending a PDF file to your Kindle device is also quite straightforward. ...; Created on 29 June 2022
9. 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
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. 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
17. 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
18. 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
19. 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
20. 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