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 96 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 People and Zoho Analytics: Push all Employee Salary Data to Analyticshttps://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-and-zoho-analytics-push-all-employee-salary-data-to-analytics.html

    Per Annum,Created Time,Modified Time,Created By,Modified By,Pay Schedule"; l_CsvRows.add(v_Headings.toList().toString()); // // the zoho analytics org ID noted earlier v_AnalyticsOrgID = "123456879"; // // in analytics, browse to the target table and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  8. 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
  9. 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: *
  10. 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: *
  11. 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: *
  12. 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: *
  13. 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: *
  14. 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: *
  15. 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: *
  16. 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: *
  17. 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: *
  18. 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: *
  19. 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: *
  20. 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: *
Results 1 - 20 of 96