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

  1. Convert Past Date to Time Ago in PHPhttps://www.joellipman.com/articles/web-development/php/convert-past-date-to-time-ago-in-php.html

    floor(($v_Seconds % 3600) / 60), floor($v_Seconds % 60), ); // initiate array (for array_slice) $a_UnitPairs = array(); // loop concatenating unit value to its label for($i=0;$i0 ? $a_UnitValues[$i].' '.$a_UnitLabels[$i] : ''; // grammar for...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: en-GB
  2. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html

    0 v_Center := 0 v_RightMost := 0 a_MyArray := Array() ; get all monitors (excl. hidden/virtual) SysGet, v_MonitorCount, 80 Loop %v_MonitorCount% { ; monitor boundaries SysGet, v_Monitor%A_Index%, Monitor, %A_Index% v_x1 := v_Monitor%A_Index%Left v_y1 :=...

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

    we want to set is called "Switch_Over_Day". For the first Monday, we are going to select the first day of the month and then loop until we find a Monday. Same for the last Tuesday except that we will count backwards from the end of the month:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: en-GB
  4. Zoho Deluge: Associate/Link an Invoice to a Sales Orderhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-associate-link-an-invoice-to-a-sales-order.html

    + "|" + v_NewSoLineItemQuantity + "|" + v_NewSoLineItemRate,r_NewLineItem.get("line_item_id")); } // // now loop through the invoice line items and rebuild the list l_UpdateLineItems = List(); for each r_OldLineItem in invoice.get("line_items") {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. Zoho Deluge: Duplicate/Clone a Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-duplicate-clone-a-record.html

    details of original invoice r_Invoice = zoho.crm.getRecordById("Invoices", p_InvoiceID); // start map m_Clone = Map(); // loop through field names for each v_FieldName in l_FieldApiNames { if(!isNull(r_Invoice.get(v_FieldName))) {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  6. AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/articles/automation/autohotkey/autohotkey-get-media-information-and-display.html

    Local Static xDetails If ( sFile = "" ) { ; Deinit static variable xDetails := "" Return } fex := {}, _FileExt := "" Loop, Files, % RTrim(sfile,"\*/."), DF { If not FileExist( sFile:=A_LoopFileLongPath ) { Return } SplitPath, sFile, _FileExt, _Dir,...

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

    l_AllTimeOffs = zoho.people.getRecords("P_ApplyLeave",0,200,l_SearchCriterias); Then we need the code to loop through all these matching records (and approved) and determine if it clashes with the requested dates: for each r_TimeOff in l_AllTimeOffs {...

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

    // // I can see 2 api names for lookups // userlookup221_2 // Requires_Approval_Users My full snippet of code // // loop through users to find the approver for each m_User in l_Users { if(m_User.get("Job_Title").equalsIgnoreCase("CFO")) {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. Zoho CRM REST API: Stop Workflow from Triggeringhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-rest-api-stop-workflow-from-triggering.html

    was also a workflow that ran when the Creator record was updated to update its changes to CRM. It was actually causing a loop which used up all the API calls. How? You might already be familiar with some of the trigger options below but one that worked...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  10. Zoho CRM & Zoho Books: Get SalesPersonshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-get-salespersons.html

    an hour or so trying to get the Zoho.books.getRecords() function to filter the sales persons, I gave up and used a for each loop instead. In the next snippet of code, I am getting the Zoho CRM record owner, looping through all salespersons in Zoho...

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

    l_BooksShippingAddress = {"address","street2","city","state","zip","country"}; // loop through the CRM Sales Order address fields and build map of address to Books for each v_AddressPart in l_CrmShippingAddress {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  12. Zoho Creator: Copy Subform to other Subformshttps://www.joellipman.com/articles/crm/zoho/zoho-creator-copy-subform-to-other-subforms.html

    c_Wednesday = Collection(); c_Thursday = Collection(); c_Friday = Collection(); c_Saturday = Collection(); // // loop through Monday subform for each r_Row in input.Mondays { if(r_Row.In_Effect) { // get Monday entries/rows v_EventType =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. ZohoCRM & Xero Real-Time Invoices: Receive Webhookhttps://www.joellipman.com/articles/crm/zoho/zohocrm-xero-real-time-invoices-receive-webhook.html

    { // // parse events out of the webhook (a list) l_Events = m_Body.get("events").toJSONList(); // // loop through the events for each r_Event in l_Events { if(!isnull(r_Event.get("eventCategory"))) { // // event type will be UPDATE and eventCategory...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. ZohoDeluge: Get All eBay Orders Given a From and Till Datehttps://www.joellipman.com/articles/crm/zoho/zohodeluge-get-all-ebay-orders-given-a-from-and-till-date.html

    declare variables to store order details in a JSON or ZohoDeluge Map format m_Response = Map(); l_JsonOrders = List(); // // loop through orders in response v_OrderNodePart = "Order"; v_OrderNodeName = v_OrderNodePart + "Array"; x_OrderNode =...

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

    the number of days ago (list of dates to check) l_GeneratedList = leftpad(" ",v_DaysAgo).replaceAll(" ",",").toList(); // // loop through for each index v_Index in l_GeneratedList { // output to developer for debug purposes v_Date =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  16. Zoho Deluge: Get All Orders from eBayhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-get-all-orders-from-ebay.html

    l_OutputFields.add("TotalNumberOfEntries"); m_Params.put("OutputSelector",l_OutputFields); // // now lets loop through a dynamic page list for each v_Page in l_Pages { // // specify which page m_Pagination = Map(); m_Pagination.put("PageNumber",v_Page);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  17. ZohoCRM Webhook: Create ZohoInventory Records from an eBay orderhttps://www.joellipman.com/articles/crm/zoho/zohocrm-webhook-create-zohoinventory-records-from-an-ebay-order.html

    whether to update or create. - Check if Shipment already exists on system to determine whether to update or create. - Loop through eBay payments to record all the different payments received. Date Modified: 2023-03-14 (Joel Lipman) - Resolved fix of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. Zoho Books: Get Invoice Payment Terms via APIhttps://www.joellipman.com/articles/crm/zoho/zoho-books-get-invoice-payment-terms-via-api.html

    label because -3 often displays "Net 56" instead. m_InvoiceDetails.put("payment_terms_label","Due end of next month"); // // loop through line items and populate for each m_SOLineItem in l_SalesOrderLineItems { m_InvoiceLineItem = Map();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  19. ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttps://www.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

    phone and website from Organization Details in ZohoCRM. Upload and get publicly-accessible image URL to/from ZohoWriter. Loop through active users in ZohoCRM. Merge the HTML email signature with the fields evaluated. Function: fn_Workdrive_HostImage I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  20. ZohoCreator: Basic Widget with Zoho Datahttps://www.joellipman.com/articles/crm/zoho/zohocreator-basic-widget-with-zoho-data.html

    .then(function(response) { // store the search results into an array var recordArr = response.data; // quick loop to find the preferred name for(var index in recordArr){ v_GreetingName = recordArr[index].Nick_Name; break; } // if not blank then let's...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 61 - 80 of 85

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.