Search - Joel Lipman .Com

1. T-SQL functions to convert Strings to Tables: / Transact-SQL /; Applies to: Microsoft SQL Server 2008 R2 Microsoft SQL Server 2012 What? These were in a solution and I thought I'd note them on my site so I can refer to them more easily. How? Let's ...; Created on 20 August 2014
2. Functions to convert Hex 2 RGB and vice-versa: / AutoHotkey /; These are for autohotkey and in AHK code. Taken from Autohotkey forums topic 1878: From Hexadecimal to RGB From RGB to Hexadecimal Check for a valid hexadecimal value From Hexadecimal ...; Created on 27 September 2011
3. Zoho Deluge: Get the Week Number if Week starts on a Monday: / Zoho /; What? A quick article on determining the week number of the year if your week starts on a Monday and not a Sunday. Why? I think it's the US system which generally says that a week starts on a ...; Created on 06 July 2023
4. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; ... the method of "mega-functions", here is the code snippet for one function which will accept as parameter the eBay order reference and generate all the respective records in Zoho Inventory. We're using a ...; Created on 27 April 2023
5. ZohoCRM: Import Attachments: / Zoho /; ... FUNCTIONS fn_Slugify(v_Ugly) { StringLower, v_Ugly, v_Ugly v_Ugly := RegExReplace(v_Ugly, "/\s+/g", "_") v_Ugly := RegExReplace(v_Ugly, "/[^\w\_]+/g", "") v_Ugly := RegExReplace(v_Ugly, "/\_\_+/g", ...; Created on 16 January 2023
6. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... to Settings > Automations > Custom Functions > Select the function > Execute the function against a paid invoice - check the fields updated. Go to Sales > Invoices > Select an invoice > Click on "Comments ...; Created on 17 August 2022
7. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... fields in Zoho Inventory... and the list goes on. So in my job, we tend to create a few custom functions which will download any item from eBay to Zoho Inventory and vice-versa. Easy to make the function ...; Created on 31 March 2022
8. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... layout didn't work Choose field to validate > Select "Lead Status" Choose validation type as "Validate using function" and click on "Next" For functions, select "Write your own" Give it a function name, ...; Created on 11 February 2022
9. Zoho CRM: searchRecords with sorted results: / Zoho /; ... listed here, the standard searchRecords() and then the getRecords() functions: Set the record ID to your own record ID. Set the list of pages to the number of pages you want to search. Keep ...; Created on 10 February 2022
10. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... to Zoho CRM > Setup > Functions > New Function Function Name: fn_API_ReceiveXeroWebhook Display Name: FN - Xero - Receive Webhook Description: Function used to receive webhooks from Xero and parse ...; Created on 10 January 2022
11. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; What? An article to save time where a customer wants to click a button to generate a merged document in Writer and attach it to the CRM record. Why? Our use-case is that we have a client who has ...; Created on 21 October 2021
12. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... REST API function that will forward the payload data to Zoho Creator (Yes you will need CRM version Enterprise or Zoho One [that supports functions] for this process). So first off, here's a reminder ...; Created on 20 September 2021
13. Zoho Creator: Receive JSON via a Shopify Webhook: / Zoho /; ... Create a REST API Zoho CRM Function Go to Setup > Developer Space > Functions > New Function Give it a Function Name, I'll call mine fn_Shopify_Webhook_OrderUpdate Give it a Display Name, I'll give ...; Created on 15 July 2021
14. Zoho Projects: Add a Time Log to an Issue using Deluge: / Zoho /; What? This is an article to demonstrate how to log a time event under a Zoho Projects Issue using code (Zoho Deluge) rather than the graphical user interface (GUI). Note this would probably be similar ...; Created on 30 April 2021
15. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Deluge: / Zoho /; ... CRM modules called a "LinkingModule" (as opposed to standard modules and custom modules). Quick way to determine the API name of the linking module: Go to setup > Developer Space > functions. Create ...; Created on 28 April 2021
16. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... The trick in this solution was more about the process and what that process was. Reading the brief, and having written many custom functions for other Zoho apps, it would stand to reason that ...; Created on 10 December 2020
17. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... Workflow > Functions > New Function: give the function a name select "Deluge" as the language give it a Namespace (for this example I will leave this on "Default") and set the return type (again in ...; Created on 06 December 2020
18. Zoho Creator Page: Toggle On/Off Switch: Hide/Display a Div: / Zoho /; ... the Zoho Creator page. Functions are read by Zoho and certain CSS attributes (such as position and float) will be removed automatically. The code has to be pasted directly in the Page and then the CSS ...; Created on 22 October 2020
19. Zoho Deluge - Pad with leading Zeros: / Zoho /; ... ", "0"); } This looks like pretty old code and not wanting to cause offence, it isn't the JavaScript style or chain I like which appends the functions instead and is clearer for me personally to ...; Created on 07 February 2020
20. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; ... is a function I find myself using more and more called equalsIgnoreCase() which could be used: ... l_ProductDetails = Product[Product_Name.equalsIgnoreCase(v_Name)]; ... Other Functions of ...; Created on 21 November 2019