Search - Joel Lipman .Com

1. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; What? Thought I'd put an article here to remind me how to make the retrieval of a record case-insensitive. Why? Consider that I have the following creator table: Product_Name Product_SKU ...; Created on 21 November 2019
2. Convert to Proper Case in T-SQL: / Transact-SQL /; What? So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it ...; Created on 04 June 2014
3. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCase: / SQL Server Integration Services /; ... people on the net, I've been given a datasource with names and addresses all in UPPERCASE. Initially, no one seemed bothered but now the request came through asking if this could be restored to a normal ...; Created on 04 October 2013
4. SQL: Use CASE for Relevance column: / MySQL /; ... columnID, columnFullName, CASE WHEN columnFirstName LIKE @ThisSearch THEN 20 WHEN columnFullName LIKE @ThisSearch THEN 10 WHEN ...; Created on 03 August 2013
5. T-SQL example of Case-Sensitive Soundex: / Transact-SQL /; What? This article is for demonstrating how to use a SOUNDEX in a select and then listing all the variations based on case-sensitivity. Why? We have a database with data in it. For a particular ...; Created on 10 October 2012
6. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkit: / Zoho /; ... the following instructions to these instead. ZohoCRM: Get Details as Zoho User The values are the same for the CRM app for all organizations, but in case these change since time-of-print of this ...; Created on 04 May 2023
7. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
8. 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
9. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; ... a shipment as delivered only if the courier, in this case DHL, confirms the tracked order was delivered. How? So first I'll give some brief instructions on how to get an API key from DHL as a developer ...; Created on 21 March 2023
10. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... ", m_Message.get("Content")); l_ConversationMessages.add(m_Chat); } } // // storing latest user input v_UserMessage = ifnull(userInput,""); if(!isBlank(v_UserMessage) && !v_UserMessage.equalsIgnoreCase( ...; Created on 06 March 2023
11. 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
12. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; What? A super quick article on something that almost deserves its own article: using new lines in ZohoDeluge. Why? My use-case here is that I was generating a comma separated values (CSV) file ...; Created on 01 March 2023
13. Zoho Creator: Disable/Hide the add and delete subform row buttons: / Zoho /; What? A really quick article on how to hide these using CSS... at least until Zoho have this as a setting using the GUI. Why? Our use-case is that we have a subform which gets autopopulated with ...; Created on 28 February 2023
14. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; What? An article to resolve my frustration in being able to ONLY retrieve the first 100 products using GraphQL, so page 1 of Shopify products. Why? Our use-case is that we retrieve the 100 most ...; Created on 20 February 2023
15. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... e if(r_ChatGPTResponse.get("responseCode") == 429) { // store in response text v_Answer = "I dont have any knowledge in this. Please ask me something else"; } } else if (v_Message.containsIgnoreCase("H ...; Created on 13 February 2023
16. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... I want to remember them in case I learn how to use them): YouTube - Making the Photo YouTube - Future Tech Pilot GitHub - Willwulfken / MidJourney Styles Aboriginal Dot Acidwave Art Brut Ar ...; Created on 11 February 2023
17. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; What? This article is just in case it comes up again (has twice now) where a client wants a report on candidates and associated job openings in Zoho Recruit. Why? We're creating a custom module ...; Created on 08 February 2023
18. ZohoCRM: Import Attachments: / Zoho /; ... Our use-case here is a data migration for a client from a legacy CRM to ZohoCRM. They have a lot of files they want attached to their respective records in CRM. This took me a while as our own documentation ...; Created on 16 January 2023
19. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... The expected outcome is the appending of a row to the subform based on the start date (first field in the subform) match in which case it should re-add the row with an "End Date" specified (blank or not). ...; Created on 09 December 2022
20. Zoho Deluge: Generate a loop or list of any size: / Zoho /; ... it to a list, then lets you generate an array or list of any size. Why? My use case here is to run a schedule that will populate a list with the upcoming dates for the next week (and for any numbers ...; Created on 21 October 2022