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

  1. Joes Revolver Map (JRM)https://joellipman.com/component/content/article/joes-revolver-map-jrm.html?catid=53&Itemid=165

    Important Note: The ID it installs with is for my demo site. If you want to reset the visitor count and associate it with just your site, you'll need to visit www.revolvermaps.com and take your ID from the script code: For example:...

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

    This code snippet took me a while to do and the documentation is flaky so I thought I'd make a note here just in case I need to refer to it again. Why? I want to modify a picklist and fill it with options from a certain time of the day to the closing...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  3. Zoho Deluge - Get distance between two coordinateshttps://joellipman.com/articles/crm/zoho/zoho-deluge/get-distance-between-two-points-in-zoho.html

    is free albeit as-the-crow flies. This makes use of an undocumented function in Zoho which is acos or inverse cosine. Just lifted from the JavaScript library figuring if it supports cos() then try this standard function. Note this has only been tested...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  4. Zoho Deluge - Get Refresh/Access Token API v2https://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-refresh-access-token.html

    SDK and still get the above error, try setting the currentUserEmail to the email address of the super admin of your system just to check, then set a valid user preferably other than the super-admin....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  5. Zoho Deluge - Modify the product line items in an invoice modulehttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-modify-the-product-line-items-in-an-invoice-module.html

    r_Update = zoho.crm.updateRecord("Invoices",p_InvoiceID,m_Update); Additional Note(s): Just a list of fields to build up a Product Line Item: "Product_Details": [ { "product": { "Product_Code": null, "Currency": "USD", "name": "Test Product", "id":...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  6. Zoho Deluge - Compare time and currenttime with timezonehttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-compare-time-and-currenttime-with-timezone.html

    Why? A client's ZohoCRM had a different timezone setting than the user a script would be run as. The time difference was just one hour but this caused problems if comparing two datetime values. In this particular case, we needed to check on the expiry...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  7. Zoho Deluge - Determine Quarter from Date with Fiscal Yearhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-determine-quarter-from-date-with-fiscal-year.html

    Month: September :: Quarter: 1 Month: October :: Quarter: 1 Month: November :: Quarter: 2 Month: December :: Quarter: 2 And just to prove the same code snippet works for any month, let's use the same code but start in April: // let's say financial year...

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

    or DuckDuckGo (can't say for Bing, I never get around to searching that). This took several hours but it is possible, I was just about to give up even after having spoken to Zoho Support... And then I started updating multiple fields at the same time....

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

    {... do stuff here... } } // notes: // no need to check if element exists on "removeElement" Zoho OAuth Connector Just in case you don't know how to setup a Zoho OAuth Connector, here's how you do it in CRM: Login to Zoho CRM as an administrator and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  10. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date Stringhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-convert-xero-date-unix-timestamp-to-standard-date-string.html

    So this is a super quick note that I'll probably remember anyway but just in case, I'm writing this article so I don't spend time researching it later. Why? I'm synchronizing Xero Invoices with Zoho CRM Invoices and noticed that Xero stores its dates in...

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

    really need the syntax for attaching a document to a Sales Order in Books and the documentation leaves certain bits out. Just getting the syntax right and using the . setParamName is key. Let's make it even more interesting: I'm going to use a subform...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  12. Zoho Deluge: Setup an API Connection for InvokeURLhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-setup-an-api-connection-for-invokeurl.html

    and select "Server-based Applications" by clicking on "Create Now" on the appropriate box. If this is not your first app, just select "Server-based Applications", then on the plus icon to add new client. Fill in the new form to Create New Client: Client...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  13. Zoho Creator: Create a Widget which uses JavaScripthttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-create-a-widget-which-uses-javascript.html

    zoho-extension-toolkit You should get prompted for the Mac/Admin password which you type in the terminal (will not display, just type away and press the Return key). The response will be something like “added 98 packages from 60 contributors in 3.043s”....

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

    "id":"12345600000987654" },... AND .. "userlookup221_2":{ "name":"Another Joel", "id":"12345600000987653" },... So I'll just refer to https://www.zoho.com/crm/developer/docs/api/v8/insert-records.html and here's the code to associate 1 user in the...

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

    ]; info r_CreateTimeLog; You will find I've included the Hours decimal calculation above but it's not used and just for future reference. The API wants the total hours and minutes in the format "HH:mm" (eg. "34:06" = 34 hours and 6 minutes). Error(s)...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Projects
    • Language: *
  16. Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-update-a-custom-field-in-line-items-product-details.html

    [ { "percentage": 20, "name": "Sales Tax", "value": 0.99 } ] } ] } Updating with REST API v2.1 The new process doesn't just require you to add in this custom field per line item, but also requires a change to the other fields in the line item. There is...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  17. Zoho CRM: Standard Setup for Tax Rateshttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-standard-tax-rate-setup.html

    tax rates: Browse to a CRM product record (you can do mass edit on a listview of products but for demo purposes, we'll do just one) Under Price Information, edit the field "Tax" (multi-select) and select both tax rates Now go to a transactional module...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  18. Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

    combines all input fields into 1 MD5 or hash. Do you need to add a comparing if statement to all fields? Well no again, just compare on the workflow of the audit change. Something along the lines of: Add an Audit Change field: This will contain the code...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  19. Zoho Creator / Shopify: Get all Active Productshttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-shopify-get-all-active-products.html

    using a Product SKU. Community forums could only suggest looping through all the products. I then felt that actually I just need the Product IDs. This method could do with some refinement and perhaps if I find a better way to do this, then I'll put it...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  20. Zoho Creator / eBay: Get all Active Productshttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-ebay-get-all-active-products.html

    m_ActiveList.put("Pagination",m_Pagination); // uncomment this when all products retrieved and to run this to just get latest products // m_ActiveList.put("Sort","ItemIDDescending"); m_ActiveList.put("Sort","ItemID");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
Results 121 - 140 of 277