Search - Joel Lipman .Com

1. How to Display Report Execution Time in SSRS (milliseconds): / SQL Server Reporting Services /; How to Display Report Execution Time in SQL Server Reporting Services 2008 R2 So there are other articles out there but I was looking to display in milliseconds the execution time it took for a particular ...; Created on 17 November 2011
2. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... quick parsing instruction to get the eBay photos; this snippet stores the URL of each picture in a list variable: l_Pictures = x_MainNode.executeXPath("//Item/PictureDetails/PictureURL/text()").toXmlList(); / ...; Created on 21 June 2022
3. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... Another REST API CRM function which generates an eBay Access Token for me r_Response = getUrl("https://www.zohoapis.eu/crm/v2/functions/fn_ebay_getaccesstoken/actions/execute?auth_type=apikey&zapikey=1003."); if(!isnull(r_Response.toMap().get("details"))) { if(!isnull(r_Response.toMap().get("details").get("output"))) { v_AccessToke ...; Created on 31 March 2022
4. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... ******************************************************************************* Function: fn_Validate_LeadStatusChange Trigger: Function executed when a record is changed Inputs: ...; Created on 11 February 2022
5. Zoho CRM: searchRecords with sorted results: / Zoho /; ... in mind script execution limits set by Zoho. Set the search criteria string to your specific requirements (:equals:, :starts_with:, |=|). If 1 expression then you can omit the parenthesis. If multiple ...; Created on 10 February 2022
6. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... are zeros... But I'm keen on avoiding using loops where possible so we don't breach a statement execution limit in the Zoho app function. How? If we're not going to use loops, then the next best thing ...; Created on 08 February 2022
7. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
8. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... = ""; v_AccessToken = ""; r_Response = getUrl("https://www.zohoapis.com/crm/v2/functions/fn_api_getxeroaccesstoken/actions/execute?auth_type=apikey&zapikey="); if(!isnull(r_Response.toMap().get("details"))) { if(!isnull(r_Response.toMap().get("details").get("output"))) { v_AccessToken ...; Created on 10 January 2022
9. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense): / Zoho /; ... Reminder 1 Hr Before" When is "On a Date/Time" based on "Call Start Time" with execution date "On" the date and execution time "1 hour before". Condition 1: rule is applied to all calls Action is the ...; Created on 16 December 2021
10. Zoho Creator/Deluge: UnPredictable exception, Invalid statement found: / Zoho /; ... fix for the error: Execution Failed UnPredictable exception, Invalid statement found Line:(20) I cannot guarantee that this error doesn't appear for other reasons but I will add to this article ...; Created on 17 November 2021
11. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... to go to the CRM record, click on Mail Merge, which opens Writer, then has to click on various settings and run the Mail Merge; then has to click on "execute function after merge" and select the function ...; Created on 21 October 2021
12. Zoho Creator / eBay: Get all Active Products: / Zoho /; What? This is an article to document a function used in Zoho Creator to retrieve the Product IDs of all the active products in a client's eBay store. Why? The use-case was that I wanted to retrieve ...; Created on 13 October 2021
13. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... r_ShopifyProduct in r_GetProducts.get("products") { if(!isnull(r_ShopifyProduct.get("id"))) { // // an error-prone one-liner so that we don't hit an execution statement limit v_ProductSKU ...; Created on 12 October 2021
14. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... = "https://www.zohoapis.com/crm/v2/functions/fn_ebay_webhook_ordernotification/actions/execute?auth_type=apikey&zapikey=1003.aaaabbbbccccddddeeeeffff11112222.33334444555566667777888899990000"; // // ...; Created on 20 September 2021
15. Zoho CRM REST API: Stop Workflow from Triggering: / Zoho /; ... So there are a few trigger options but I'm listing the one(s) to stop workflows below to see if this helps anyone: Stop Workflows from executing: l_Quotes = List(); l_Quotes.add(m_CreateCrmQuote); m_Data ...; Created on 16 June 2021
16. Zoho Deluge: Convert Map to HTML Table without a FOR loop: / Zoho /; What? A very quick article on converting a Map string into a HTML table without using a for each loop. Why? I have quite a big response from our CRM that hits a statement execution limit if I ...; Created on 11 January 2021
17. Zoho People: Reject an Application for Leave in Deluge based on Criteria: / Zoho /; ... OnValidate Trigger: Function executed on the application of a leave Inputs: string p_RequestID,string p_Dept,string p_LeaveFrom,string p_LeaveTill Outputs: map/collection Date ...; Created on 10 December 2020
18. Zoho Creator: Button on Report for Merging Multiple Selected Records: / Zoho /; ... your action item Name the workflow Execute the action for Collection of record (this step is very important!) And you should have something like the following: Click through on "Add New Action": ...; Created on 06 December 2020
19. Zoho Creator: Create a Widget which uses JavaScript: / Zoho /; ... worry about knowing anything about nodejs, as long as you know JavaScript and HTML/CSS you can use this: Execute the download and go through the installation process with the final step to move i ...; Created on 24 October 2020
20. AutoHotkey: App GUI Listview to Rename Files: / AutoHotkey /; ... File 2.txt My File 3 (2).wav My File 3.wav My File 3 (3).wav How? So if you copy the following code into an AutoHotkey file and execute it, it will popup an app with 3 buttons: 1st to generate ...; Created on 08 July 2020