Search - Joel Lipman .Com

1. ZohoBooks: Code 15 Ensure Billing Address has less than 100 characters: / Zoho /; ... however gives me the following error: { "code": 15, "message": "Please ensure that the billing_address has less than 100 characters." } How? So the quick answer is 2 separate API calls after ...; Created on 18 September 2023
2. Zoho Books: Get Invoice Payment Terms via API: / Zoho /; ... clients set their due dates differently. How? The following snippet of code will query the metadata api in Zoho Books and return a JSON of what the payment terms are. void fn_ReturnCurrentPaymentTerms() { v_BooksOrgID ...; Created on 06 July 2023
3. Zoho CRM: Change System Field Length: / Zoho /; ... the attribute. Also remove the class names "disableEditProp" and "eventNone". You should get the following: Click on "Done", then on "Save and Close". Go to the Lead Conversion Mapping page (Setup ...; Created on 19 June 2023
4. Zoho Finance Suite Schedule: PATTERN NOT MATCHED: / Zoho /; What? A super quick article on resolving this issue if it ever appears again. Why? At time of print, this error was happening to schedules in Zoho Books, Zoho Inventory, and Zoho Subscriptions. ...; Created on 12 June 2023
5. Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkit: / Zoho /; ... / configuration. Instead, we prepare the following set of instructions for the client to give to their IT administrator. If the client registered their domain with a domain registrar, then they need ...; Created on 04 May 2023
6. 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
7. 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
8. 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
9. ZohoDeluge: Inserting a new line character in a CSV: / Zoho /; ... in certain cases v_NewLineChar = hextoText("0A"); Thought I needed to add the following but this makes absolutely no difference: f_CSVFile.setCharSet("UTF-8"); f_CSVFile.setFileType("csv"); ...; Created on 01 March 2023
10. 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
11. 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
12. 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
13. 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
14. 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
15. 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
16. 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
17. 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
18. 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
19. 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
20. 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