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 client is required, the following 114 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

    is excluded from being copied as it was an autonumber in our example. zohoapis.eu is used in the above example for a client on the EU datacenters. If your datacenter is in the US then this should be zohoapis.com. Additional Additional(s): I haven't done...

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

    = "Europe/London"; v_ZohoTime = v_ZohoEpoch.toLong().toTime("yyyy-MM-dd HH:mm:ss", v_IanaTZname); // The best method is per client: // Login to Xero > Accounting > Accounting Settings > Financial Settings > Time Zone // convert to IANA TimeZone and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  3. Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-search-records-with-special-characters-coql.html

    Click Create and Connect You will be prompted to allow permissions, so click on "Accept/Allow" 2. Determine the client datacenter Look at the URL (website address) of the CRM you are wanting to do this on. The part after Zoho is the top level domain...

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

    in CRM in a custom module in field that was of type "File Upload". Why? Just to remind me where I went wrong, I have a client with ZohoCRM who upload a PDF (can be any file but is usually a PDF) to a custom module in their CRM; I then need the customer...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  5. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirectshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-two-submit-buttons-on-a-non-stateless-form.html

    which both submit the form but one leaves the current record open while the other redirects to the reports view. Why? A client wanted a "Save" button on their form as well as a "Save & Close" button. The "Save" button would submit the form but keep the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  6. ZohoCRM: Process all records of a modulehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-process-all-records-of-a-module.html

    but lately this hasn't been working for me. To this end, I have thought of an alternative that I now use frequently in client systems. How? The gist is that we add a checkbox called "Processed" which will have a datatype Boolean. Our function will then...

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

    A quick 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...

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

    click a button to generate a merged document in Writer and attach it to the CRM record. Why? Our use-case is that we have a client who has to go to the CRM record, click on Mail Merge, which opens Writer, then has to click on various settings and run...

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

    days which needs to dynamically change. I am aware of the function .addBusinessDay() but that excludes Saturdays which my client still works on. How? We're going to get today's date, then use the .addDay(), check none of these are a Sunday, and move the...

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

    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 client system. The usual error is something similar to the following: { "code": "INVALID_DATA", "details": { "expected_data_type":...

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

    step-by-step of how I setup a recurring data source in Zoho Analytics via FTP. Why? The use-case here is that I have a client who wants to import data via FTP (SFTP - to be precise) and have this available to their Zoho apps. My aim(s) are: Setup...

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

    have added this to my Zoho Deluge - Some Useful Regular Expressions list but I felt this deserved its own article. Why? A client wanted the discount displayed on a template and if they gave 10% discount, it would display as 10.00%. And they need the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  13. Zoho CRM: Using a function for validation rules (or restricting specific picklist options by user profile)https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-using-a-function-for-validation-rules.html

    profile of a user. Why? There were several alternatives we considered beforehand which still didn't fit the requirement: A client's first-line agents would have a lead record with the status "New Lead". The client wanted that if the status had changed...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  14. Zoho Inventory & eBay Picture Services: UploadSiteHostedPictureshttps://www.joellipman.com/articles/else/e-commerce/ebay/zoho-inventory-ebay-picture-services-uploadsitehostedpictures.html

    want to push an image from Zoho Inventory to eBay. How? Again, there is a caveat in that the subscription you have or your client has, needs to be Zoho One. Because we're going to use Zoho Creator as a middleware. Just to add to the pain, I'm going to...

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

    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 drivers and want them to mark a sales order & package as shipped and delivered. How? Here's a code...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Inventory
    • Language: *
  16. Zoho Desk: Re-enable Desktop Notifications after clicking on "Not Now"https://www.joellipman.com/component/content/article/zoho-desk-re-enable-desktop-notifications-after-clicking-on-not-now.html?catid=129&Itemid=165

    prompted initially and having clicked on "Not Now". Why? I'm not sure when this prompt is supposed to prompt you again. A client of ours had accidentally clicked on "Not Now" instead of clicking on the "Enable". Documented below is how to get this to...

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

    that the workflow was triggered and ran this function sendmail [ from :zoho.adminuserid to :"info@joellipman.com" subject :"Client Test: ZB: Payment Received for Invoice " + v_InvoiceRef message :"Workflow was executed and function ran: Balance: " +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  18. ZohoCRM: Import Attachmentshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-import-attachments.html

    to document the import process of a bunch of files into a ZohoCRM system. Why? Our use-case here is a data migration for a client from a legacy CRM to ZohoCRM. They have a lot of files they want attached to their respective records in CRM. This took me...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  19. Zoho Creator: Disable/Hide the add and delete subform row buttonshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-disable-hide-the-add-and-delete-subform-row-options.html

    a setting using the GUI. Why? Our use-case is that we have a subform which gets autopopulated with a list of services. The client does not want their operations team adding/deleting rows and instead simply specifying quantity (defaulting to zero)...

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

    for debugging/monitoring purposes but it's easier to use an access token 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
Results 61 - 80 of 114