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

  1. SSIS Script: convert UPPERCASE to Mixed-Case using TitleCasehttps://joellipman.com/articles/microsoft/ssis/ssis-script-convert-uppercase-to-mixed-case-using-titlecase.html

    a method to set the value of each String type property // Make sure the length of the new value doesn't exceed the column size p.SetValue(Row, ValueToConvert, null); } } catch (Exception e) { // Only handle ColumnIsNull and NullReference Exceptions if...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  2. Quadcopter App with Flight Restrictions (JQA)https://joellipman.com/component/content/article/quadcopter-app.html?catid=40

    - [1.4.2] Improved compatibility for Android OS 4.4.2 - [1.4.1] Improved compatibility with more devices - [1.4.1] Ads resized to full width (smart_banner) - [1.4.0] Map: re-fix locations with spaces v1.3 [27 Oct 2014] - [1.3.0] Pilot: fix links in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  3. List of Font Awesomehttps://joellipman.com/articles/web-development/list-of-font-awesome.html

    use these in a template I was working on. Font awesome is a brilliant tool for webdevelopers who want icons that can be any size of any color without compromising on image quality or overhead maintenance. It's basically a font set that has all the icons...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  4. Joes Quicklist Weblinks (JQW) Downloadshttps://joellipman.com/component/content/article/joes-quicklist-weblinks-jqw-downloads.html?catid=92

    Buttons. - Parameter: Mootools Transitions - None /...specific... / Random. - Parameters: Module Width / Height / Font-size Override. - Parameters: Show Descriptions / Images/ Dates / Hits. - Parameters: Get Titles + Descriptions (Local / Remote) -...

    • Type: Article
    • Author: Joel Lipman
    • Category: Downloads
    • Language: *
  5. Import Excel CSV file as JavaScript arrayhttps://joellipman.com/articles/microsoft/excel/import-excel-csv-file-as-javascript-array.html

    : new XMLHttpRequest(); // 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  6. MS Excel - Split Workbook into separate files per sheethttps://joellipman.com/articles/microsoft/excel/ms-excel-split-workbook-into-separate-files-per-sheet.html

    of multiple sheets into separate files per sheet. Why? The Excel file in question was about 36000 rows and had a file size of about 11Mb. In order for an import process to work, the import would only accept XLS files no greater than 1Mb. So our script...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  7. Excel - Check a column for values found in another columnhttps://joellipman.com/articles/microsoft/excel/excel-check-a-column-for-values-found-in-another-column.html

    Where: SumProduct( is a function to multiply two ranges together (must be the same size) and return the total of these results. -- is a double hyphen/dash which converts a boolean true to 1 and boolean false to 0. IsNumber( is a function returning a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Excel
    • Language: en-GB
  8. Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://joellipman.com/articles/crm/zoho/zoho-deluge-generate-5-letter-booking-retrieval-code.html

    v_StrLength = 5; // everyday I'm shufflin l_OutputShuffled = List(); v_OutputListSize = l_Alphabet.size(); for each v_Element in l_Alphabet { v_Random = (zoho.currenttime.toLong() % v_OutputListSize); l_OutputShuffled.add(l_Alphabet.get(v_Random));...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. Zoho Creator: info/alert/modal/popup notification for any userhttps://joellipman.com/articles/crm/zoho/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

    being, is that the top solution offers a very generic popup box that can be quickly modified with content/text and the popup size will automatically resize based on content. I tend to use the first solution combined with a form/table of standard...

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

    l_DeptEmployees = zoho.people.getRecords("P_Employee",0,200,l_SearchCriterias); v_TotalDeptEmployees = l_DeptEmployees.size(); // ensure total is not zero as we need to divide by it (defaulting to 2 because if 1 then it's 100%, as 2 it's 50% might have...

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

    { l_ApprovalUsers.add(m_User.get("id")); } } // // check list of IDs if(l_ApprovalUsers.size() > 0) { // // reset multi-user lookup field (clear out values) v_SearchCriteria = "(userlookup221_2:equals:" + p_QuoteID + ")"; l_SearchResults =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  12. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirectshttps://joellipman.com/articles/crm/zoho/zoho-creator-two-submit-buttons-on-a-non-stateless-form.html

    line-height:19px; height:31px; background-color: #6B47F4; color:#fff !important; font-weight: 400 !important; font-size: 14px !important; padding:7px !important; box-shadow: 0 3px 8px 0 rgb(107 71 244 / 33%); border-radius:5px; width:100px; max-width:...

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

    m_Update.put("Processed",true); r_Update = zoho.crm.updateRecord("Contacts",v_RecordID,m_Update); } } if(l_Records.size()

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

    in l_SoapActions { l_SoapActionParts = v_SoapAction.toList("/"); v_Type = l_SoapActionParts.get(l_SoapActionParts.size() - 1); } } m_Blank = Map(); m_CreateRecord = Map(); m_CreateRecord.put("Event_Type",v_Type);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  15. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.https://joellipman.com/articles/crm/zoho/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

    + 1; } // check that there was something to actually update rather than wasting an API call if(m_ShippingAddress.size() > 0) { // endpoint TLD is EU for Europe DC and COM for US DC v_Endpoint =...

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

    not accept any links I gave it. Why not use the links that eBay returns? Well eBay returns URLs to images that have been resized to 400x400 (even with tweak to return 800x800). I wanted a way to upload my image directly to Shopify in 3024x3024...

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

    to each record... info r_Result.get("id"); } } // // stop looping if less than 200 records on this page if(l_SearchResults.size()...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. Zoho Deluge: Shopify API: Get all active products with GraphQL and Paginationhttps://joellipman.com/articles/crm/zoho/zoho-deluge-shopify-api-get-all-active-products-with-graphql-and-pagination.html

    v_CSVFile = l_CsvFileRows.toString("\n").toFile(v_CSVFilename); // // send via Email v_CountRows = l_CsvFileRows.size() - 2; v_Subject = "Shopify Products Export & Comparison"; v_Message = "Please find attached a log of " + v_CountRows + " Product(s)...

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

    for each index v_Increment in l_AddPages { l_Pages.add(v_StartingPageIndex + v_Increment); } v_TotalNumberOfPages = l_Pages.size(); // // declare variables to store order details in a JSON or ZohoDeluge Map format m_Response = Map(); l_JsonProducts =...

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

    // // Get custom Amount to Pay from Invoice l_CustomFields = invoice.get("custom_fields"); if(l_CustomFields.size() > 0) { for each m_CustomField in l_CustomFields { if(m_CustomField.get("label") == "Amount To Be Taken") { if(m_CustomField.get("value")...

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

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.