Search - Joel Lipman .Com

1. Zoho Deluge: Proper Case for Names: / Zoho /; What? This is an open article without any completion in mind; to set the proper case of a name, as in capitalize the first letter, lower case the rest but then with exceptions. Why? Some of the ...; Created on 13 July 2023
2. 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
3. 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
4. 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
5. 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
6. 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
7. Zoho Creator: Find Duplicates by Customer Name for Large Datasets: / Zoho /; ... that key. I can't sit there entering one customer at a time. Even a loop would hit a statement execution limit. Why? My use-case is that I need this done over a dataset of 20k+ contact records ...; Created on 12 July 2023
8. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; ... we're generating a reporting year and week, we have to look at the difference between .toString("y") and .toString("Y"). Lowercase 'y' is the year and uppercase 'Y' is the year the week is in. Weeks which ...; Created on 06 July 2023
9. Zoho CRM: Change System Field Length: / Zoho /; What? This is an article documenting how to remove the block on changes to a system field in ZohoCRM. Why? Our use-case today is that a customer wanted to map the Postal Code or Zip from a Lead ...; Created on 19 June 2023
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. 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
17. 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
18. 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
19. 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
20. 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