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

  1. Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-update-a-custom-field-in-line-items-product-details.html

    } } } Retrieving a record with 2.1 JSON The following is a snippet when querying a CRM module (invoices) from a CRM function. The important fields I wanted were some custom fields within the line items subform. Here I'm adding the parameters to ensure...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  2. Zoho Projects: Deluge to Submit Custom Fieldshttps://www.joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-deluge-to-submit-custom-fields.html

    as identifiers UDF_CHAR8 (which is a Zoho ID) and UDF_CHAR7 (which is a text/string name field). Note that in the below snippet, I've put m_Params into separate lines for display purposes but actually it should be all on one line: m_Custom =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Projects
    • Language: *
  3. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

    The slightly longer answer to describe this might be better explained if you consider the following snippet of code: // sample data v_Test = "00011,Joel Lipman,\"Flat 8, House Corner\",Brummieland"; // regex to replace a comma found between 2...

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

    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 Books, and retrieving the...

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

    to have a field showing the user's Division. This would help in reporting later down the line. How? The following code snippet will get the Opportunity/Deal/Potential record details, then get the Owner frrom the CRM users table, find the value of the...

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

    method could do with some refinement and perhaps if I find a better way to do this, then I'll put it here. But I like this snippet of code albeit a brute force to loop through every active product and list their IDs. How? So here's the function I came...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  7. Zoho CRM & Zoho Writer: Button to Merge Template, Send, and Attachhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-writer-button-to-merge-template,-send,-and-attach.html

    scopes: WorkDrive.files.ALL, WorkDrive.workspace.ALL Click on Create and Connect > Accept Get the Template ID The following snippet is a separate function to run (standalone) and will return to you the templates and the field references: r_Templates =...

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

    A very quick article with a snippet of code to get today's date, tomorrow's, and the day after's but it has to skip Sundays. Why? Wanting to create a schedule for availability over the next few days which needs to dynamically change. I am aware of the...

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

    A quick article on a snippet of code which copies one subform to other subforms in the same form. Why? I'm creating an appointment/booking system and I want the user to be able to set entries in a subform called "Mondays" then to click a button which...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  10. Zoho Creator/Deluge: UnPredictable exception, Invalid statement foundhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-deluge-unpredictable-exception,-invalid-statement-found.html

    // UnPredictable exception, Invalid statement found Line:(20) However, I'm not bad at producing errors so here's another snippet that will also cause the error: // select a bunch of creator records (ok all of them) l_AllRecords = myForm[ ID != 0 ]; //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  11. Zoho CRM: Schedule a Call using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-schedule-a-call-with-deluge.html

    case, it would have been a 5 minute job. Instead, it's turned into over an hour of figuring this out. So here's a working snippet of code: // test to get the JSON response format r_CallDetails = zoho.crm.getRecordById("Calls",123456789012345678); info...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  12. Zoho CRM: Schedule a Task: Timesheet Reminderhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-schedule-a-task-timesheet-reminder.html

    We're meant to do 40 hours, not just for Management, but for deducting from project and support bundles. How? The following snippet of code is on a CRM schedule set to run every Friday at 08:00 in the morning and will create a task if time logged is too...

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

    An article with a quick snippet of code which builds up the address from a Lead record to geocode into latitude and longitude coordinates to feed a third-party API which returns a timezone. Why? Our use-case is that we have a field called "Customer's...

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

    you noted above: Copy the Webhooks key on the Xero page into your CRM function replacing the value in Line 2 of my code snippet above. > Save the CRM function. Click on "Save" on the Xero page Click on "Send 'Intent to receive'" You should get an OK...

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

    A very quick article on a cool snippet of code, 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  16. Zoho CRM: Schedule a Meeting using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-schedule-a-meeting-using-deluge.html

    information on how to build up a JSON request to create a meeting (previously known as Event) in Zoho CRM. Here's a quick snippet of code to remind me. How? Similar to how to create a call or task, but with some variation: // // initialize...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  17. Zoho Creator: Embed Forms/Reports on a Pagehttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-embed-forms-reports-on-a-page.html

    myself and anyone else on how to embed a form or a report into a Zoho Creator page. Why? Cos How? The below is a template snippet for a Zoho Creator page. We set the parameters of the form/report. Then this shows how to embed using a DIV layer which...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  18. Zoho CRM & Zoho Inventory: Upload Image to Item Record using Delugehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-zoho-inventory-upload-image-to-item-record.html

    item record. Well I don't want to research this often so here's the quick parsing instruction to get the eBay photos; this snippet stores the URL of each picture in a list variable: l_Pictures =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  19. Zoho Creator: Populate a Multi-Lookuphttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-populate-a-multi-lookup.html

    This is a very quick article with a code snippet on how I added to a multi-lookup field. Why? Using a multi-line or text is possibly a quicker solution and when using a desktop interface, you can parse the multi-line into a nice HTML table. But on a...

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

    //info r_Create; } } } } For historical records The below snippet is what I used to bring all the past records into the custom module. The client would be able to determine what jobs have started/expired based on their Candidate reference and Vacancy...

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