Search - Joel Lipman .Com

1. Zoho Deluge: Determine your Statement Execution Limit: / Zoho /; What? A very quick article on how to check what the statement execution limit is on the Zoho application you are working in. Why? Our use-case is that an application we built in Zoho Creator was ...; Created on 31 July 2024
2. Zoho Creator/Deluge: UnPredictable exception, Invalid statement found: / Zoho /; ... fix for the error: Execution Failed UnPredictable exception, Invalid statement found Line:(20) I cannot guarantee that this error doesn't appear for other reasons but I will add to this article ...; Created on 17 November 2021
3. 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
4. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Template: / Zoho /; What? An article on adding an accept and decline button on the estimate (aka Quote) notification template within ZohoBooks. Why? The use-case is simply that my client wants to make it easier for ...; Created on 04 November 2024
5. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Sign: / Zoho /; ... CRM, then skip this if statement if(v_ZohoSign_DocumentType == "CreditApplication") { v_RequestID = ifnull(m_Body.get("requests").get("request_id"),"0").toLong(); l_SearchResults = zoho.crm.searchRecords("zohosign__ZohoSign_Documents","Request_ID:equals:" ...; Created on 06 August 2024
6. Zoho Books / Inventory: Get Item Rate from a Price Book/List: / Zoho /; ... price book rate post saving a record in Zoho Deluge would fail because it was making too many function statements. How? I have this code triggered in a workflow when the sales order is created to ...; Created on 23 May 2024
7. Zoho Books: System Values Maps: / Zoho /; ... statements, I can feed these maps a textual value and it returns the ID to use. Some of these can be found elsewhere in my site but I'm putting all of them here just for quick reference. How? Note ...; Created on 07 November 2023
8. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 characters: / Zoho /; What? Another article on something I learned today despite never running into this issue before; but sending a billing/shipping address included in a request to create or update an estimate in ZohoBooks ...; Created on 18 September 2023
9. Zoho Creator: Find Duplicates by Customer Name for Large Datasets: / Zoho /; ... that key. I can't sit there entering one customer at a time. Even a loop would hit a statement execution limit. Why? My use-case is that I need this done over a dataset of 20k+ contact records ...; Created on 12 July 2023
10. 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
11. 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
12. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... Product Photography Real Estate Photography Still Life Photography Tech Photography Camera Angle Note that there others, I'm only listing ones that actually followed the prompt (eg. ...; Created on 11 February 2023
13. Amazon Kindle: Send PDFs to your Kindle: / Kindle /; ... steps to follow for getting your email address approved. Follow steps 1 – 5 as stated under Finding your Kindle email address. However, click on Preferences this time, instead of Devices. Scroll ...; Created on 29 June 2022
14. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; ... are zeros... But I'm keen on avoiding using loops where possible so we don't breach a statement execution limit in the Zoho app function. How? If we're not going to use loops, then the next best thing ...; Created on 08 February 2022
15. ZohoCRM: Template: not being able to edit a text box: / Zoho /; ... the header section) but then they changed address and couldn't change the template. So they had something like: $ $ $ $ $ 11 My Street, My City, My State, My Zip, My Country They wanted to get ...; Created on 25 January 2022
16. 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
17. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng): / Zoho /; ... are going to loop through picklist options (500 timezones) in CRM to select the most relevant one. If all this fails, then it defaults to a module called "States" which stores a default timezone and can ...; Created on 15 December 2021
18. Zoho Deluge: Generate List of TimeZones: / Zoho /; What? A quick article to take a list of options from a HTML select element and convert to a Zoho Deluge list that will eventually be used to populate a dropdown. Why? Because I find myself doing ...; Created on 19 October 2021
19. 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
20. Zoho Books: Display Sales Order Shipping Address on Package Slip: / Zoho /; ... City Another City Test State Test Zip Another State Another PostCode Test Country A different Country But the packing slip would display the Ship to address as the ...; Created on 07 October 2021