Assuming function is required, the following 184 results were found.
-
this and can still be found in the community forums from a 7 year old post; but now you can apply a containsIgnoreCase function to search the records:... l_ProductDetails = Product[Product_Name.containsIgnoreCase(v_Name)];... Lastly, there is a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
invokeurl [ url :v_DataEndpoint type :PUT parameters:m_CreateRecord headers:m_Header ]; Problem: Value is empty and 'get' function cannot be applied Following a post similar to the above example by InvokeURL and then getting a JSON response back, the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
You can then use the following snippet to get all the fields for the module. In our case, for "Invoices": /* Function: fn_Button_CloneInvoice Purpose: This function duplicates a CRM invoice Parameters: p_InvoiceID (CRM ID of the invoice) Returns:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
article as I couldn't find anything on the WWW to document this error. Why? During a data migration, I was using a custom function to copy all the data from one app to another. The specific form was for "Leads" which contained a subform with a product...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
Zoho Deluge to look at Zoho Books. This uses up an extra 2 calls so you could run them once, store them as a map on your function if you don't want to use up these 2 every time your sales team push a CRM Sales Order to Zoho Books. Or leave as 2 calls at...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
It should be auto-populated... How? As mentioned, we're going to use the address on the Lead record; use Zoho's GeoCode function to convert this into a latitude and longitude, then we're going to use a free TimeZone API (one that returns a timezone...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
This is the function to get the line item order/transaction from eBay if you give it the eBay Item ID as a parameter. Why? Mostly for debugging but here's the code that will quickly get the XML of a GetItemTransactions request to eBay. How? You'll need...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
such as zoho.encryption.htmldecode(string). But at time of print, it doesn't exist and in the meantime, I've made a function that does this. How? Not sure how else to do this but I simply wrote a function in Zoho Creator for each instance that I knew a...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
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 I'm aware of is a regular expression. So the first expression I...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
This is an article describing a custom function built into Zoho Flow that will accept as parameter the document_id and request_id. It then retrieves the Deal Reference (entered by an office signee) on the ZohoSign document and searches for the relevant...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Sign
- Language: *
-
info "-------------"; } Yields something like: Error(s) Encountered Value is empty and '1234567000001234567' function cannot be applied: Possibly due to me trying to create and declare the subform before having specified any record to insert it into....
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
But there are tips found across the web just not specifically addressing this. How? Here is the code for a test function which downloads 2 files from a public domain, no user wall. The key here which the official documentation is missing is the...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
"attachment"); m_Attachment.put("content", f_BillsExport); // // this variable name is in plural, but as a custom function within ZohoBooks, we know this is just 1 bill record, still... for each r_Bill in bills { v_BillID = r_Bill.get("bill_id"); } //...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
= ifnull(input.p_OrderID,0).toLong(); /* ******************************************************************************* Function: void ZohoBooks.fn_SendZohoBooksInvoice(int p_OrderID) Trigger: On Demand when button in report is clicked Purpose: This...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
my client has added an incredible number of price books/ price lists and then has in excess of 20k items. Previously, the function that would need to get the price book rate post saving a record in Zoho Deluge would fail because it was making too many...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
the subscription plan; we wanted some proof using code. How? We're going to use a quick snippet of some code. So create a function in the Zoho App you are checking, or somewhere you can write some Zoho Deluge code. Note that requesting an increase of...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
A quick article to document a Zoho Deluge function converting a hexadecimal color reference to a Red Green Blue value (RGB). Why? It's likely that Zoho will avail their color picker at some point as an input but at the time of print, this hasn't...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: *
-
records. Consider the following code: /* ******************************************************************************* Function: string standalone.fn_Deal_UpdateRelatedToCancelled() Label: Fn - Customer Deals - Cancel Related Records Trigger:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
can be used to check if the string only contains blanks or if a value is null... How? Consider the following test function: void fn_Test() { info "---------------------- Value of TEST is a BLANK String"; v_Test = ""; if(isBlank(v_Test)) { info "isBlank...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
No direct access to this file defined('_JEXEC') or die; // com_XXX is your component name class com_XXXInstallerScript { function postflight($type, $parent) { // $type (install, update or discover_install) if ($type == 'install') { $db =...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB