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

  1. Zoho Deluge: Duplicate/Clone a Recordhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-duplicate-clone-a-record.html

    of code required to duplicate or clone a record in Zoho CRM using Zoho Deluge. Why? The aim here is to have a scheduled task that on the 1st of every month, takes the invoices for the month before, and duplicates each one for the new month. How? First...

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

    it whatever: eg. OnUserInput_ZBSoRef Put the following Deluge code: input.Attached_Files_in_CRM = false; Setup a scheduled task in Creator Schedules > New Workflow Choose a Date Field Start Date: select form and choose Modified_Time Run this process on...

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

    been using Zoho services and programming in Zoho Deluge for a few years now, even I thought of Zoho Widgets as a daunting task. But after doing some, I realize this is actually very quick to do and much easier than first thought. The article below...

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

    as a link or you can put in a Note Field for the user to download just by clicking it. Additional: Why not set a scheduled task on the expiry date/time to delete this entry for both house-keeping and security? with the following deluge...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  5. Zoho CRM: Upload a Product Photo using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-upload-a-product-photo-using-deluge.html

    uploaded successfully","status":"success"} Source(s): ZohoCRM REST API: Upload a Photo Zoho Deluge: invokeURL task for API calls

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

    parameters: m_GraphQl.toString() headers:m_Header ]; info r_GetProduct; Awesome! Now for the primary objective of this task, which was to recover the relevant product based on any given Product SKU. Making the above into a function as well as returning...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  7. Zoho CRM & Creator: Download attachment and upload to Creator file fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-creator-download-attachment-and-upload-to-creator-file-field.html

    back to CRM. How? At time of print, things have moved on and based on the Zoho official forums, this used to be a daunting task. Not anymore at least from what I've seen. You could try adding a subform to Creator but have it as a blank form rather than...

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

    A quick article on a code snippet to mark a package as shipped and delivered in Zoho Inventory. Why? As usual, any task like this that takes me longer than an hour, I'd like to document for future use. The use-case is the client has their own delivery...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Inventory
    • Language: *
  9. Zoho Analytics: Determine profits from invoices and purchase ordershttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

    I had to break this down into several queries to generate the dataset, then use these as pseudo-subqueries. The first task was to determine the cost of each item purchased; including shipping and tax. The second is to associate these to the invoiced...

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

    called "Candidates x JobOpenings" (with alternative API name as "CustomModule6"). Just to add to the complexity of the task, the client has their own reference for Candidates which they called "Candidate Ref" and their own reference for the JobOpening...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Recruit
    • Language: *
  11. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://www.joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

    understand, it would return a response similar to Siri or Ask Google where it includes the keywords in a "Search the web..." task. ChatGPT by OpenAI is viral at the time of print and although the solution below only connects to the OpenAI API, it is not...

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

    to make a subform equal the collection rather than inserting the collection into the subform using insert(). Invalid update task found corresponding properties: Trying to update a time field with a string is a no go. Set it to an atom time or nice SQL...

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

    orders from a client's eBay. Why? Our use-case is a data migration from eBay to a fresh instance of Zoho Inventory. In this task, we are simply getting a CSV with all the order IDs for a particular year output as a spreadsheet. How? Similar to how we...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  14. Zoho Deluge: Proper Case for Nameshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-proper-case-for-names.html

    Zoho Deluge. How? There are a number of combinations that I won't have thought of but the below code sufficed for my current task, common English and some European names: // // set first and last name v_FirstName = "BILLIE-JO"; v_LastName =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  15. Zoho Books: Generate Bank Text File for Downloadhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-generate-bank-text-file-for-download.html

    details and should not be stored anywhere. Generating a text or CSV file and then having it emailed to anyone is an easy task but here we cannot have that file sat on someone's mailbox. It must be downloaded (as in browser downloads it to the computer...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  16. Zoho CRM: Client Script Confirmation Box and Popup Mailerhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-client-script-prompt-and-popup-mailer.html

    here is non-existent. It's more of a play around to see what can be achieved and how much this can be customized. The task I've set for myself is as follows: Trigger if the contact record has a tickbox called "Extra Confidential" ticked/checked=true...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  17. Zoho Analytics: Create a Monitoring System with Imageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-create-a-monitoring-system-with-images.html

    FROM "Meetings" mtg ) AS t4 LEFT JOIN "Joels Image Library" img4 ON t4."Status" = img4."Status Value" UNION ALL SELECT 'CRM Tasks' AS "DataSource", date(t5."ModifiedTime") AS "Date", t5."RecordID" AS "Record ID", t5."RecordName" AS "Record Name",...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  18. Zoho CRM & Zoho Sign: Send CRM Merged Template for Zoho Signhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-sign-send-crm-merged-template-for-zoho-sign.html

    then return the Signed document attached to the initial record (where the button was). Why? If anyone has the envious task of sending a document out for signing by a customer, you will know this takes a while to do: You have to find the contact record...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  19. Zoho CRM: Updating a CRM record Custom Line Items using API v7https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-updating-a-crm-record-using-api-v7.html

    type :PUT parameters:m_Data.toString() connection:"zcrm" ]; info r_QuoteDetails; } Source(s): Zoho Deluge: invokeAPI Task Zoho CRM: Insert or Update Records (Upsert) - not used in above example but here if I want to use it one day. Zoho CRM: Update...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  20. Zoho Deluge: Connect to Shopifyhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-connect-to-shopify.html

    and password, or a client and secret in the endpoint of a URL will no longer be supported in the Zoho Deluge invokeURL task... This article exists because I spent 2 hours going down the rabbit hole of trying to use OAuth2 and following the usual steps:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
Results 21 - 40 of 50