Advanced Search

Here are a few examples of how you can use the search feature:

Entering this and that into the search form will return results containing both "this" and "that".

Entering this not that into the search form will return results containing "this" and not "that".

Entering this or that into the search form will return results containing either "this" or "that".

Search results can also be filtered using a variety of criteria. Select one or more filters below to get started.

Assuming message is required, the following 86 results were found.

  1. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://joellipman.com/articles/crm/zoho/zoho-books/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

    CRM record 'pulls through'. Sending the address in the same request however gives me the following error: { "code": 15, "message": "Please ensure that the billing_address has less than 100 characters." } How? So the quick answer is 2 separate API calls...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  2. Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSONhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-error-code-2945-extra_key_found_in_json.html

    m_Blank, "my_creator_connection"); // // SUCCEEDS: with r_Create = {"code":3000,"data":{"ID":"1234567000012345678"},"message":"Data Added Successfully"} Source(s): Zoho Creator / API Status Codes Zoho Community / Zoho One / Using Zoho One Zoho Community...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  3. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

    sending an email from CRM, they want CRM to include this rich signature (different per user) at the bottom of the email message. How? So there are a few issues with displaying images which would have other solutions, such as hosting the images on a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  4. Zoho Creator: Get Images in Report to be Exported to PDFhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-get-images-in-report-to-be-exported-to-pdf.html

    substitute with PDF, DOC, XLS extensions c_Document.Local_Image = ""; info "File: " + v_DocFileName; } catch (e) { info e.message; } } } } info "Created/Updated " + v_CountNew + " of " + v_CountImages; info "----------------"; } } This function is added...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  5. Zoho CRM: Client Script Confirmation Box and Popup Mailerhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-prompt-and-popup-mailer.html

    Popup a confirmation box to proceed or cancel. Popup the email from CRM mailer with the to email address, bcc, subject and message content already populated. How? The example from the Kaizen series uses a record with canvas mode applied; but I wanted to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  6. Zoho Deluge and Wordpress/WooCommerce API: Get All Productshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-and-wordpress-woocommerce-api-get-all-products.html

    subject :"All Products from " + v_MyWordPressSiteUrl + " as of " + zoho.currenttime.toString("yyyy-MM-dd HH:mm:ssXXX") message :"Please see the attached file" Attachments :file:f_AllProducts ] // return v_TotalProducts + " product(s) in " +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  7. Zoho Webhooks & Shopify API: Keep Disappearinghttps://joellipman.com/articles/else/e-commerce/shopify/zoho-webhooks-shopify-api-automatically-restore.html

    [ from :zoho.adminuserid to :"me+DEBUG_SHOPIFY_EXAMPLE@joellipman.com" subject :"CLIENT Payload and Hash Comparison" message :v_VerifyHash + " " + v_ShopifyHash + " " + m_Payload.toString() ] // // to cut even more time, we could store it directly in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Shopify
    • Language: *
  8. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

    automate this at the end of this function. Error(s) Encountered {"code":"INVALID_DATA","details":{"api_name":"Remind_At"},"message":"invalid reminder time","status":"error"} There was nothing wrong with the date time format here. Just that I was...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  9. ZohoCRM GetRelatedRecords INVALID_DATAhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-getrelatedrecords-invalid_data.html

    api_name:'data'... But this is shortcode, not an invokeURL. { "code":"INVALID_DATA", "details":{ "api_name":"data" }, "message":"invalid data", "status":"error" } How? I recall covering this solution before but it boils simply down to the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

    // if "Proceed" was clicked if (b_Proceed) { // start Loader ZDK.Client.showLoader({type:'page', template:'spinner', message:'Re-writing Invoice Line Items...' }); // reset the subform of Invoiced Items ZDK.Page.getField('Invoiced_Items').setValue([]);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  11. Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://joellipman.com/articles/crm/zoho/zoho-analytics/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

    to an email for testing /* sendmail [ from :zoho.adminuserid to :v_ContactEmail subject :"Radar Chart for " + v_ViewName message :"See attached" Attachments :file:f_ChartExport ] */ // return "The function executed. Doesn't mean it did what we wanted to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  12. Zoho Survey: Zoho CRM Webhookhttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-survey-zoho-crm-webhook.html

    Send yourself an email sendmail [ from :zoho.adminuserid to :"me@mycompany.com" subject :"TEST: Survey has been submitted" message :crmAPIRequest ] */ // // build response to Zoho Survey (hard-coded a ok) m_ResponseHeader = Map();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  13. ZohoCRM & Xero: Function to pull most recent invoiceshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-invoices.html

    ******************************************************************************* */ // // init v_OutputMessage = "ERROR: No Access Token or Tenant Connection specified."; v_Count_FoundInXero = 0; v_Count_Created = 0; v_Count_Updated = 0; v_AccessToken =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  14. ZohoCRM & Xero: Function to pull most recent quoteshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-quotes.html

    ******************************************************************************* */ // // init v_OutputMessage = "ERROR: No Access Token or Tenant Connection specified."; v_Count_FoundInXero = 0; v_Count_Created = 0; v_Count_Updated = 0; v_AccessToken =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  15. How to redirect the visitor after the contact pagehttps://joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

    = ‘index.php?option=com_contact&task=view&contact_id=’. $contact[0]->id .’&Itemid=’. $Itemid; mosRedirect( $link, _THANK_MESSAGE ) replace that code with the URL for the contact Thank-you page as defined as follows: $link = sefRelToAbs(...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  16. Creating a Profile Plugin for Joomla 1.6https://joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

    with this allergy?" PLG_USER_PROFILE5_FIELD_ALLERGYTIME_LABEL="Time With Allergy?" PLG_USER_PROFILE_FIELD_ALLERGYTIME_MESSAGE="Select one of the options" PLG_USER_PROFILE5_XML_DESCRIPTION="User Profile - JoelLipman.Com Plugin"...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  17. Change the default Joomla Error templatehttps://joellipman.com/articles/cms/joomla/change-the-default-joomla-error-template.html

    Backup the file \templates\system\error.php Create a replacement file called error.php including the below code Change the message "The Page you are looking for..." to what you want. Change the link "www.joellipman.com" to the "www.yoursitename.com"....

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  18. SSIS Convert a string into a datehttps://joellipman.com/component/content/article/ssis-convert-a-string-into-a-date.html?catid=74&Itemid=165

    + "-" + SUBSTRING(Date,1,2) + " 00:00:00") So although your SSIS IDE (Visual Studio?) will give you a useless Microsoft message saying something like: Error: Data conversion failed while converting column "This_Date" (3833) to column "This_Date" (3932)....

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  19. SSRS Parameters in Oracle Stored Procedurehttps://joellipman.com/component/content/article/ssrs-parameters-in-oracle-stored-procedure.html?catid=75&Itemid=165

    (:) we expected for Oracle. Passing in Variables I've been told that SSRS does not understand OUT variables. For a success message to be returned based on the status of the stored procedure, please view my article SSRS Retrieving Oracle Stored Procedure...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  20. SSRS: Performance Improvements: SELECT TOPhttps://joellipman.com/component/content/article/ssrs-performance-improvements-select-top.html?catid=75&Itemid=165

    OR @GivenDOB = '') AND (@GivenRef'' OR @GivenForenames'' OR @GivenSurname'' OR @GivenDOB'') For usability, we put a message just below the header which was an expression detailing what the report was displaying, so for example: -- If setting the limit...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
Results 61 - 80 of 86