Search - Joel Lipman .Com

21. Zoho CRM: Schedule a Meeting using Deluge: / Zoho /; What? Following on my article of creating a task using Zoho Deluge and scheduling a call using Zoho Deluge, here's an article on creating a Meeting or an Event using Zoho Deluge. Why? Because at ...; Created on 02 March 2022
22. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... form (I call mine "API Integration") ready with the following fields: Connection Name (Single Line) Dev ID (Single Line) Client ID (Single Line) Shop ID (Single Line) Client Secret (Single ...; Created on 14 February 2022
23. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... eg. "fn_Validation_LeadStatusChange", a display name, eg. "Fn - Validation - Lead Status Change", and a description... You will be presented with a deluge IDE editor. I'm putting in the following code: /* ...; Created on 11 February 2022
24. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... that in the following regex, and if using Zoho Creator, you need to replace the double-backslash with a single backslash: v_Test1 = 12.300; info v_Test1.toString().replaceAll("(\\.\\d*?[1-9])0+$", ...; Created on 08 February 2022
25. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... can use the following code, note that the parameter is the eBay Item ID: void API.fn_eBayQuery_GetItemTransaction(int p_ItemID) { /* Function: fn_eBayQuery_GetItemTransaction() Input: ...; Created on 22 January 2022
26. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; ... order record in Zoho Creator. We did the same for when Shopify would process an order. You can see my following articles for more information on these: Zoho Creator: Receive eBay Order Notifications ...; Created on 21 January 2022
27. ZohoCRM & Xero Real-Time Invoices: Receive Webhook: / Zoho /; ... these into data for invoices and contacts. Category: Standalone Click on Create Give it the parameter: crmAPIRequest (string) Dump in the following code: // enter the webhooks key for your app ...; Created on 10 January 2022
28. Zoho Creator/Deluge: Calculating with Timezone Offset: / Zoho /; ... Daylight Savings Time is in effect for this timezone or not. So let's pretend we have a creator form wth the following fields: TZ Database Name (single-line) UTC Offset (single-line) UTC DST Offset ...; Created on 07 December 2021
29. Zoho CRM: Schedule a Task: Timesheet Reminder: / Zoho /; ... time in our CRM. We're meant to do 40 hours, not just for Management, but for deducting from project and support bundles. How? The following snippet of code is on a CRM schedule set to run every ...; Created on 02 December 2021
30. Zoho Creator/Deluge: UnPredictable exception, Invalid statement found: / Zoho /; What? Just a quick article if you get the above error and what to look for. Why? I was writing a function with perhaps too many for each loops within a for loop. How? The following is 1 ...; Created on 17 November 2021
31. Zoho Creator: Copy Subform to other Subforms: / Zoho /; ... The form I have looks something like the following: and displays as something like this: The code I create a workflow that when the decision box "Copy Monday to the Other Days" is clicked it ...; Created on 17 November 2021
32. Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time field: / Zoho /; ... to add 10 minutes to a date/time field in ZohoCRM and wanted a refresher for use in a client system. The usual error is something similar to the following: { "code": "INVALID_DATA", "details": { ...; Created on 11 November 2021
33. Zoho Deluge: Today, Tomorrow, Day After but Skip Sunday: / Zoho /; ... PDT 2022,Fri Jul 29 00:00:00 PDT 2022 But if I were to maintain the idea above and skip a selected day, I would write something like the following: // // initialize list to hold valid appointment ...; Created on 02 November 2021
34. Zoho Creator: Change Radio into Tabs: / Zoho /; ... workflow Load of the form Name the workflow, I'm calling mine OnLoad Add New Action > Deluge Script: And I add the following to my deluge script, to remove the label "Tabs": v_Css = ""; v_Css ...; Created on 22 October 2021
35. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attach: / Zoho /; ... and ZohoWriter.Merge.ALL For good measure, I'm going to include the scopes: WorkDrive.files.ALL, WorkDrive.workspace.ALL Click on Create and Connect > Accept Get the Template ID The following ...; Created on 21 October 2021
36. Zoho Creator: Public URL of an Image field / Upload to Shopify API: / Zoho /; ... + v_ListingPublishKey + "/" + v_Filename; URL Syntax #4 The following won't work for the example below as it doesn't have the publish/public key, but it can be used internally: // DOESN'T WORK ...; Created on 17 October 2021
37. 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
38. Zoho CRM: Get Unique Values of a Text Field: / Zoho /; ... this returns something like the following (I've reduced the 200 records to about 6 of them): { "data": [ { "Currency": "EUR", "id": "123456789000000001" }, { "Currency": ...; Created on 08 October 2021
39. Zoho Books: Display Sales Order Shipping Address on Package Slip: / Zoho /; ... on In the left button menu, click on Header Scroll down and click on Shipping Address Format (Custom) Enter the following placeholders: $ $ $ $ $ $ $ Done Source(s): The brilliant ...; Created on 07 October 2021
40. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... the following request to create a Sales Order in Zoho Books would be enough: { "date": "2021-09-08", "zcrm_potential_id": "123456789012345678", "currency_code": "GBP", "reference_number": "Salespersons ...; Created on 22 September 2021