Search - Joel Lipman .Com

21. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... c_Employee.Usual_Shift.insert(c_UsualShift); info "-------------"; } Yields something like: Error(s) Encountered Value is empty and '1234567000001234567' function cannot be applied: ...; Created on 28 March 2023
22. ZohoDeluge: Check Shipment Status via DHL API: / Zoho /; What? A quick note here on how to connect to the DHL API and check on a package given a tracking number. Why? In our megafunction to generate a customer, a product/item, a sales order, an invoice, ...; Created on 21 March 2023
23. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... click on "Done" Now click on "Edit Function" under "Context Handler Function" We're going to use the following deluge code for our first pass at this awesome functionality: // / ...; Created on 06 March 2023
24. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... So we're going to use a ZohoCRM function to get this file which we can run on demand. Why not in Zoho Inventory or any other Zoho app? Because we like to challenge ourselves... Once again, I'm not ...; Created on 01 March 2023
25. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; ... function too often either for debugging/monitoring purposes but it's easier to use an access token then getting the OAuth access codes from the client. How? I'm going to split this into 2 code snippets ...; Created on 28 February 2023
26. Zoho Deluge: Shopify API: Get all active products with GraphQL and Pagination: / Zoho /; ... } } } The Deluge Code So this is a Zoho Creator function that I'm going to call API.fn_ShopifyQuery_UpdateAllProducts() and it will be added to a nightly schedule. It's aim is to recover all ...; Created on 20 February 2023
27. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... this one "jl_recruit". The Deluge code for workflow /* ******************************************************************************* Function: void fn_AB_AssociateVacancy2Candidate(int ...; Created on 08 February 2023
28. 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
29. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; What? This is an article describing a custom function built into Zoho Flow that will accept as parameter the document_id and request_id. It then retrieves the Deal Reference (entered by an office signee) ...; Created on 17 October 2022
30. Zoho Books/Inventory: Trigger a workflow when an invoice has been paid: / Zoho /; ... and payment date to appear on the invoice. How? This sounds rather straightforward, write a function that given an invoice, checks the customer payments and updates the custom fields. Executing ...; Created on 17 August 2022
31. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... uploads 1 photo. Error(s) Encountered The endpoint is wrong (for example you don't need the organization ID parameter at the end of the URL) The .setParamName() function is setting the data ...; Created on 21 June 2022
32. Zoho Creator: Embed Forms/Reports on a Page: / Zoho /; What? Well known by most but this serves as a quick reminder to myself and anyone else on how to embed a form or a report into a Zoho Creator page. Why? Cos How? The below is a template ...; Created on 05 May 2022
33. 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
34. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... Cable (White) 1 £19.99 Build & Cost Breakdown Initial Build Total (functional PC, onboard GPU, 32Gb RAM, Previous O/S): £1,099.81 Second Part Build Total (GPU, RAM doubled, Windows 11 Pro, other): ...; Created on 12 March 2022
35. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... the attachments on the CRM record from within the Creator app. As for the add a new attachment, well that's just functionality. Here's my Creator form (well the part for the attachments): An attachments ...; Created on 11 March 2022
36. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... I have: What I want: How? This was achieved using some CSS and then some Deluge for the functionality. Let's dig into the CSS and then I'll explain how we made this functional. To prepare ...; Created on 09 March 2022
37. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... was to recover the relevant product based on any given Product SKU. Making the above into a function as well as returning the inventory item ID and the product ID: map API.fn_SearchShopifyBySKU( string ...; Created on 14 February 2022
38. Zoho CRM: searchRecords with sorted results: / Zoho /; What? This is an article to document how to use the searchRecords function in CRM and to sort the results response. Why? This is unclear and not always working as coded below since each system ...; Created on 10 February 2022
39. 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
40. Zoho Deluge: a HTML Entity Decoder: / Zoho /; ... time of print, it doesn't exist and in the meantime, I've made a function that does this. How? Not sure how else to do this but I simply wrote a function in Zoho Creator for each instance that I knew ...; Created on 27 January 2022