... 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 ...
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 ...
... 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 ...
... 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 ...
... 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 ...
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 ...
... 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 ...
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 ...
... 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 ...
... 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 ...
... "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 ...
... 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 ...
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 ...
... 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 ...
... 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 ...
... 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, ...
... 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 ...
... 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 ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.