Search - Joel Lipman .Com

21. Zoho CRM: Change System Field Length: / Zoho /; ... but it is a workaround I have used and that worked when converting a lead to a deal. Note that this hack doesn't work on the system field label name (I tried) just on the length field. Use the translations ...; Created on 19 June 2023
22. ZohoCRM Webhook: Create ZohoInventory Records from an eBay order: / Zoho /; What? This is a not-so-quick article that queries an eBay order and creates the relevant ZohoInventory item, contact, sales order, package slip, shipment order, invoice, payment records... Why? ...; Created on 27 April 2023
23. ZohoAnalytics: Pivot Campaigns vs Contacts: / Zoho /; ... I always resort to a query when I get confused with the GUI: Query 1 Due to the limit of sub-query levels we can go down, I want to join this to the contacts data table. So I'm going to make this ...; Created on 20 March 2023
24. ZohoBooks: Stripe Terminal Integration: / Zoho /; ... :GET headers:m_Headers ]; // // get amount (used to capture payment intent) v_Amount = ifnull(r_PaymentIntentDetails.get("amount"),0); v_AmountReceived = ifnull(r_PaymentIntentDetails.get("amount_received"),0); v_AmountCapturable ...; Created on 16 March 2023
25. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... "Role" with the options: "user", "assistant", "system". Add a file upload field called "Big Data" Add a single line field called "Title" (used as a multi-line cannot be used in the listview). Add ...; Created on 06 March 2023
26. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... response or response of info: try holding down the ALT key and pressing 255, then releasing the ALT key and save the change to your code. This will not display a character but is a new line... Used ...; Created on 01 March 2023
27. ZohoDeluge: Get All eBay Orders Given a From and Till Date: / Zoho /; What? An article on how I can query all the orders for yesterday without using the eBay GUI Selling website. I've included the code to parse out the information as well. Why? Because I need this ...; Created on 28 February 2023
28. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... and should not be used in a commercial setting. Afro Samurai (Takashi Okazaki) Akira (Katsuhiro Otomo) Batman Charlie Brown (Charles Schulz) the Dark Crystal Dragonball (Akira Toriyama) Gankutsuou ...; Created on 11 February 2023
29. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openings: / Zoho /; ... // update the record (note the API name being used here) r_Create = zoho.recruit.addRecord("CustomModule6",m_Create,0,false,"my_connection"); //info r_Create; } } } } Fo ...; Created on 08 February 2023
30. ZohoCRM: Import Attachments: / Zoho /; ... of an "Attachments.csv" file that needs the correct values in each column and the "Attachments.zip" containing the files to attach that needs some formatting as well: Note that any IDs used in the snippets ...; Created on 16 January 2023
31. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... value in a field, a row would be added to a subform contained herein. How? Well I won't go in to detail on how to add a client script, this article is just to show the snippet of code used in the ...; Created on 09 December 2022
32. Zoho Analytics: Determine profits from invoices and purchase orders: / Zoho /; ... There may be many ways of doing this, this is just one way that we used that worked for 90% of the invoices. There are invoices that may be associated to sales orders changed after being confirmed or ...; Created on 03 November 2022
33. Zoho Recruit: Rollup Number of Recruit Candidates to CRM Account: / Zoho /; What? This is a quick article to note down some code used in Zoho Recruit. This particular bit of code will run on a workflow when a Candidate is modified, and it tallies all the candidates belonging ...; Created on 19 October 2022
34. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM template: / Zoho /; ... can only be the admin or the logged-in user (user who clicks on the button). There might be an easier way to get the template ID used in CRM, but we did this by Login to ZohoCRM > Settings > Template ...; Created on 18 August 2022
35. Zoho Creator: Populate a Multi-Lookup: / Zoho /; ... Error(s: Previously my code below was used and it wouldn't work. The difference to the above is that I was trying to add to the multi-lookup directly: // for each v_PackageRef in l_PackageRefs { // // ...; Created on 18 August 2022
36. Zoho Inventory: Mark a package slip as delivered and shipped: / Zoho /; ... = r_CreateShipment.get("shipment_order").get("shipment_id"); } } } // // maybe one is either used or created if(v_ShipmentID != "") { v_Url = "https://inventory.zoho.com/api/v1/shipmentorders/" ...; Created on 14 July 2022
37. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... , it may get confused as to where the photo came from and will error when displaying it. I think it will be fine. Source(s) Joel's tired and inefficient brain The non-existent and plethora of foru ...; Created on 31 March 2022
38. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... all monitors are now connected to my home PC. The way to do this might be different for you depending on the components of your PC. So here's a list of what I used: TypeComponentQuantityPrice (GBP) Reused ...; Created on 12 March 2022
39. Zoho CRM & Creator: Download attachment and upload to Creator file field: / Zoho /; ... At time of print, things have moved on and based on the Zoho official forums, this used to be a daunting task. Not anymore at least from what I've seen. You could try adding a subform to Creator ...; Created on 11 March 2022
40. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... AuthToken (Multi Line) AuthToken Expiry (Date-Time) You should end up with something like this screenshot: * Some of these fields are unnecessary for this example but are used to accommodate ...; Created on 14 February 2022