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

  1. Zoho Deluge: Sort a Map by a specific fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-sort-a-map-by-a-specific-field.html

    a gist of what the following snippet of code is doing, let me give an overview: Build up a map with sample data (you won't need to this, use your own data, this one is for this demonstration only) Initialize a list to hold the keys which we will use to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  2. Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

    JSON request and process it that way but my usage was to send data to a Third-Party API over which I had no control. What I need to send to the 3rd-party API: { "auth": { "secret": "can_you_keep_a_secret", "key": "aaabbbbccccddddeeeeffff11112222" },...

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

    that will help staff log time and then push the creator record to Zoho Projects. How? For the following example, you will need to have setup a Zoho Oauth Connection with the appropriate authorized scopes and have access to all related systems such as...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. Windows OS: Alt Codes / Symbols / Special Charactershttps://www.joellipman.com/articles/microsoft/windows-os/windows-os-alt-codes-symbols-special-characters.html

    order. Search for "Alt Codes" or "Symbol Codes" in a search engine for a full list. Meanwhile, here's some that you may need frequently: Currency ¢ Cent sign 0162 £ British Pound 0163 € Euro currency 0128 ¥ Japanese Yen 0165 ƒ Dutch Florin 0131 ¤...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  5. Zoho Creator: Add a subform while creating a recordhttps://www.joellipman.com/articles/crm/zoho/zoho-creator-add-a-subform-while-creating-a-record.html

    the subform afterwards (insert into [...]) but it can be done all in one go. How? Here's a use case example which you will need to adapt to your own but It should do enough (spacing has been added for demo purposes and to make it clearer). In the below...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  6. Zoho Creator: Assign an integration field value with an integration valuehttps://www.joellipman.com/articles/crm/zoho/zoho-creator-assign-an-integration-field-value-with-an-integration-value.html

    r_Details = myForm[ID == 1234567890123456789]; r_Details.Account = input.Account; But it will return the above error. You need to do the following: r_Details = myForm[ID == 1234567890123456789]; r_Details.Account = input.Account.toLong();

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

    Creator and display these in either Zoho Books or Zoho CRM. For demonstration purposes, these have been simplified and will need to be adapted for your needs. Note that I have used 2 URL methods of linking to the Creator app and some data formatting...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  8. Xero API: Send Multiple Invoiceshttps://www.joellipman.com/articles/crm/xero/xero-send-multiple-invoices.html

    in API call to Xero... apparently it can accept up to 60 invoices in one call. How? Crazy simple solution, your JSON needs to have the key "Invoices" and the list of invoices to create: {"Invoices":[... list of invoices...]} If sending just the 1: {......

    • Type: Article
    • Author: Joel Lipman
    • Category: Xero
    • Language: *
  9. Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-date-from-a-string-dd-mm-yyyy-to-yyyy-mm-dd.html

    07-Jan-1975 Tue, 7 Jan 1975 ********************* 1975-01-07 07-Jan-1975 Tue, 7 Jan 1975 Additional You would of course need to check that there is nothing wrong with the date that was submitted. Especially if it is coming from a data source, the Zoho...

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

    An article to note something I didn't realize I needed: How to address the above error and how to update a Shipping Address for a specific Sales Order in Zoho Books. Why? You might think the following request to create a Sales Order in Zoho Books would...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  11. Zoho CRM & Zoho Books: Get Books Currency and Tax IDshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-zoho-books-get-books-currency-and-tax-ids.html

    ID for Zoho Books and check the URL for whether it will be https://books.zoho.eu or https://books.zoho.com. You will also need your own CRM to Books connection name (joel_books) with scope to read settings: // our made up books org id but enter your own...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  12. Zoho Books: Display Sales Order Shipping Address on Package Sliphttps://www.joellipman.com/articles/crm/zoho/zoho-books-display-sales-order-shipping-address-on-package-slip.html

    company, address and phone from the customer record and not from the sales order change. How? The key is a setting you need to change by going to Settings > Preferences > Packing Slip Settings > and Enable "Delivery To": Then change the Shipping Address...

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

    "permalink": "https://docs.zoho.com/file/a7iyybadb", "status": "active" } ] } */ You need to select the id of the template that you want to use for the next step (will be an alphanumeric long string). The button function Create a button off the contacts...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  14. Zoho CRM & Deluge: Adding 10 minutes to a CRM Date Time fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm-deluge-adding-10-minutes-to-a-crm-date-time-field.html

    documenting Pushing a value to a datetime field in CRM but wanted another article here to remind me of the Deluge code I need to add/subtract time. Why? Just want to add 10 minutes to a date/time field in ZohoCRM and wanted a refresher for use in a...

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

    found Line:(20) The Solution/Cause So quite simply, I'm using 2 for each loops and this is one of those scenarios where you need to store the loops into different variable names: // select a bunch of creator records (ok all of them) l_AllRecords =...

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

    in the morning and will create a task if time logged is too low and will remind via Popup at about 4pm (16:00). You will need a connector (I've called mine joel_timesheet) and I've given it the following scopes: ZohoCRM.modules.ALL ZohoCRM.users.READ...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  17. Zoho Deluge: Calculate start and end of Daylight Savings Timehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-calculate-start-and-end-of-daylight-savings-time.html

    Time is in effect. Why? Admittedly, most of Zoho apps have this built-in but here's some snippets of code in case you need them. How? I will use this to amend and refine but here's the snippets for the various DSTs around the world. US (Except Arizona,...

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

    third-party API given lat/lng l_Params = List(); if(!isnull(r_GeoCode.get("latitude"))) { // add user licence key (you'll need to get your own at https://timezonedb.com/references/get-time-zone) l_Params.add("key=123456789ABCD");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  19. Zoho Deluge: Text (SMS) reminder using Twilio API (LocalSense)https://www.joellipman.com/articles/crm/zoho/zoho-deluge-text-sms-using-twilio-api-localsense.html

    our customer that they have an appointment in 1 hour with us. How? The code is actually pretty straightforward but you will need to follow these steps to get the credentials: Login to your Twilio console On the dashboard, note the ACCOUNT SID and AUTH...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  20. Zoho Analytics: Setup DataSource via FTP Connectionhttps://www.joellipman.com/articles/crm/zoho/zoho-analytics-setup-datasource-via-ftp-connection.html

    file regularly: After all that you will be shown your data table: Additional Note(s): Here are some notes & settings you may need on your quest to setup Zoho Analytics FTP Data Sources: Zoho Analytics IP Addresses to whitelist (if necessary): // EU Data...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 201 - 220 of 275

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.