Search - Joel Lipman .Com

1. ZohoBooks: Error 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. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... should get the following error: Please ensure that the shipping_address has less than 100 characters. How? If you get the above error, the community forums will advise you to get the ID of the ...; Created on 22 September 2021
3. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; What? This article serves as a best practice and reminder to myself on how to stop endless loops from happening in Creator and crashing the application. This is more for complex Creator forms which ...; Created on 19 September 2021
4. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirects: / Zoho /; What? This is an article to document how to have two submit buttons on a non-stateless form which both submit the form but one leaves the current record open while the other redirects to the reports ...; Created on 27 July 2021
5. Creating a Top 10 chart with less code: / Personal Home Page /; I've decided to put something in here as it took me an age to find out how I could do it. This is when using a MySQL query within a PHP script. The process is used often to do a statistics table or ...; Created on 18 February 2010
6. Sir James Dyson explains his bladeless fan: / Hobbies /; I love technologies that replace conventional methods and thought processes. In this video, Sir J. Dyson demonstrates a new type of fan which uses a fraction of the energy of normal fans. In the UK, ...; Created on 30 October 2009
7. Google Event Ilustrations aka Flairs: / Google /; ... oboe, clarinet, saxophone, cornett, trumpet, contrabass, cello, trombone, tuba, music ensemble, string quartett, guitar lesson, classical music, choir learnlanguage: French Course, German Course, English ...; Created on 05 December 2024
8. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Lead: / Zoho /; ... create task: Create a workflow that runs on lead create (record action) and the criteria can be where "Lead Conversion Time" is less than 4 (4 days not 4 business days?). Though I've removed this condition ...; Created on 14 May 2024
9. Zoho Webhooks & Shopify API: Keep Disappearing: / Zoho /; ... to simply storing the record in Zoho - Run HMAC SHA 256 verification ******************************************************************************* */ // // need to respond in less ...; Created on 22 April 2024
10. ZCRM Client Script: Correct Decimal Fields OnLoad: / Zoho /; ... record, they will get a validation error on the decimal field even if that's not the field that is being changed: Decimal places for the Unit Price field should be less than or equal to 6. How? ...; Created on 13 December 2023
11. ZohoCRM: Using Criteria with Module Record Count: / Zoho /; ... You can't compare a date time value to a field that is simply of datatype: date v_PerPage = 200; v_CountCriteria = "((Quote_Stage:equals:" + encodeUrl("Draft") + ")AND(Created_Time:less_than:" + encodeUrl("2023-11-01T01:00:00+01:00") ...; Created on 14 November 2023
12. Zoho Finance Suite Schedule: PATTERN NOT MATCHED: / Zoho /; ... Unless you can monitor when these type of schedules are failing, you won't see this error until you go in and try to save it again. How? The super quick answer is remove any spaces from the name ...; Created on 12 June 2023
13. Zoho Inventory: Enable Tracking using the API: / Zoho /; ... key here to enable inventory tracking m_CreateBooksItem.put("item_type","inventory"); // // other less important values to include re purchase information m_CreateBooksItem.put("product_type","goods"); m_CreateBooksItem.put("reorder_level",0); m_CreateBooksItem.put("available_stock",v_QuantityAvailable.toLong()); m_CreateBooksItem.put("initial_stock",v_Quantity.toLong()); m_CreateBooksItem.put("initial_stock_rate",v_ItemPrice.toDecimal()); m_CreateBooksItem.put("inventory_account_id",m_Accounts.get("Inventor ...; Created on 04 May 2023
14. 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
15. Zoho Deluge: Get All Orders from eBay: / Zoho /; ... 1000 ]) // the actual number may be less than this but this is for pagination estimates v_MaximumOrders = 10000; v_Year = 2022; // // set the filter for orders by status to return: All, Active, Cancelled, ...; Created on 29 March 2023
16. ZohoCRM: Integrate ChatGPT to ZohoZIA: / Zoho /; ... if you train OpenAI on a dataset, that dataset and the resulting model will not be accessible by external sources unless you choose to make it publicly available. OpenAI takes data privacy and security ...; Created on 06 March 2023
17. ZohoCRM: Get All eBay Active Listings: / Zoho /; ... page to start from v_StartingPageIndex = 1; // // specify the maximum number of products you think you have on eBay // the actual number will be less than this but this is for pagination estimates v_MaximumProducts ...; Created on 01 March 2023
18. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... defaults certain arguments to any prompt you submit. I don't really recommend this unless you're doing a batch of images which need to match the same style and dimensions. To start, type /prefer suffix ...; Created on 11 February 2023
19. ZohoCRM: Import Attachments: / Zoho /; ... Too Small (less than 1Kb)" } if(v_Col04 == "-") { v_Reason := "File not associated to a Zoho CRM Record" } v_CsvLine := v_Col01 "," v_Col02 "," v_Col03 "," v_Col04 "," v_Col0 ...; Created on 16 January 2023
20. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... location, for that’s the email id you need to send files to for those to show up on your Kindle. Getting your email ID approved Just having your Kindle email address won’t suffice unless you ...; Created on 29 June 2022