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

  1. Zoho Deluge: Calculate Days, Hours, Minutes, Seconds between two Timestampshttps://joellipman.com/articles/crm/zoho/zoho-deluge-calculate-days,-hours,-minutes,-seconds-between-two-timestamps.html

    A very quick article to calculate the time between two timestamps and break it down into days, hours, minutes and seconds. Why? I've done this in lots of other systems but here's one in Zoho Deluge. How? We're going to make use of the .toLong() function...

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

    this but just in case I do, this is an article to explain how I got the shipping address from a sales order in Zoho Books into the template of the Package Slips. Why? It took me a while of playing about with the placeholder reference fields in the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  3. Zoho CRM: Get Unique Values of a Text Fieldhttps://joellipman.com/articles/crm/zoho/zoho-crm-get-unique-values-of-a-field.html

    data-migration where the records exist in a staging module in CRM but I want to transform/translate one of the column values into the target How? So this is my plan: Setup a connector to CRM with the scopes ZohoCRM.coql.READ and ZohoCRM.modules.ALL...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  4. Zoho Creator / eBay: Get all Active Productshttps://joellipman.com/articles/crm/zoho/zoho-creator-ebay-get-all-active-products.html

    the page number and the number of entries per page, returns these in JSON as a Zoho Map datatype. How? I'm not going to go into detail on how I create an access token to query the eBay Trading API as you can read this in my article: Joellipman: Zoho...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  5. Zoho Deluge: Generate List of TimeZoneshttps://joellipman.com/articles/crm/zoho/zoho-deluge-generate-list-of-timezones.html

    quite a bit and wanted a quick way of extracting a SELECT list in someone else's form. How? So, let's copy the HTML select into a text editor, then escape the double-quotes, then prepend with a list declaration and append with a end of list suffix; loop...

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

    in the row . = ; . = ; // declare a variable to hold the collection of rows = Collection(); .insert( , ); // insert the rows into the subform through the variable input..insert( );

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

    JSON that is being returned for API names... If that were the 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...

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

    our booking form: one called "Customer's TimeZone" and the other called "Agent TimeZone", then our code needs to take these into account and will look more like the following: // defaults v_AppointmentType = "Initial Consultation"; v_AppointmentDuration...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  9. ZohoCRM: Template: not being able to edit a text boxhttps://joellipman.com/articles/crm/zoho/zohocrm-template-not-being-able-to-edit-a-text-box.html

    inventory template. Why? A client raised an issue that they had previously hard-coded the address of their organization into the body of a template (just below the header... they weren't using the header section) but then they changed address and...

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

    v_DateAdded = r_NewDocumentRecord.Added_Time.toString("E, d MMM yyyy HH:mm"); } else { r_Document = insert into Document [ Added_User=zoho.loginuser Document_Name=r_Attachment.get("File_Name") Document_File=r_Download Downloaded="Downloaded"...

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

    Well known by most but this serves as a quick reminder to 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...

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

    more documentation on the API for Zoho Books, we're going to apply this solution to Zoho Books. How? We're not going to go into detail on how to parse an eBay response here (see my other articles on eBay webhooks). Instead, all we want is the URL of an...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  13. Zoho Desk: Re-enable Desktop Notifications after clicking on "Not Now"https://joellipman.com/articles/crm/zoho/zoho-desk-re-enable-desktop-notifications-after-clicking-on-not-now.html

    Click on “Settings” Click on “Privacy and Security” Click on “Site Settings” If the ZohoDesk activity appears then click into this, if not then: Click on “View permissions and data stored across sites” Click on “zoho.eu” this will dropdown all Zoho apps...

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

    a paid invoice - check the fields updated. Go to Sales > Invoices > Select an invoice > Click on "Comments & History" Go into Settings > Automations > Workflow Logs > Custom Functions: check if/when they occurred and in relation to what invoice....

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

    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 mobile device, it's somewhat better to use the built-in interfaces provided by Zoho Creator. What...

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

    click on and it does all the aforementioned. How? The difficult part 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  17. ZohoFlow & ZohoSign: Retrieve a Zoho Sign document request and add attachments to CRM recordhttps://joellipman.com/articles/crm/zoho/zohoflow-zohosign-retrieve-a-zoho-sign-document-request-and-add-attachments-to-crm-record.html

    This is an article describing a custom function built into Zoho Flow that will accept as parameter the document_id and request_id. It then retrieves the Deal Reference (entered by an office signee) on the ZohoSign document and searches for the relevant...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
  18. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://joellipman.com/articles/crm/zoho/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
    • Language: *
  19. Joel's Reference to MidJourney v4 Promptshttps://joellipman.com/graphic-design/joel-s-guide-to-midjourney-prompts.html

    using words and phrases to instruct the Midjourney Bot (or any other AI text-2-image generator) which the bot can break down into "tokens" and then match with its training data to generate the image. Quick recap on how to first start using the...

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

    alongside each serviceable item. How? So at time of print, this is the only way I know: add a note field to inject some CSS into it and hide the delete icon as well as the "Add new row" link. In Design mode: Add a special field of type "Add Notes" to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho
    • Language: *
Results 161 - 180 of 213

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.