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

  1. Zoho Deluge - Determine Quarter from Date with Fiscal Yearhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-determine-quarter-from-date-with-fiscal-year.html

    Here's the standard code you'd expect if your Fiscal year starts in January (Divide by 3 and round up): for each v_Month in l_Months { v_Quarter = (v_Month.toLong() / 3).ceil(); info "Month: " + l_MonthNames.get(v_Month-1) + " :: Quarter: " + v_Quarter;...

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

    // // build params m_Params = Map(); // set to application or user to see the notifications for each m_Params.put("PreferenceLevel","User"); m_Params.put("WarningLevel","High"); m_Params.put("ErrorLanguage","en_GB"); // // convert to xml and replace...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. Zoho Deluge: Today, Tomorrow, Day After but Skip Sundayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-today,-tomorrow,-day-after-but-skip-sunday.html

    // // start with first date to add (check if it is a working day) v_NextWorkingDay = v_GivenDate; // // loop through each day to set an appointment for for each index v_Loop in l_NumberOfDays { // skip if Sunday (add 1 day)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://www.joellipman.com/articles/crm/zoho/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

    ]; if(!isnull(r_Response.get("fields"))) { // loop through every field to find the customer's timezone one for each r_Field in r_Response.get("fields") { if(r_Field.get("api_name") == "Customer_s_Timezone") { // loop through all the picklist values of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. Zoho Creator: Populate a Multi-Lookuphttps://www.joellipman.com/articles/crm/zoho/zoho-creator-populate-a-multi-lookup.html

    l_Appointments = Appointment[Zoho_Inventory_Package_Slips == null] sort by Added_Time desc range from 0 to 100; for each c_Appt in l_Appointments { // // get package references specified in a previous multi-line text field l_PackageRefs =...

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

    so page 1 of Shopify products. Why? Our use-case is that we retrieve the 100 most recently modified products at the end of each day and run some Deluge code against it to ensure that the data in Shopify is the same as in Zoho. In this case, Shopify is...

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

    "I'"}; // // deal with double barrelled surnames l_FormattedLastName = List(); l_LastNameParts = v_LastName.toList("-"); for each v_LastNamePart in l_LastNameParts { // // default to proper v_LastNamePart = v_LastNamePart.proper(); // // if exception...

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

    l_PaginationParams.toString("&") type: GET ]; v_TotalProducts = 0; v_TotalCategories = r_Categories.toJSONList().size(); for each m_Category in r_Categories.toJSONList() { if(!isNull(m_Category.get("count"))) { v_TotalProducts = v_TotalProducts +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. Zoho Books / Inventory: Get Item Rate from a Price Book/Listhttps://www.joellipman.com/articles/crm/zoho/zoho-books-inventory-get-item-rate-from-a-price-book-list.html

    m_Blank = Map(); // // evaluate v_BooksOrgID = organization.get("organization_id"); // // loop through line items for each m_LineItem in salesorder.get("line_items") { r_BooksItem = zoho.inventory.getRecordsByID("items", v_BooksOrgID,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. Zoho CRM: Remove Duplicate Product Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-remove-duplicate-product-records.html

    = 0; v_CountDeleted = 0; // // pagination v_PerPage = 500; // // loop through pages to fetch as many as possible for each v_Page in {1,2} { info "Page #" + v_Page; v_PageFactor = v_Page - 1; v_Offset = v_PageFactor * v_PerPage; // // get unique product...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. Zoho Deluge - Get Current User IDhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-current-user-id.html

    users = userResp.executeXPath("/users/user"); if ((users != null) && (users != "")) { userList = users.toList("-|-"); for each user in userList { emailNode = user.executeXPath("/user/@email"); email = emailNode.executeXPath("/email/text()"); if (email...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
  12. Zoho Deluge - Store and repopulate a multi lookup list in Creatorhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-store-and-repopulate-a-multi-lookup-list-in-creator.html

    { // remember remember the 5th of november l_RememberLookup = List(); if(input.myLookup.size()>0) { for each v_SelectedLookup in input.myLookup { l_RememberLookup.add(v_SelectedLookup); } } } // // clear lookup clear myLookup; // // get list of all...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
  13. Pancakeshttps://www.joellipman.com/articles/_other-misc/pancakes.html

    pour the rest into a bowl anduse it to lubricate the pan, using a wodge of kitchen paper to smear it round before you make each pancake. Now get the pan really hot, then turn the heat down to medium and, to start with, do a test pancake to see if you're...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  14. Joe's Unduplicater (JUD)https://www.joellipman.com/component/content/article/joes-unduplicater.html?catid=40

    copyright... Basically this is the third time I wrote this program, simply because I reghost all my computers (Home & Work) each year and can't be bothered to retrieve accidentally deleted programs from my backup drives. I downloaded a load of media...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  15. Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=40

    Generation" is set to "NO". (Important! remember to switch this to YES when you have updated all your thumbnails as each thumbnail is one entitlement of the first 100,000 for free. After that there may be a charge or images may come back...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  16. Basic Webpage Controls with JavaScript / COMhttps://www.joellipman.com/articles/automation/autohotkey/basic-webpage-controls-with-javascript-com.html

    COM Support (recommended) the COM Standard Library - for use with AHK Basic Purpose The purpose of this tutorial is to teach the intermediate AHK user how to start using COM to control webpages. My goal is to provide methods for controlling webpages,...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  17. MySQL parameters in Excel 2007 PivotTableshttps://www.joellipman.com/articles/database/mysql/mysql-parameters-in-excel-2007-pivottables.html

    use EXCEL filters as the parameters. Bit of a cop-out but this was just a workaround and never a solution. Add in the ID of each entry as a field to pull from the database so that anyone can drilldown to the specific logged activity event (smallest unit...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  18. T-SQL Record Separatorhttps://www.joellipman.com/articles/database/t-sql/t-sql-record-separator.html

    ... Sunday 16/10/2011 A007 08:00 17:00 NULL NULL NULL NULL NULL NULL */ Note that my data is inaccurate as the last row of each grouped data has been changed to NULL. Also note how the actual select query is pulling data from my CTE in its...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  19. Regular Expression Basic Usage Exampleshttps://www.joellipman.com/articles/web-development/regular-expression-basic-usage-examples.html

    to find either 'a', 'b', or 'c' use the following regular expression: [abc] This expression matches the first character in each of the following strings: at bet cot The expression does not match: def Non-Matching Character List Use the non-matching...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  20. SSIS: How to loop through multiple flat files as data sourceshttps://www.joellipman.com/articles/microsoft/ssis/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html

    on having an SSIS package loop through a directory/folder of files in order to populate a database table. We could add each file as a separate connection manager but this is inefficient and not versatile enough to accommodate files that get added later....

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

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.