... The specific form was for "Leads" which contained a subform with a product line item list. If I run this code, I would get the error:
Expecting ZC_SUBFORM_250 expression found COLLECTION expression
Another ...
What
A more comprehensive post on some other regex (regular expressions) to format values in Zoho.
How?
The following will remove any non-digits:
v_MyString = "Hello World 123";
v_MyFormattedString ...
What?
Practice makes perfect. Or in my case, any practice is a start. This article serves as a quick note on how to use regular expressions within SQL statements:
How?
For the following examples, ...
What?
A quick reminder on basic regular expressions.
Match Any Character Dot
The dot operator '.' matches any single character in the current character set. For example, to find the ...
Yes, well don't laugh, I could not find this on the WWW so I was obviously not using Google properly. Anyway here's just a quick note on how to do if else statements in Report Builder 2.0
I'm ...
... value
v_HexValue = v_HexGiven.replaceAll("#", "").toUpperCase();
//
// using a regular expression: split into pairs of characters or if short hex given, then split into 3 characters
l_HexParts = v_HexValue.replaceAll("(?)",",",false).toList().subList(1,4);
if(v_HexGiven.toString().len()>4)
{
l_HexParts ...
... Possibly due to me trying to create and declare the subform before having specified any record to insert it into.
Expecting ZC_SUBFORM_109 expression found COLLECTION expression: I may have tried ...
... prompts you can direct it to focus on the elements you want from a brief.
How?
A "prompt" is a text-to-image expression using words and phrases to instruct the Midjourney Bot (or any other AI text-2-image ...
... in mind script execution limits set by Zoho.
Set the search criteria string to your specific requirements (:equals:, :starts_with:, |=|). If 1 expression then you can omit the parenthesis. If multiple ...
What?
A very quick article on a cool snippet of code, another regular expression, I've been trying out to round up a number or at least to remove the trailing zeros. I could have added this to my Zoho ...
What?
This is an article to demonstrate how to handle commas in a CSV file that were enclosed between two double-quotes. I've added to this the handling of new lines or carriage returns in between a ...
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 ...
... think... Doing the above, I would get a really messy response (I'm targeting an API made with ExpressionEngine) such as:
Fatal error: Uncaught Error: Class '\Webservice\Service\Exception' not found in ...
... may want to find:
Company Name: Father & Sons (Incorporated)
Contact Name: O'Reilly
How?
Well I've tried various replace methods with regular expressions but the only method reliable enough ...
... 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 ...
What?
This is a quick article to demonstrate how to compare two datetime values with the timezone specified.
Why?
A client's ZohoCRM had a different timezone setting than the user a script would ...
... 5px 5px 5px 0px rgba(51, 51, 51, 0.3);
}
What I want:
#copyright a
How? So I'm doing this with a regular expression to get rid of newlines:
$v_AppStyle = "
#copyright a{
margin: 10px ...
... 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, ...
... regular expression (match all characters not from 0 to 9) in a Zoho Deluge script:
v_PaymentTermsNumber = v_PaymentTerms.replaceAll("[^0-9]","");
// yields 30
And if working with money/currencies, ...
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.