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

  1. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/articles/google/google-drive-oauth-using-service-account-in-php.html

    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
  2. Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

    { // init b_BadWordFound = false; // get attempt v_Output = thisapp.generateRetrievalCode(); // see if can use contains but check for word for each v_BadWord in l_BadWords { if(v_Output.indexOf( v_BadWord ) >= 0) { b_BadWordFound = true; } } // if not...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. Zoho Deluge: Duplicate/Clone a Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-duplicate-clone-a-record.html

    // yields: // a,b,c,d,e // a,c,e // compared to: for each v_FieldName in l_FieldApiNames { if(!l_ExcludeFields.contains(v_FieldName)) {... do stuff here... } } // notes: // no need to check if element exists on "removeElement" Zoho OAuth Connector...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. Zoho Creator: Download uploaded file and attach to Sales Order in Zoho Bookshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-download-uploaded-file-and-attach-to-sales-order-in-zoho-books.html

    the file content instead of the internal file name. {"code":2,"message":"Invalid value passed for doc"}: The doc parameter contains special characters. Improper Statement Error might be due to missing ';' at end of the line or incomplete expression This...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. AutoHotkey: App GUI Listview to Rename Fileshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-app-gui-listview-to-rename-files.html

    v_FilesPath := SelectedDir "\*" Loop, Files, %v_FilesPath% { ; skip if file ext is not media if A_LoopFileExt not contains wav,mp3,avi,flv,mkv,mov,mp4,mpeg,mpg,wmv continue ; get name of file without its extension v_ThisFileName := A_LoopFileName...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  6. Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

    m_SearchCriteria = Map(); m_SearchCriteria.put("searchField","Leavetype"); m_SearchCriteria.put("searchOperator","Contains"); m_SearchCriteria.put("searchText","Leave"); l_SearchCriterias.add(m_SearchCriteria); l_AllTimeOffs =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  7. Zoho CRM: Mapping a Multi-User or Multi-Lookup field using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm-mapping-a-multi-user-or-multi-lookup-field-using-deluge.html

    Code to Add a value to a multi-lookup (on Create Record): // sample code when creating a record in a module that contains a lookup m_Create = Map(); m_Create.put("Name","Joels Amazing Test"); r_Create = zoho.crm.createRecord("Tests", m_Create); // now...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. Zoho Deluge: Zoho Bookings Get Available Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-zoho-bookings-get-available-slots.html

    l_AvailableSlots = r_AvailableSlots.get("response").get("returnvalue").get("data"); if(!l_AvailableSlots.toString().containsIgnoreCase("Slots Not Available")) { for each r_AvailableSlot in l_AvailableSlots { if(!r_AvailableSlot.contains("00:00") &&...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

    to consider that not all new lines/line breaks/carriage returns are at the end of a line.... for example, maybe your CSV contains multi-line fields; eg. where address street is on a different line to address city but in the same column... The following...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. Zoho Creator / eBay: Get all Active Productshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-all-active-products.html

    headers:m_Headers ]; // // output response info r_ResponseXML; // // if successful then read the response if(r_ResponseXML.contains("Success")) { // // init l_JSONItems = List(); // // parse the data v_MainNode = "ActiveList"; x_MainNode =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. Zoho Creator: Change Radio into Tabshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-change-radio-into-tabs.html

    (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
    • Language: *
  12. Zoho Creator: eBay: Get Item Transactionhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-item-transaction.html

    ]; // // 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
    • Language: *
  13. Zoho CRM & Creator: Download attachment and upload to Creator file fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-creator-download-attachment-and-upload-to-creator-file-field.html

    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
    • Language: *
  14. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://www.joellipman.com/articles/crm/zoho/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

    ]; 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: Zoho
    • Language: *
  15. Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://www.joellipman.com/articles/crm/zoho/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

    { // // 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
    • Language: *
  16. ZohoBooks: Error Code 15: Ensure Billing Address has less than 100 charactershttps://www.joellipman.com/articles/crm/zoho/zohobooks-code-15-ensure-billing-address-has-less-than-100-characters.html

    + 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
    • Language: *
  17. ZohoDesk & ZohoAnalytics: Display Ticket Attachments in Analytics Reporthttps://www.joellipman.com/articles/crm/zoho/zohodesk-zohoanalytics-display-ticket-attachments-in-analytics-report.html

    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
    • Language: *
  18. Zoho Creator: Render to PDF with margins and page numbershttps://www.joellipman.com/articles/crm/zoho/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

    = ""; // // 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
    • Language: *
  19. Zoho CRM: JS Widget: Generic Script to pass the Record ID to a CRM functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-js-widget-generic-script-to-pass-the-record-id-to-a-crm-function.html

    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
    • Language: *
  20. Zoho Deluge: Convert Map to URL Parametershttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-convert-map-to-url-parameters.html

    m_UrlParams = Map(); for each r_Part in l_ReturnedUrlParts { if(r_Part.contains("=")) { l_ParamParts = r_Part.toList("="); m_UrlParams.put(l_ParamParts.get(0), l_ParamParts.get(1)); } }

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
Results 41 - 60 of 61

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF

Please publish modules in offcanvas position.