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 tostring is required, the following 95 results were found.

  1. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

    m_Data.put("Contact.Last_Name", r_ContactRecord.get("Last_Name")); m_Data.put("Issue.Date", zoho.currentdate.toString("MMMM, dd yyyy")); m_Data.put("Organization.Name", r_ContactRecord.get("Account_Name").get("name")); // m_MergedData = Map();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-deluge-adding-10-minutes-to-a-crm-date-time-field.html

    + "-" + r_LeadDetails.get("Created_Time").subString(8,10); // // parse date into yyyy-MM-dd (using toString - often works) v_LeadCreatedDate = r_LeadDetails.get("Created_Time").toString("yyyy-MM-dd"); // // parse time into HH:mm:ss v_LeadCreatedTime =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  3. Zoho CRM: searchRecords with sorted resultshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-searchrecords-with-sorted-results.html

    + v_PerPage}; r_CoqlSortedProducts = invokeUrl [ url :"https://www.zohoapis.eu/crm/v7/coql" type :POST parameters:m_Params.toString() connection:"zcrm" ]; l_SortedProducts = ifnull(r_CoqlSortedProducts.get("data"), List()); Source(s): Joel Lipman -...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  4. Zoho Creator: Embed Forms/Reports on a Pagehttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-embed-forms-reports-on-a-page.html

    l_FormParams.add("privateLink=" + p_PublishKey); v_FormParams = l_FormParams.toString("&"); %> loading...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  5. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://www.joellipman.com/component/content/article/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html?catid=138&Itemid=165

    + v_TLD); l_Params.add("grant_type=refresh_token"); v_Url = "https://accounts.zoho."+v_TLD+"/oauth/v2/token?" + l_Params.toString("&"); r_AccessToken = invokeUrl [ url: v_Url type: POST ]; // // output v_AccessToken =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Sign
    • Language: *
  6. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://www.joellipman.com/articles/crm/zoho/zoho-recruit/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

    //info l_Candidates; // // sanity check to output that it did something info "Done: " + zoho.currenttime.toString("HH:mm:ss"); // // loop through our list for this page for each r_Candidate in l_Candidates { v_CountTotal = v_CountTotal + 1;...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Recruit
    • Language: *
  7. Zoho Books: Get Invoice Payment Terms via APIhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-get-invoice-payment-terms-via-api.html

    or update if(v_BooksInvoiceID != 0) { r_InvoiceSO = zoho.books.updateRecord("invoices",v_BooksOrgID,v_BooksInvoiceID.toString(),m_InvoiceDetails,"abzohobooks"); } else { r_InvoiceSO =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  8. Zoho Deluge: Proper Case for Nameshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-proper-case-for-names.html

    } // // add back to our hyphen separated list l_FormattedLastName.add(v_LastNamePart); } v_LastName = l_FormattedLastName.toString("-") + " "; // // affix exceptions l_Exceptions = {" II", " III", " the ", " de ", " of ", " van ", " and "}; for each...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  9. ZCRM Client Script: Correct Decimal Fields OnLoadhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zcrm-client-script-correct-decimal-fields-onload.html

    var fn_CountDecimals = function(value) { if (Math.floor(value) !== value) return value.toString().split(".")[1].length || 0; return 0; } // get the value from the field "Weight (kg)" (decimal field only allowed 2 decimals) var v_ProductWeight =...

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

    v_CountImages = 0; v_CountNew = 0; for each c_ImageRow in c_TicketRecord.Images { v_ImageRowID = c_ImageRow.ID.toString(); v_CountImages = v_CountImages + 1; v_ImageHtml = ifnull(c_ImageRow.Image,""); if(v_ImageHtml.contains("\"")) { v_ImageSrc =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  11. Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

    = c_Quote.Name.last_name; } if(c_Quote.Email != null) { v_Email = c_Quote.Email; } v_QuoteDate = c_Quote.Modified_Time.toString("dd-MMM-yyyy"); c_AddedBy = Staff[Zoho_Creator_User == zoho.loginuser]; if(c_AddedBy.count() > 0) { v_AddedBy =...

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

    // convert to time datatype v_TimeOffset = (v_LeadCreatedTime.subString(0,10) + " " + v_LeadCreatedTime.subString(11,25)).toString("yyyy-MM-dd HH:mm:ss", v_ThisTimeZone); // // set reminder time (exactly 1 working day after created time) v_RemindTime =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  13. Zoho Deluge: Convert Hex to RGBhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-convert-hex-to-rgb.html

    then split into 3 characters l_HexParts = v_HexValue.replaceAll("(?)",",",false).toList().subList(1,4); if(v_HexGiven.toString().len()>4) { l_HexParts = v_HexValue.replaceAll("(?

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  14. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://www.joellipman.com/component/content/article/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html?catid=74&Itemid=165

    string[] exceptionArray_that; // get the value we want to transform string ValueToConvert = p.GetValue(Row, null).ToString(); // PRIMARY transformation: Applies to all words // (lowercases and capitalizes first letter taking into account punctuation...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  15. Zoho Deluge - Pad with leading Zeroshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-pad-with-leading-zeros.html

    you may find the following example: string padWithLeadingZeros(int finalStringLength, int startingNumber) { return leftpad(toString(input.startingNumber), input.finalStringLength).replaceAll(" ", "0"); } This looks like pretty old code and not wanting...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
Results 81 - 95 of 95