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 Deluge: Calculate start and end of Daylight Savings Timehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-calculate-start-and-end-of-daylight-savings-time.html

    First Sunday in November at 2:00 // // Starts Second Sunday in March at 2:00 v_FirstMonthDate = toTime(zoho.currentdate.toString("yyyy") + "-03-08 02:00:00"); // // Ends First Sunday in November at 2:00 v_LastMonthDate =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  2. Zoho Deluge - Get English Ordinalhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-english-ordinal.html

    This is how I was doing it previously. // get the date (eg. 1, 2, 3,... 29, 30, 31) This_Day_Date = My_Date_Field.toString("d"); // determine English ordinal English_Ordinal = "th "; if(This_Day_Date == "1" || This_Day_Date == "21" || This_Day_Date ==...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  3. ZohoCRM to ZohoBooks API: Rounding the cents or pennies when creating an invoicehttps://www.joellipman.com/articles/crm/zoho/zoho-books/zohocrm-to-zohobooks-api-half-a-cent-or-penny-off-when-creating-an-invoice.html

    rounding v_Rounded = v_Rate.round(2); info "a) " + v_Rounded; // Yields: 12345.55 // Regexed v_RegexedNumber = v_Rate.toString().replaceAll("^(\\d+\\.\\d{2})\\d*$", "$1"); info "b) " + v_RegexedNumber; // Yields: 12345.54 // 2 characters after period...

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

    v_NextDay = v_NextDay.addDay(1); } // if(v_NextDay.getDayOfWeek()==1) { v_NextDay = v_NextDay.addDay(1); } info v_Today.toString("EEEE dd-MMM-yy"); info v_Tomorrow.toString("EEEE dd-MMM-yy"); info v_NextDay.toString("EEEE dd-MMM-yy"); // // yields: //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  5. ZohoCRM & Xero: Function to pull most recent invoiceshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-invoices.html

    HH:mm:ss",v_XeroTimeZone); m_UpsertCrmInvoice.put("Invoice_Date",d_XeroInvoiceDate.toString("yyyy-MM-dd")); v_XeroInvoiceDueDate = m_ThisInvoice.get("DueDate"); d_XeroInvoiceDueDate =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  6. ZohoCRM & Xero: Function to pull most recent quoteshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-quotes.html

    m_ZohoTaxRatesByRate.put(m_TaxRate.get("value").toDecimal().round(3).toString(),m_TaxRate.get("id")); } } info m_ZohoTaxRatesByName; info m_ZohoTaxRatesByRate; // // do Xero stuff if(v_AccessToken != "") { m_Header = Map();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  7. Zoho Deluge - First Monday of Month or Last Tuesday of Monthhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-first-monday-of-month-or-last-tuesday-of-month.html

    break; } } // if last Tuesday is before today if(v_NextMonthTuesday.toDate() 0) { v_DayIndex = 2; } else if(v_InputSwitch.toString().indexOf("Tuesday") > 0) { v_DayIndex = 3; } else if(v_InputSwitch.toString().indexOf("Wednesday") > 0) { v_DayIndex = 4;...

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

    // // convert to xml and replace root nodes x_Params = m_Params.toXML(); x_Params = x_Params.toString().replaceFirst("",""); x_Params = x_Params.toString().replaceFirst("",""); // // send the request XML as a string r_ResponseXML = invokeurl [ url...

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

    100 categories so let's start counting r_Categories = invokeurl [ url: v_EndpointCategories + "?" + l_ConnectionParams.toString("&") + "&" + l_PaginationParams.toString("&") type: GET ]; v_TotalProducts = 0; v_TotalCategories =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  10. Zoho Deluge: Get the Week Number if Week starts on a Mondayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-the-week-number-if-week-starts-on-a-monday.html

    all the orders of a specific week... Just to confuse everyone in the world, the day index for a Sunday is 7 (ie. myDate.toString("u") returns 7) and the week commences on a Sunday (ie. myDate.toStartOfWeek("EEEE") returns Sunday). In other words, the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  11. Zoho Deluge: Loop through 30 Minute Slotshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-loop-through-list.html

    rid of all picklist options clear Time_field; // begin populating options thisStartHour = thisServiceRecord.Opening_Time.toString("HH"); thisClosingHour = thisServiceRecord.Closing_Time.toString("HH"); hourString =...

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

    + "." + v_FieldName); l_BuildUrl.add("download"); l_BuildUrl.add(v_PermalinkCode); v_DownloadUrl = l_BuildUrl.toString("/"); v_FileDownloadUrl = v_DownloadUrl + "?filepath=/" + v_FileInternalName; // // yields something like //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  13. Zoho Projects: Add a Time Log to an Issue using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-add-a-time-log-to-an-issue-using-deluge.html

    v_TimeHour + ":" + v_TimeMinutes; // // build map m_CreateTimeLog = Map(); m_CreateTimeLog.put("date",v_StartTime.toDate().toString("MM-dd-yyyy")); m_CreateTimeLog.put("bill_status",v_Billable); m_CreateTimeLog.put("hours",v_HoursHHmm);...

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

    v_Filename); m_Params.put("image", m_SubParams); // v_Endpoint = v_ShopifyURL + "/admin/api/" + v_ShopifyApiVersion.toString() + "/products/" + v_ShopifyProductID + "/images.json"; r_UploadPhoto = invokeurl [ url :v_Endpoint type :POST headers:m_Header...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  15. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

    // // set endpoint to retrieve 5 products v_Endpoint = "https://" + v_ShopID + "/admin/api/" + v_ShopifyApiVersion.toString() + "/products.json?limit=5"; // // curl (zoho invoke) request r_GetProduct = invokeurl [ url :v_Endpoint type :GET...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  16. Zoho Creator: Radio group into Calendar Carouselhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-radio-group-into-calendar-carousel.html

    for each index v_DateIndex in {1,2,3,4,5,6,7} { input.Calendar_Day_Select:ui.add(zoho.currentdate.addDay(v_DateIndex).toString("EEEE") + "" + zoho.currentdate.addDay(v_DateIndex).toString("d") + "" +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  17. Zoho Inventory: Mark a package slip as delivered and shippedhttps://www.joellipman.com/articles/crm/zoho/zoho-inventory/zoho-inventory-mark-a-package-slip-as-delivered-and-shipped.html

    != "") { v_PackageID = input.Zoho_Package_ID; r_PackageSlip = zoho.inventory.getRecordsByID("packages",v_BooksOrgID.toString(),v_PackageID,"ab_inventory"); if(r_PackageSlip.get("package") != null) { if(r_PackageSlip.get("package").get("salesorder_id")...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Inventory
    • Language: *
  18. Zoho Webhooks & Shopify API: Keep Disappearinghttps://www.joellipman.com/articles/else/e-commerce/shopify/zoho-webhooks-shopify-api-automatically-restore.html

    m_CreateRecord = Map(); m_CreateRecord.put("Event_Type","Order Update"); m_CreateRecord.put("JSON_Payload",m_Payload.toString()); r_CreateRecord =...

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

    // create sub folder v_ParentFolderID = "{parent_id}"; v_WorkdriveFolderID = ""; v_WorkingFolderName = zoho.currentdate.toString("yyyy"); if(!m_SubfolderNames.keys().contains(v_WorkingFolderName)) { m_Attr = Map(); m_Attr.put("name",...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Workdrive
    • Language: *
  20. Zoho Deluge - Get Full Day Namehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-full-day-name.html

    This is a very quick note with the code to retrieve the full day name from a date (eg. "Monday"). Why? If I use the toString() function to get the day, it only returns the first 3 letters of the day (eg. "Mon"). My_Date = today; Day_Name =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
Results 1 - 20 of 95