Search - Joel Lipman .Com

21. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPU: / Articles /; ... up to 2, right through 3 to 1, then down to 5... Now it all blends together: Error(s) Encountered: DisplayPort to DVI cable doesn't work: I get what I pay for I guess... I went for a slightly more expensive ...; Created on 12 March 2022
22. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL): / Zoho /; ... if your search query string has spaces in it, the above without the small apostrophes (single-quotes) will return either a parsing error or just no data. In the line: v_GraphQl = " product } } } }" Change ...; Created on 14 February 2022
23. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile): / Zoho /; ... && l_DisallowedOptions.contains(v_LeadStatus)) { m_Output.put("message","Your user profile does not allow you to change the lead status back to \"" + v_LeadStatus + "\""); m_Output.put("status","error"); } } // // ...; Created on 11 February 2022
24. Zoho CRM: searchRecords with sorted results: / Zoho /; ... in l_SearchResults { // check that there is an ID on this record to avoid looping through error messages if(!isNull(r_Result.get("id"))) { // do stuff to each record... info r_Result.get("id"); } } // // ...; Created on 10 February 2022
25. ZohoCRM: Template: not being able to edit a text box: / Zoho /; ... of getting an MS Word document to behave?). Best thing to do if you mess it up, is just start again with a clone of the original erroring template. Conclusion Just clutching at straws here with ...; Created on 25 January 2022
26. Zoho Creator: eBay: Get Item Transaction: / Zoho /; ... = "GetItemTransactions"; m_Headers.put("X-EBAY-API-CALL-NAME",v_ApiCall); m_Headers.put("X-EBAY-API-IAF-TOKEN",v_AccessToken); // // build params m_Params = Map(); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB"); m_Params.put("DetailLevel","ItemReturnCategories"); // // ...; Created on 22 January 2022
27. Zoho Creator: Receive eBay Notification and Create Shopify Order: / Zoho /; What? This is an article documenting how to parse the notification from eBay and using it to create an order in Shopify. Why? Previously, we would receive an eBay notification and create an ...; Created on 21 January 2022
28. Zoho Analytics: Setup DataSource via FTP Connection: / Zoho /; What? So this is going to be an article with a bunch of pictures showing step-by-step of how I setup a recurring data source in Zoho Analytics via FTP. Why? The use-case here is that I have a ...; Created on 12 January 2022
29. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense): / Zoho /; ... m_Data; // // JSON request r_TwilioResponse = invokeurl [ url :v_Endpoint type :POST parameters:m_Data ]; } Error(s) Encountered The 'To' number XXXXXXXXXX is not a valid phon ...; Created on 16 December 2021
30. Zoho CRM: Schedule a Call using Deluge: / Zoho /; ... = zoho.crm.createRecord("Calls", m_ScheduleCall); info r_ScheduleCall; Error(s) Encountered: ,"message":"invalid data","status":"error"} correct Call_Start_Time to CRM format of yyyy-MM-ddTHH:mm:ss-05:00 ...; Created on 18 November 2021
31. 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
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 Creator / eBay: Get all Active Products: / Zoho /; ... = "GetMyeBaySelling"; m_Headers.put("X-EBAY-API-CALL-NAME",v_ApiCall); m_Headers.put("X-EBAY-API-IAF-TOKEN",v_AccessToken); // // build params m_Params = Map(); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB"); m_Params.put("DetailLevel","ItemReturnCategories"); // // ...; Created on 13 October 2021
34. Zoho Creator / Shopify: Get all Active Products: / Zoho /; ... r_ShopifyProduct in r_GetProducts.get("products") { if(!isnull(r_ShopifyProduct.get("id"))) { // // an error-prone one-liner so that we don't hit an execution statement limit v_ProductSKU ...; Created on 12 October 2021
35. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; What? An article to note something I didn't realize I needed: How to address the above error and how to update a Shipping Address for a specific Sales Order in Zoho Books. Why? You might think ...; Created on 22 September 2021
36. Zoho Creator: Receive eBay Order Notifications via Webhook: / Zoho /; ... build params m_Params = Map(); // set to application or user to see the notifications for each m_Params.put("PreferenceLevel","User"); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB"); // // ...; Created on 20 September 2021
37. Zoho Deluge: Push a value to a datetime field in CRM: / Zoho /; What? A very quick article to show pushing the date and time to ZohoCRM or ZohoCreator. Why? You may have received an error that goes something like: datatype: datetime How? Here are ...; Created on 10 September 2021
38. Zoho CRM & Zoho Books: Custom Related Lists Deluge: / Zoho /; ... m_RelatedList; Error(s) Encountered Sorry, there was a problem processing your request.: Your returned XML is invalid Sorry, there is a tag discrepancy in the function. The related list canno ...; Created on 30 July 2021
39. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirects: / Zoho /; ... Add your deluge code that should: Validate the fields (checks mandatory fields have been entered) for example: // // check mandatory fields have been entered l_Errors = List(); if(isnull(input.Record_Name)) { l_Errors.add("- ...; Created on 27 July 2021
40. Zoho Creator: Assign an integration field value with an integration value: / Zoho /; ... update an integration field via deluge with another integration field or even the same integration field, it will return an error Unable to update the value to r_RecordDetails.Account. Line:(442) ...; Created on 27 July 2021