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

  1. Import Excel CSV file as JavaScript arrayhttp://mail.joellipman.com/articles/microsoft/excel/import-excel-csv-file-as-javascript-array.html

    // open the file // use GET for faster performance but use POST (no size limits) for large files xhr.open('POST', this_file, false); // set header to CSV mimetype xhr.setRequestHeader('Content-Type', 'text/csv'); // send request to the server...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  2. Accessing Apimo WebService APIhttp://mail.joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

    30); // Timeout options curl_setopt($ch, CURLOPT_TIMEOUT, 30); // Timeout options curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_USERAGENT, "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.6) Gecko/20070725...

    • Type: Article
    • Author: Joel Lipman
    • Category: API Miscellaneous
    • Language: *
  3. Zoho Deluge: Loop through 30 Minute Slotshttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-loop-through-list.html

    hourList = hourString.toList("/"); v_includeInPicklist = false; for each index timeSlot in hourList { timeSlotStr = timeSlot.toString(); if(timeSlotStr.length() zoho.currenttime && v_CheckTime1b >= v_OpeningTime.toTime() && v_CheckTime1b...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

    = {1,2,3,4,5}; // loop through times you will chance it for each v_TimeTried in l_TimesTried { // init b_BadWordFound = false; // get attempt v_Output = thisapp.generateRetrievalCode(); // see if can use contains but check for word for each v_BadWord...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. Zoho Creator: Retrieve record with case-insensitive queryhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-retrieve-record-with-case-insensitive.html

    note the lowercase P l_ProductDetails = Product[Product_Name == v_Name]; b_Exists = if(l_ProductDetails.count() > 0, true, false); if(!b_Exists) { // insert into Product table r_ProductCreate = insert into Product [ Product_Name=v_Name...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  6. Autohotkey - Chrome Profiles in Alphabetical Orderhttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-chrome-profiles-in-alphabetical-order.html

    OutputContent, %PreferenceFile% NameStart := InStr(OutputContent, """name"":""")+8 NameEnd := InStr(OutputContent, """", false, NameStart+1) NameLength := NameEnd - NameStart ClientName := SubStr(OutputContent, NameStart, NameLength) LV_Add("",...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  7. Zoho Creator: info/alert/modal/popup notification for any userhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

    of you may be asking why not use openUrl with a popup parameter, such as: openUrl("#Form:My_Confirmation_Popup?zc_Header=false","popup window","height=144,width=555"); The reason being, is that the top solution offers a very generic popup box that can...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. Zoho Deluge: Sort a Map by a specific fieldhttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-sort-a-map-by-a-specific-field.html

    r_Record); } } // // now sort list in descending order and action each record l_SortedKeysDesc = l_SortingKeys.sort(false); for each v_SortKey in l_SortedKeysDesc { m_ThisRecord = m_UnsortedRecords.get(v_SortKey); info m_ThisRecord; } Recap The original...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. ZohoCRM: Process all records of a modulehttp://mail.joellipman.com/articles/crm/zoho/zohocrm-process-all-records-of-a-module.html

    checked. Some solutions have worked in the past where you could simply add a checkbox and do a search where this value is false; but lately this hasn't been working for me. To this end, I have thought of an alternative that I now use frequently in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. Zoho Creator: Receive eBay Order Notifications via Webhookhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-receive-ebay-order-notifications-via-webhook.html

    the function that generates an access token from a refresh token: string API.fn_eBayConnect_AccessToken() { b_SandboxMode = false; v_Output = ""; if(b_SandboxMode) { r_Api = API_Integration[Connection_Name == "eBay API (Sandbox)"]; //info "Sandbox...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. Zoho CRM: Get Unique Values of a Text Fieldhttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-get-unique-values-of-a-field.html

    "id": "123456789000000004" }, { "Currency": "USD", "id": "123456789000000005" } ], "info": { "count": 3, "more_records": false } } Amazing! Let's go one further for a lookup field, in this case the account name field on the quotes record: // // build up...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  12. Zoho Creator: Public URL of an Image field / Upload to Shopify APIhttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-public-url-of-an-image-field-upload-to-shopify-api.html

    product id... if(!isNull(input.Shopify_Product_ID)) { m_Product.put("id",input.Shopify_Product_ID); b_CreateProduct = false; } // // title and HTML m_Product.put("title",input.Listing_Title); if(!isNull(input.Full_Shopify_HTML_Code)) {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. ZohoCRM: Get All eBay Active Listingshttp://mail.joellipman.com/articles/crm/zoho/zohocrm-get-all-ebay-active-listings.html

    m_ActiveList.put("Sort","ItemID"); // // exclude other lists m_Exclude = Map(); m_Exclude.put("Include", false); m_Params.put("DeletedFromSoldList",m_Exclude); m_Params.put("DeletedFromUnsoldList",m_Exclude); m_Params.put("ScheduledList",m_Exclude);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. ZohoBooks: Stripe Terminal Integrationhttp://mail.joellipman.com/articles/crm/zoho/zohobooks-stripe-terminal-integration.html

    m_Params.put("amount",v_StripeAmount); m_Params.put("currency","gbp"); //m_Params.put("automatic_payment_methods[enabled]", false); m_Params.put("payment_method_types[]","card_present"); m_Params.put("capture_method","manual"); v_DescriptionString =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. ZohoDeluge: Check Shipment Status via DHL APIhttp://mail.joellipman.com/articles/crm/zoho/zohodeluge-check-shipment-status-via-dhl-api.html

    } } // // return response return v_ShipmentStatus; Alternative get request: r_ShipmentDetails = getUrl(v_Endpoint, m_Header, false); Not done yet! Of course, it would help if when something was delivered, that was conveyed back to the system that asked,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  16. ZohoCRM: Get Organization Business Hours using Deluge/APIhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-get-organization-business-hours-via-deluge-api.html

    "business_timing": [ "09:00", "15:00" ] } ], "daily_timing": null, "week_starts_on": "Monday", "same_as_everyday": false, "id": "123456789000000123456789", "type": "custom" } } Tidied Up Want that in a practical format for use in ZohoCreator? Preferably...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  17. Zoho Deluge: Determine if Daylight Savings are in effecthttp://mail.joellipman.com/articles/crm/zoho/zoho-deluge-determine-if-daylight-savings-are-in-effect.html

    to UTC. b_IsDSTInEffect = if(zoho.currenttime.toString("HH:mm", "UTC") != zoho.currenttime.toString("HH:mm", "GMT"), true, false); info b_IsDSTInEffect; // v_TimeZoneOffset = if(b_IsDSTInEffect, "+01:00", "+00:00"); // // usage v_SendToCRM_DateTime =...

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

    ", " and "}; for each v_Exception in l_Exceptions { v_LastName = v_LastName.replaceAllIgnoreCase(v_Exception, v_Exception, false); } v_LastName = v_LastName.trim(); // // join all together v_FullName = trim(v_FirstName + " " + v_LastName); info...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  19. Zoho Workdrive: Getting Team Folder IDhttp://mail.joellipman.com/articles/crm/zoho/zoho-workdrive-getting-team-folder-id.html

    // // upload the file r_UploadResponse = zoho.workdrive.uploadFile(f_UploadCsvFile,v_WorkdriveFolderID,v_UploadFilename,FALSE,"my_workdrive_connection"); if(!isNull(r_UploadResponse.get("data"))) { // looping but only have 1 upload so getting permalink...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  20. Zoho Books: Estimates/Quotes: Accept & Decline Buttons on Templatehttp://mail.joellipman.com/articles/crm/zoho/zoho-books-estimates-quotes-accept-decline-buttons-on-template.html

    function I'll give it the following code (amend the org ID and connection name): // // initialize b_ValidResponse = false; v_EstimateID = "-"; v_OrgId = "123456789"; v_Output = "Unable to process request"; // // evaluate v_Intent =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 41 - 60 of 63

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.