Assuming contains is required, the following 65 results were found.
-
(so all the form is below the tabs group) and then a negative margin on another notes field called Note_Title which contains my header to place it above the tabs group: v_Css = ""; v_Css = v_Css + ".zc-Tabs-group .choice-table-row{display:inline-block...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
]; // // output response info r_ResponseXML; /* // // if successful then read the response if(r_ResponseXML.contains("Success")) { // // parse the data v_MainNode = "Item"; x_MainNode = r_ResponseXML.subString(r_ResponseXML.indexOf("
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
document name for display later: if(!isnull(row.Document_File)) { v_FileDetected = row.Document_File; if(v_FileDetected.contains("_")) { v_SubstringStart = v_FileDetected.indexOf("_"); v_FilenameDetected = v_FileDetected.subString(v_SubstringStart + 1);...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
]; info r_ResponseXML; // // parse response and retrieve the ebay URL of the hosted image if(r_ResponseXML.containsIgnoreCase("Success") || r_ResponseXML.containsIgnoreCase("Warning")) { v_BiggestHeight = 0; x_RespondedXML =...
- Type: Article
- Author: Joel Lipman
- Category: Ebay
- Language: *
-
{ // // invalid searches will return 200 results non-matching, so let's double-check if(r_Result.get("invoice_numbers").containsIgnoreCase(v_InvoiceRef)) { // retrieve payment mode, amount and date v_PaymentMode =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
+ p_QuoteID type :GET parameters:m_ApprovedConverted connection:"zcrm" ]; // should be checking here that data contains any rows but I'm going on the basis that this quote exists in CRM and at least 1 line item is mandatory l_CrmProductLineItems =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Books
- Language: *
-
Zoho Desk Do "Next" and select the Zoho Desk Portal Ensure that "Tickets" is selected (I'd tick most of the fields this contains) Create a data table in ZohoAnalytics to hold the attachments Create an Excel spreadsheet or CSV file with the headers:...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Desk
- Language: *
-
= ""; // // item and description v_ItemDescDisp = "" + c_Quote.Product.Product_Name + " "; if(c_Quote.Special_Edition.containsIgnoreCase("yes")) { v_ItemDescDisp = "SPECIAL EDITION "; } // // other properties to add to the description v_ItemDescDisp =...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Creator
- Language: *
-
v_FuncName, m_Params ) .then( function( r_SubData ){ console.log("Raw response:", r_SubData); // Check if the response contains the expected structure let output = r_SubData?.details?.output; // If the output is JSON text, parse it into a real object...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
data location set to "Local Drive") Click on Next have a quick glance of the preview and then click on Next First row contains column names = Yes, leave everything else as plain text except for Description which you should change to a Multi Line Text....
- Type: Article
- Author: Joel Lipman
- Category: Zoho People
- Language: *
-
+ " - " + ifnull(m_ZohoTaxRates.get(m_XeroLineItem.get("TaxType")),"0.0") + " %"; if(!l_CrmProductAvailableTaxes.contains(v_CrmTaxRateString)) { l_CrmProductAvailableTaxes.add(m_XeroLineItem.get("TaxType")); }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
= ifnull(m_XeroLineItem.get("TaxAmount"),0).toDecimal(); m_CrmProduct.put("Taxable",true); if(!l_CrmProductAvailableTaxes.contains(m_XeroLineItem.get("TaxType"))) { l_CrmProductAvailableTaxes.add(m_XeroLineItem.get("TaxType")); }...
- Type: Article
- Author: Joel Lipman
- Category: Zoho CRM
- Language: *
-
-- Step 2) Re-associate banner clients (in case J30 already includes new clients) -- - Re-associate if description contains migration notes UPDATE `my_new_database`.my_prefix_banners a INNER JOIN `my_old_database`.jos_bannerclient c ON a.cid=c.cid INNER...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
come as I'm really happy with what the above already improves! Download the above modified files. The following ZIP file contains the default Joomla v3.4.x core files and then a copy with my modifications above. I use this to quickly add the relevance...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
ReCaptcha) Login to your Joomla Administration panel Extensions > Plug-in Manager > Captcha - ReCaptcha Check "Public Key" contains your key. STEP #3: Enable admin option dropdown This is a code change to allow the admin to select recaptcha. Open the...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
key, this should be the JSON file that you generated at Google's developer console - service accounts section. It also contains the public key under the guise of a URL (x509 certificate) but we don't need it for this script. Note that the key should not...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
about the failure. All this blab actually means is that there is a chance one of your date values is BLANK, NULL or contains a non-numerical value in a number such as COMMA (,) and therefore the parsing (to extract year for example) will fail and stop...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
name of your choice Under Collection, select as Enumerator the "Foreach File Enumerator" Select the source folder which contains all the files to loop through Specify the file name convention with wildcard to indicate which files (in this example...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Integration Services
- Language: en-GB
-
same parameters) and another link which leads to our report containing the call to the Stored Procedure. This page itself contains a basic dataset query just to check with the end-user: Note that this an ordinary report as per usual. It will act as a...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
** ** Revision: v1.0 ** ** Description: Stored Procedure to return counts of records per staging database ** ** table that contains a specific value. ** ** NOTE: This script can be run separate to a stored procedure by ** ** declaring @p_Value and...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: en-GB