Assuming return is required, the following 175 results were found.
-
single one (eg. "my_____test" yields "my_test") $v_Output = preg_replace("#((\_){2})\\2+#", "$2", trim($v_Output, "_")); // returns a string return $v_Output; } and the MySQL is a trigger which executes before the record is inserted and increments the...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
on it: What I have » Home / Products / Lanterns What I want (on mouseover) // if I hover the mouse over the "Home" link: » Return to Home / Products / Lanterns // if I hover the mouse over the "Products" link: » Home / More Products / Lanterns // if I...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
the product exists because it is searching with case-sensitivity enabled. It tries to insert into the product table, but returns the error "Result: Error on Execution" > "Error details: Execution Failed Due to invalid expressions insert statement is...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
Secret, make a note of these or leave this window to copy&paste into the next step. Setting up the Oauth Connector So return to your Zoho Books instance (or Subscriptions, Inventory, app you were making the connection): From within books (or inventory,...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
a name select "Deluge" as the language give it a Namespace (for this example I will leave this on "Default") and set the return type (again in this example, I will leave this as "void") for Arguments Specify a parameter name of your choosing, in our...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
meridian (even if you are using projects.zoho.eu) input.Start_Time.toString("hh:mm a"); // additional note: "13:00 PM" will return this error as well Source(s) Zoho Projects - Timesheets API Zoho Deluge - Date-Time Functions - toString
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
in Zoho Deluge. How? We're going to make use of the .toLong() function applied to a datetime datatype variable which will return the Unix seconds. // the now time v_NowTime = zoho.currenttime; // // correction: I want to specify a from datetime...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
This article demonstrates how to return a list of unique values in a particular field in a CRM module. Why? My use-case is a data-migration where the records exist in a staging module in CRM but I want to transform/translate one of the column values...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
builds up the address from a Lead record to geocode into latitude and longitude coordinates to feed a third-party API which returns a timezone. Why? Our use-case is that we have a field called "Customer's Time Zone" on the lead record in ZohoCRM. It...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
r_TwilioResponse = invokeurl [ url :v_Endpoint type :POST parameters:m_Data ]; // // display to user/developer the response return r_TwilioResponse; Adapting it to trigger off a scheduled workflow of a call/meeting Login to ZohoCRM > Setup > Automation...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
{ v_StringToDecode = v_StringToDecode.replaceAll(v_HtmlKey, m_HtmlEntity.get(v_HtmlKey), true); } // // output return v_StringToDecode; } Usage: v_TestString = "Father & Sons"; v_DecodedString =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
click on “Clear” Then also click on “Reset Permissions” (usually only if you enabled notifications previously) > Reset Return to Zoho Desk and you will get the popup to enable Desktop Notification Click on “Enable” Then click on “Allow” (browser popup...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
for each r_Result in l_SearchResults { if(!isnull(r_Result.get("payment_id"))) { // // invalid searches will return 200 results non-matching, so let's double-check if(r_Result.get("invoice_numbers").containsIgnoreCase(v_InvoiceRef)) { // retrieve...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
:file:f_FileRequest ]; } else { v_OutputMessage = "No email was specified on this record. Cannot send this quote."; } return v_OutputMessage; Update: What is the URL to download the PDF in Zoho Books? Found this today so thought I'd add it to this...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
be better as changes to your settings may limit your discovery of the variations and styles. Type /settings then enter/return twice Storing prompts as quick commands Type /prefer option list to see what custom options you already have. By default you...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
m_Params = Map(); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB"); m_Params.put("DetailLevel","ReturnAll"); // // send order filters m_Params.put("CreateTimeFrom",v_timeFrom); m_Params.put("CreateTimeTo",v_timeTill);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
m_Params = Map(); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB"); m_Params.put("DetailLevel","ReturnAll"); // // specify only the active list m_ActiveList = Map(); m_ActiveList.put("Include",true);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
toolkit: Some registrars will say this can take between 24 to 72 hours to propagate. In our cases, a working example can return within the hour as authenticated. Use the following link to continue monitoring for when this has taken effect:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
clients set their due dates differently. How? The following snippet of code will query the metadata api in Zoho Books and return a JSON of what the payment terms are. void fn_ReturnCurrentPaymentTerms() { v_BooksOrgID = "12345678901"; r_PaymentTerms =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
-
v_Grammar = if(v_CountDuplicates == 1,"","s"); info v_CountDuplicates + " record" + v_Grammar + " are duplicates!"; // // return a distinct list l_Customers2.removeAll(l_Customers1); // // loop through and output to user for each v_DistinctCustomer in...
- Type: Article
- Author: Joel Lipman
- Category: Zoho
- Language: *
Donate & Support
bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4
0xb038962F3809b425D661EF5D22294Cf45E02FebF