Search - Joel Lipman .Com

1. Zoho Creator: Find Duplicates by Customer Name for Large Datasets: / Zoho /; ... and that's only half of the production system's contacts. I needed a quick bit of code to find any duplicates, all within the Zoho Creator app using Zoho Deluge and avoiding the use of any third-party APIs. ...; Created on 12 July 2023
2. 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
3. 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
4. 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
5. 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
6. 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
7. Zoho Workdrive: Getting Team Folder ID: / Zoho /; ... = "To he who shall not be named, Re: " + v_Subject + " Please find attached the CSV export file containing the Data. "; // if(!isBlank(v_PermaLink)) { v_Message = v_Message + " The export fil ...; Created on 11 September 2024
8. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... customer, you will know this takes a while to do: You have to find the contact record in CRM for example Click on "Send for Zoho Sign" Select the template document or upload one Add the fields that ...; Created on 06 August 2024
9. Zoho Projects: Get All Events: / Zoho /; What? A quick article because I couldn't find anything that documented this with a working example. Why? The use-case here is that we want to make a ZohoCreator page display events for this month ...; Created on 22 July 2024
10. Zoho Creator: Render to PDF with margins and page numbers: / Zoho /; What? There are already articles out there that document this but I use this more and more and would rather just find it on my site than going through multiple bookmarks. Why? This use-case is ...; Created on 07 May 2024
11. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... is mostly done in ZohoCreator. I could have setup webhooks to go directly to Zoho Creator but I don't find Zoho Creator reliable when receiving and responding to webhooks. Important!: For the REST ...; Created on 22 April 2024
12. ZohoCreator: Basic Widget with Zoho Data: / Zoho /; ... } // Setup a config to find this record (use a custom report that only has the 2 searchable fields) var config = { appName : "joes_quote_builder", ...; Created on 14 March 2024
13. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; What? A quick article with the code to download image attachments from a Zoho Ticket and then to upload the attachment to Zoho Analytics. Why? First of all, we couldn't find how to sync attachments ...; Created on 05 December 2023
14. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; What? An example of code using the new API call "Module Record Count" with some criteria. Why? At time of print, I couldn't find an example of how to use this API call with search filters or criteria. ...; Created on 14 November 2023
15. Zoho Creator: Sendmail a list of attachments: / Zoho /; ... from a public domain, no user wall. The key here which the official documentation is missing is the .setParamName() but for those who have spent time to find this function, they'll already know this. ...; Created on 20 July 2023
16. Zoho Deluge: Get All Orders from eBay: / Zoho /; What? Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay. Why? Our use-case is a data migration from eBay to a fresh instance ...; Created on 29 March 2023
17. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... or that has been added to the system based on the business hours set at the organization level in ZohoCRM. How? Using an invokeURL, the key here is you'll find them in the settings; so check that ...; Created on 28 March 2023
18. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... Correct error: Check and update the code in line 74 as there is a Exception : Value is empty and 'get' function cannot be applied More Information: Navigate to payments, then find pending webhook ...; Created on 16 March 2023
19. ZohoCRM: Get All eBay Active Listings: / Zoho /; What? Another one of these articles talking about getting all the active product listings from eBay for a specific client. Why? Our use-case scenario here is that we want to get an inventory ...; Created on 01 March 2023
20. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... // send via Email v_CountRows = l_CsvFileRows.size() - 2; v_Subject = "Shopify Products Export & Comparison"; v_Message = "Please find attached a log of " + v_CountRows + " Product(s) from Shopify ...; Created on 20 February 2023