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 Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; ... other than what the interface offers, into the template. the CRM webhook API function So let's do my favorite method of creating a REST API function in CRM Login to ZohoCRM > Setup > Functions ...; Created on 04 November 2024
4. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... ZohoCRM > Setup > Functions > and hover the mouse over the function you just created above (eg. Fn - ZohoSign - Document Completed) Hover the mouse over the ellipsis that appears and select "REST API ...; Created on 06 August 2024
5. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... */ // // set your own REST API endpoints for the webhooks here (we are only checking order update or inventory level update) v_CrmOrderUpdateWebhook = "https://www.zohoapis.com/crm/v2/functions/fn_shopify_webhook_orderupdate/actions/execute?auth_type=apikey&zapikey=1003.aaaabbbbccccddddeeeeffff00001111.22223333444455556666777788889999"; v_CrmInventoryLevelWebhook ...; Created on 22 April 2024
6. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Report: / Zoho /; ... Functions" Click on the Plus icon alongside this, scroll down to "Custom Functions" and click on "New" I give it the function name fn_Tickets_OnCreateEdit I click on "Edit Arguments" and give it th ...; Created on 05 December 2023
7. 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
8. 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
9. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... create a connection in ZohoRecruit: Go to Setup > Developer Space > Functions Create or Edit a function At the top of the IDE there will be a "Connections" link to click on. Click on "Create Connection". ...; Created on 08 February 2023
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. 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
17. 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
18. 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
19. 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
20. 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