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 Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; What? An article on adding an accept and decline button on the estimate (aka Quote) notification template within ZohoBooks. Why? The use-case is simply that my client wants to make it easier for ...; Created on 04 November 2024
8. Zoho Creator: Input Color Picker: / Zoho /; ... on one to select it. When are colors used? Well in this use-case, we are using it to color events in a calendar associated with specific staff. Probably not the most essential part of a system ...; Created on 14 October 2024
9. Zoho Deluge: Convert Hex to RGB: / Zoho /; ... value v_HexValue = v_HexGiven.replaceAll("#", "").toUpperCase(); // // using a regular expression: split into pairs of characters or if short hex given, then split into 3 characters l_HexParts = v_HexValue.replaceAll("(?)",",",false).toList().subList(1,4); if(v_HexGiven.toString().len()>4) { l_HexParts ...; Created on 11 October 2024
10. ZohoCRM: Make either Mobile or Email mandatory: / Zoho /; What? A really quick article on a pretty cool requirement, making 2 fields mandatory but if one is completed then making the other optional. Why? My use-case is that the mobile or email field ...; Created on 03 October 2024
11. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... logged in user (who clicked the button) v_LoggedInUserID = 0; r_Users = zoho.crm.getRecords("users"); for each m_User in r_Users.get("users") { if(m_User.get("email").equalsIgnoreCase(zoho.loginuserid)) { v_LoggedInUserI ...; Created on 06 August 2024
12. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; What? A very quick article on how to check what the statement execution limit is on the Zoho application you are working in. Why? Our use-case is that an application we built in Zoho Creator was ...; Created on 31 July 2024
13. Zoho Analytics: Create a Monitoring System with Images: / Zoho /; What? This is an article to remind me how I did this for a customer and images help visualize the health of the system. Why? The use-case here is to build a system which monitors a Zoho App for ...; Created on 25 July 2024
14. 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
15. ZohoAnalytics & ZohoBooks: Custom Related List from Analytics: / Zoho /; What? A quick article to document 2 features in deluge code: a custom related list in ZohoBooks, and a reminder on how to read a table from ZohoAnalytics. Why? My use-case here is that we have ...; Created on 09 July 2024
16. Zoho Analytics & Zoho People: Monitor DataSource Sync: / Zoho /; ... = ifnull(m_ResponseData.get("dataSources"),List()); for each m_DataSource in l_DataSources { if(m_DataSource.get("datasourceName").equalsIgnoreCase("Zoho People")) { v_LastSyncTime = m_DataSource.get("lastDataSyncTime"); v_LastSyncStatus ...; Created on 02 July 2024
17. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... by going through forum posts from 7 years to 2 years ago. The following will work in May 2024 following the API domain change. The use-case is that the customer wants the item/product rate taken ...; Created on 23 May 2024
18. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... reminder to the lead record owner but to no avail. An assignment rule wouldn't work in this case as it had to be the lead owner (there is no owner at assignment rule stage). A workflow email notification ...; Created on 14 May 2024
19. 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
20. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... ) != null) { // // my app is the only one using the orders/updated webhook topic/trigger if(m_ThisWebhook.get("topic").equalsIgnoreCase("orders/updated")) { b_RestoreOrderUpdateWebho ...; Created on 22 April 2024