Search - Joel Lipman .Com

1. 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
2. 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
3. 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
4. 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 order ...; Created on 21 January 2022
5. 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
6. 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
7. 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
8. 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
9. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.: / Zoho /; ... "Test Street 2", "city": "Test City", "state": "Test State", "zip": "Test Postal Code", "country": "Test Country" } } However, if you try forcing the billing or shipping address in yo ...; Created on 22 September 2021
10. Zoho Creator: Prevent Endless Loops On User Input of a Field: / Zoho /; ... if statement to all fields? Well no again, just compare on the workflow of the audit change. Something along the lines of: Add an Audit Change field: This will contain the code triggered when one ...; Created on 19 September 2021
11. Zoho Creator: Add a subform while creating a record: / Zoho /; ... v_AddressLine1 = r_ContactDetails.get("Street"); v_AddressCity = r_ContactDetails.get("City"); v_AddressState = r_ContactDetails.get("State"); v_AddressZip = r_ContactDetails.get("Zip"); ...; Created on 14 July 2021
12. Zoho Deluge: Convert Map to HTML Table without a FOR loop: / Zoho /; What? A very quick article on converting a Map string into a HTML table without using a for each loop. Why? I have quite a big response from our CRM that hits a statement execution limit if I ...; Created on 11 January 2021
13. Zoho Creator: info/alert/modal/popup notification for any user: / Zoho /; ... submission of a stateless form, in deluge: v_nTitle = encodeUrl("Test"); v_nText = encodeUrl("Test Content"); openUrl( "#Page:Notify?p_NotifyTitle="+v_nTitle+"&p_NotifyContent="+v_nText+"", "popup window", ...; Created on 06 November 2020
14. Zoho Deluge: Setup an API Connection for InvokeURL: / Zoho /; ... details how to setup a connection to use in an invoke URL statement. Specifically for Zoho Books, Subscriptions or Inventory. Why? Setting up a connection avoids the hassle of having to generate ...; Created on 12 August 2020
15. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Books: / Zoho /; ... Statement Error might be due to missing ';' at end of the line or incomplete expression This could be a missing semi-colon somewhere in your code OR that you have included either "content-type" in your ...; Created on 15 May 2020
16. Zoho Creator: Retrieve record with case-insensitive query: / Zoho /; ... expressions insert statement is terminated Line:(99)" > "Duplicate entry 'MyProduct1' for key 'Product_Name' Line:(99)". This indicates that the search to see if the product exists is case-sensitive, ...; Created on 21 November 2019
17. Zoho Deluge - Counting in a Map dataType: / Zoho /; ... or account, and specifying the quantity for each. How? So depending on the number of levels, the count will be with a series if then else statements. See the results/yield section to determine ...; Created on 02 September 2019
18. Zoho Deluge - Get Refresh/Access Token API v2: / Zoho /; ... does not redirect or reformat the resulting URL // // get Grant Token v_EndPoint = "https://accounts.zoho.com/oauth/v2/auth"; v_Scope = "ZohoBooks.contacts.ALL,ZohoBooks.invoices.ALL,ZohoBooks.purchaseorders.ALL"; v_State ...; Created on 17 July 2019
19. Zoho Deluge - Get User Timezone, Country and Location: / Zoho /; ... "stateProv": "England", "city": "Birmingham (Edgbaston)" } A more comprehensive alternative [Limit 150 per minute | not for commercial use]: v_Url = "http://ip-api.com/json/"+ zoho.ipaddress; v_Response ...; Created on 03 June 2019
20. GDPR Privacy Policy: / Static Items /; ... BUT NOT LIMITED TO DIRECT, INDIRECT, INCIDENTAL, PUNITIVE, AND CONSEQUENTIAL DAMAGES. CERTAIN STATE LAWS DO NOT ALLOW LIMITATIONS ON IMPLIED WARRANTIES OR THE EXCLUSION OR LIMITATION OF CERTAIN DAMAGES. ...; Created on 14 February 2019