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. 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
7. 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
8. 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
9. ZohoCRM: Deluge: Map a custom field from user profile: / Zoho /; ... Opportunity/Deal/Potential record details, then get the Owner frrom the CRM users table, find the value of the custom field and search for this (if it is a lookup to a module - only returns as string), ...; Created on 01 September 2021
10. Zoho CRM & Zoho Books: Get SalesPersons: / Zoho /; What? An article so that I don't spend so long in trying to find sales persons in Zoho Books. Why? My use case is that I want to create a Sales Order in ZohoBooks based on one in ZohoCRM and wanted ...; Created on 30 August 2021
11. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / Zoho /; ... Replace all commas in between a pair of double-quotes: Well I couldn't find a single regex that can do this in one go but by applying the same regex to the same value (line 29), solved this for the sample ...; Created on 26 August 2021
12. ZohoCRM: Process all records of a module: / Zoho /; ... { v_Email = r_Contact.get("Email"); // // find all lead records matching this email l_Leads = zoho.crm.searchRecords("Leads","Email:equals:" + v_Email); fo ...; Created on 24 August 2021
13. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... = v_RelatedListXML + "No records found"; v_RelatedListXML = v_RelatedListXML + ""; } // // output return v_RelatedListXML; in Zoho Books // // find all related quotes l_DataRows = List(); v_QuoteRefID ...; Created on 30 July 2021
14. ZohoCRM: zoho.crm.searchRecords only returns certain records: / Zoho /; ... a custom related list on a Zoho Finance > Sales Orders module but it wasn't finding all the Quotes related to this Sales Order. How? The quick answer is buried in Zoho documentation and due to the ...; Created on 29 July 2021
15. Zoho Creator: Assign an integration field value with an integration value: / Zoho /; ... How? It is written in the documentation albeit difficult to find: an integration field returns an ID as a string. If you want to assign it to an integration field, you have to convert it to a number ...; Created on 27 July 2021
16. Zoho Deluge: Generate and Send a CSV via Email: / Zoho /; ... = "Please find attached the Audit Log for the events dated " + v_ThisEventTime.toString("yyyy-MM"); sendmail [ from: zoho.loginuserid to: zoho.adminuserid subject: v_Subject message: v_Message ...; Created on 16 June 2021
17. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; ... backend code, Zoho refer to Issues as "Bugs". Why? At time of this article (Apr-2021), we could not find a working example that could allow us to do this. I have provided some links at the end of ...; Created on 30 April 2021
18. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Deluge: / Zoho /; ... is likely to be a linking module which has a multi-select lookup on both the deal/opportunity and products module. A multi-user lookup will tend to have something like "ModuleName_X_Users". Find records ...; Created on 28 April 2021
19. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... article because I keep forgetting on how to do this. I have a specific order of steps on how I do this, you may find other ways but this is one that works for me. How? So here's an overview and then ...; Created on 06 December 2020
20. Zoho Creator: Set Up Custom Domain for Customer Portal: / Zoho /; ... registrar's control panel, go through the process until this part is complete. Find the DNS Manager in your control panel, it might be called something like "Advanced DNS Editor", "Advanced Zone Editor" ...; Created on 17 November 2020