Search - Joel Lipman .Com

1. Expecting ZC_SUBFORM_250 expression found COLLECTION: / Zoho /; ... 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 ...; Created on 19 October 2020
2. Zoho Deluge - Some Useful Regular Expressions: / Zoho /; 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 ...; Created on 31 May 2019
3. Regular Expressions in SQL: / Databases /; 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, ...; Created on 09 January 2014
4. Regular Expression Basic Usage Examples: / Web-Development /; 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 ...; Created on 28 October 2013
5. If Then Else in Report Builder 2.0 Expressions: / SQL Server Reporting Services /; 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 ...; Created on 06 May 2010
6. ZohoCRM: Get Organization Business Hours using Deluge/API: / Zoho /; ... 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 ...; Created on 28 March 2023
7. Joel's Reference to MidJourney v4 Prompt: / Graphic Design /; ... 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 ...; Created on 11 February 2023
8. Zoho CRM: searchRecords with sorted results: / Zoho /; ... 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 ...; Created on 10 February 2022
9. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeros: / Zoho /; 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 ...; Created on 08 February 2022
10. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines): / 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 ...; Created on 26 August 2021
11. 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
12. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party API: / Zoho /; ... 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 ...; Created on 03 February 2021
13. Zoho Deluge: Search Records with Special Characters (COQL): / Zoho /; ... 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 ...; Created on 28 August 2020
14. 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
15. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date String: / Zoho /; ... Using a regular expression v_XeroTime="/Date(1586995200000+0000)/"; v_ZohoTime = v_XeroTime.replaceAll("[^0-9]", " ", false).trim().toList(" ").get(0).toLong().toTime(); // yields 15-Apr-2020 17:00:00 ...; Created on 04 May 2020
16. Zoho Deluge - Compare time and currenttime with timezone: / Zoho /; 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 ...; Created on 13 January 2020
17. PHP - Remove newlines and spaces from StyleSheet: / Personal Home Page /; ... 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 ...; Created on 03 January 2020
18. 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
19. Zoho Deluge - Regex to Strip all non-numeric characters: / Zoho /; ... 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, ...; Created on 25 March 2019
20. Zoho Deluge - MD5 function: / Zoho /; ... Failed Due to invalid expressions insert statement is terminated Line:(102) Value of the field Etag length should be lesser than or equal to MaxLength 255. Line:(132) It's not in the documentation ...; Created on 19 November 2018