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

  1. Zoho Deluge: Get Image Uploaded in Creator Formhttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-image-uploaded-in-creator-form.html

    upload field that has the field link name "MyImage". There is an additional single-line text field called "Name". I have added an entry with name "Logo" and I have uploaded an image accordingly. // change this to eu (Europe), com (US), com.cn (China),...

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

    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”. Check the CLI installation by typing: zet –v This should return the version of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  3. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

    so that only record owners can access this record in report or form r_HoldInCreator = insert into Download_File [ Added_User=zoho.loginuser Owner_Email=v_ResultEmail File_Name=v_ThisFileName File_Ref=v_ThisFileCrmID Expiry_Date_Time=v_ExpiryTime...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  4. 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

    m_Delete); } } Update 2025 Having to do this again in 2025 and things seem to have changed. I've added a multi-user lookup on the quotes record called "Requires_Approval_Users". A quick setup method is now to use the CRM interface to add a couple of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  5. Zoho CRM & Zoho Books: Custom Related Lists Delugehttps://joellipman.com/articles/crm/zoho/zoho-books/zoho-crm-zoho-books-custom-related-lists-deluge.html

    = ifnull(r_Result.get("Exchange_Rate"),1); v_ModifiedTime = ifnull(r_Result.get("Modified_Time"),r_Result.get("Added_Time")).toTime().toString("dd/MM/yyyy hh:mm a"); // // future proofs v_ExchangeRate = if(v_ExchangeRate == 0,1,v_ExchangeRate); // //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  6. ZohoCRM: Deluge: Map a custom field from user profilehttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-deluge-map-a-custom-field-from-user-profile.html

    article to remind me how to quickly get a field from a user's settings based on the owner of a record. Why? A client had added a custom lookup field to the users settings called "Division" (similar to team name) and wanted any Opportunity record to have...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  7. Zoho Creator: Change Radio into Tabshttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-change-radio-into-tabs.html

    Zoho Creator ones provide. First, let's add a Notes field to the Creator form, I'm calling mine Note_CSS, then I have added a radio group called Tabs [NB: If you rename it from "Tabs" to something else, all CSS references need to be changed as well to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  8. Zoho Creator/Deluge: Calculating with Timezone Offsethttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-deluge-calculating-with-timezone-offset.html

    we're not bother with Daylight Savings Time. The field is a text line field called Customers_Requested_Time and I have added a few more date time fields called GMT_Date_Time_Start, GMT_Date_Time_End, System_Date_Time_Start, System_Date_Time_End,...

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

    a latitude and longitude, then we're going to use a free TimeZone API (one that returns a timezone given a lat/lng). The added feature is that we are going to loop through picklist options (500 timezones) in CRM to select the most relevant one. If all...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. Zoho Deluge: Regex Rounding and/or Removing Trailing Zeroshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-regex-rounding-and-or-removing-trailing-zeros.html

    another regular expression, I've been trying out to round up a number or at least to remove the trailing zeros. I could have added this to my Zoho Deluge - Some Useful Regular Expressions list but I felt this deserved its own article. Why? A client...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  11. Zoho Books/Inventory: Trigger a workflow when an invoice has been paidhttps://joellipman.com/articles/crm/zoho/zoho-books/zoho-books-inventory-trigger-a-workflow-when-an-invoice-has-been-paid.html

    customer and the problem happened in that the workflow would simply not trigger when the invoice was paid. The customer had added 3 custom fields: Payment Method, Payment Date, and Last Four Digits. They needed these because sometimes their customers...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  12. Zoho CRM / Deluge: Send an email with a CRM Quote using a given CRM templatehttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-send-an-email-with-a-crm-quote-using-a-given-crm-template.html

    here was to figure out how to convert the CRM record into a PDF using a customer's template. // // initialize (this is code added to a button so should alert user if no email was specified) v_OutputMessage = ""; v_TemplateID = "123456789012345678"; //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  13. Zoho Recruit: Rollup Number of Recruit Candidates to CRM Accounthttps://joellipman.com/articles/crm/zoho/zoho-recruit/zoho-recruit-rollup-number-of-recruit-candidates-to-crm-account.html

    ZohoRecruit, it was helpful on the CRM record to see how many candidates had been placed at this particular CRM Account. We added several fields which get populated when a candidate was modified in ZohoRecruit. How? As mentioned, we're going to update...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Recruit
    • Language: *
  14. Zoho CRM: Manage a subform using Client Scripthttps://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-manage-a-subform-using-client-script.html

    Client Script. Why? A client wanted an automation on-the-fly that when selecting a specific value in a field, a row would be added to a subform contained herein. How? Well I won't go in to detail on how to add a client script, this article is just to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  15. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://joellipman.com/articles/crm/zoho/zoho-recruit/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

    r_Data in r_Associated.get("data") { if(!isnull(r_Data.get("id"))) { // // search by record name to see if we've already added this record before // note the endpoint and then the field comparison here v_SearchEndpoint =...

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

    Deluge Code So this is a Zoho Creator function that I'm going to call API.fn_ShopifyQuery_UpdateAllProducts() and it will be added to a nightly schedule. It's aim is to recover all the modified records of a day and ensure that the data in Zoho is the...

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

    then getting the OAuth access codes from the client. How? I'm going to split this into 2 code snippets that were in practice added to the same function and that worked at time of print. Note that this uses the old Trading API as the new API is only...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  18. ZohoCRM: Get Organization Business Hours using Deluge/APIhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-get-organization-business-hours-via-deluge-api.html

    a booking system in ZohoCreator, I want to enter the default working shift for an employee either existing or that has been added to the system based on the business hours set at the organization level in ZohoCRM. How? Using an invokeURL, the key here...

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

    for a specified year Date Created: 2023-03-29 (Joel Lipman) - Initial release Date Modified: 2023-03-29 (Joel Lipman) - Added in ability to list errors and query order line item IDs (ErrCode: 21917182) - Modified to check that there are some orders....

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  20. Zoho Creator: Error Code 2945: EXTRA KEY FOUND IN JSONhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-error-code-2945-extra_key_found_in_json.html

    "my_creator_connection"); // // SUCCEEDS: with r_Create = {"code":3000,"data":{"ID":"1234567000012345678"},"message":"Data Added Successfully"} Source(s): Zoho Creator / API Status Codes Zoho Community / Zoho One / Using Zoho One Zoho Community / Zoho...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
Results 41 - 60 of 114