Search - Joel Lipman .Com

1. Zoho Deluge: Get All Orders from eBay: / Zoho /; What? Following on from my article: ZohoCRM: Get All eBay Active Listings, this is how to get all the orders from a client's eBay. Why? Our use-case is a data migration from eBay to a fresh instance ...; Created on 29 March 2023
2. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... on the employee record So now we just need to append the following code which loops through the map / associative array we just created and shove this onto every employee's record. My employee recor ...; Created on 28 March 2023
3. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; What? Following on from the article: Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo. This is the next step as we get it to look at data within ZohoCRM. Why? Because it is a serious improvement ...; Created on 06 March 2023
4. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; What? A super quick article on something that almost deserves its own article: using new lines in ZohoDeluge. Why? My use-case here is that I was generating a comma separated values (CSV) file ...; Created on 01 March 2023
5. Zoho Creator: Disable/Hide the add and delete subform row buttons: / Zoho /; ... Script, add the following: // // CSS overrides v_CssNotes = ""; // // this line hides the delete/cross icon next to each row v_CssNotes = v_CssNotes + ".subformRow .form-group"; // // this line ...; Created on 28 February 2023
6. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbo: / Zoho /; ... I don't know. Consider doing a Google search."); } } // // output return m_Response; Yields something like the following: Text-Davinci-003: (preceded ChatGPT API) // // initialize m_Respon ...; Created on 13 February 2023
7. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... prompt combining any of the following in a table (this is not an exhaustive / limited list). Do note that the images below were generated using MidJourney v4: Type of Photography Nature Photography ...; Created on 11 February 2023
8. ZohoCRM: Import Attachments: / Zoho /; ... the reverse process, the import file. The import file I got working had the following columns: Attachment Id: This needs to the unique filename of the actual file on disk (as opposed to "File Name" ...; Created on 16 January 2023
9. Zoho CRM: Manage a subform using Client Script: / Zoho /; ... Using the following line returns all subform rows, even deleted ones, which is why we didn't use this command in the system. But keeping it for future reference. var l_existingSubformRows = ZDK.Apps.CRM.Deployment_Rate_Log.fetch(); ...; Created on 09 December 2022
10. Zoho Analytics: Set Up a Widget Displaying Sales Person: / Zoho /; ... I select on a dashboard. First you will need a table or query that has a bunch of columns and rows with one of the columns containing the sale person name. Something like the following: With ...; Created on 24 October 2022
11. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM record: / Zoho /; ... to the Deal record. How? The following is the process from registering the app to call on the full API (grant code > refresh token > access token) and then the code to attach the document to the ...; Created on 17 October 2022
12. Zoho Creator: Populate a Multi-Lookup: / Zoho /; ... called "Zoho Inventory Package Slips" and I'm adding these to a Creator form called "Appointment", my code should be something like the following: // // get 100 most recent appointments where this field ...; Created on 18 August 2022
13. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Deluge: / Zoho /; ... output response to console info "Response of attempt to upload to Zoho Inventory:"; info r_UploadPhoto; You should get a response similar to the following: Caveat(s) The code above only ...; Created on 21 June 2022
14. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictures: / Zoho /; ... OnSubmit > click on Create Workflow Select you want to run some Deluge Script and plug in the following code if(!isnull(input.Zoho_Inventory_ID)) { // // specify your own Inventory/Books organization ...; Created on 31 March 2022
15. Zoho Creator: Radio group into Calendar Carousel: / Zoho /; ... for this, I created the following Creator form: The fields: Calendar Day Select (link name: Calendar_Day_Select || type Radio) Form CSS (link name: Form_Css || type Add Notes) Selected Value for ...; Created on 09 March 2022
16. 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
17. 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
18. 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
19. 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
20. 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