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

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

    // correction: I want to specify a from datetime v_NowTime = '2021-09-21 21:27:15'; // // now specify a to datetime (we're doing a working day so we add 1 business day) v_NextTime = zoho.currentdate.addBusinessDay(1).toString("yyyy-MM-dd ") +...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  2. ZohoCRM to ZohoBooks: Please ensure that the shipping_address has less than 100 characters.https://www.joellipman.com/articles/crm/zoho/zoho-books/zohocrm-to-zohobooks-please-ensure-that-the-shipping_address-has-less-than-100-characters.html

    retrieve its ID then here's the method I use: Create the sales order in ZohoBooks (either in Zoho Deluge or however you're doing it), then Retrieve the ID of the created Sales Order (captured in response) Update the Shipping Address on the Sales Order...

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

    element and convert to a Zoho Deluge list that will eventually be used to populate a dropdown. Why? Because I find myself doing this 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  4. Zoho Creator: Change Radio into Tabshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-change-radio-into-tabs.html

    page, you would be free to use some reserved CSS attributes on the page style rather such as position: absolute. Because I'm doing this inline and via code, Zoho automatically removes these. So instead, I am going to use negative/positive margins to...

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

    it, etc. Create a REST API CRM Function Login to ZohoCRM Go to Setup > Functions > New Function Give it a name and such, I'm doing the following Function Name: fn_eBay_UploadPhoto Display Name: Fn - eBay - Upload Photo Description: What it says on the...

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

    a solution. This took my team the best part of two months to find a solution. How? Disclaimer! There may be many ways of doing this, this is just one way that we used that worked for 90% of the invoices. There are invoices that may be associated to...

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

    - no other option). The Attachments folder must contain no subfolders and only unique filenames herein. Perhaps if you were doing this over several imports, you could use the same filenames, I didn't try this, instead my program generates a unique MD5...

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

    break; } } } } else { // store in response text m_Response.put("text","I don't know. Consider doing a Google search."); } } // // output return m_Response; Yields something like the following: Text-Davinci-003: (preceded ChatGPT API) // // initialize...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  9. ZohoAnalytics: Pivot Campaigns vs Contactshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zohoanalytics-pivot-campaigns-vs-contacts.html

    Sent Invited The catch is that our campaign names are in data rows not individual columns. How? There may be ways of doing this using the GUI and a "Pivot View" report but I always resort to a query when I get confused with the GUI: Query 1 Due to the...

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

    observant among you will have noted that I'm recording the module name and module record ID on the ZohoSign Document record. Doing this at the point of the request means that I can have a generic webhook that handles every ZohoSign completion and attach...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  11. Zoho Creator: isBlank and isNull: Before or After?https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-isblank-and-isnull-before-or-after.html

    code with the method appended at the end of the variable but in more complex method chaining, I can see myself accidentally doing this. It's more that I saw other code like this and when reverse engineering or debugging the code, it may be worthwhile...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  12. ZohoCRM Client Script: On Change of Dropdown: Subform Rewrite: REST Functionhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-client-script-on-change-of-dropdown-subform-rewrite-rest-function.html

    have custom fields, we need to copy over all the custom values to the new line items. How? This is about an hour's work doing it on a CRM workflow (save of record) but here we're going to do it in client script: Additionally, the line items will be...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  13. ZohoCRM / Client Script / Canvas: Hide Tab based on Pipelinehttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-client-script-canvas-hide-tab-based-on-pipeline.html

    */ // clear the console so I can see what this script is doing (among all the zoho warnings/errors) console.clear(); // try and catch exception try { // get the record ID currently displayed var v_ThisRecordID = $Page.record_id; // get the record...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  14. Zoho People: Get Performance Records over APIhttps://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-get-performance-records-over-api.html

    + v_Field + " || Value: " + m_ThisGoal.get(v_Field); } m_OutputAll.put(v_GoalKey, m_OutputRecord); } } // // for testing I'm doing 3 records at a time if(v_CountTotal > 3) { break; } } info m_OutputAll; return ""; This should give you all the fields...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho People
    • Language: *
  15. How to redirect the visitor after the contact pagehttps://www.joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

    your page in the frontend you will see the menu item for the page you created. Click on that link to view your page. We are doing this because you need to find out the exact URL of the page you created. Make sure to copy the URL as we will need some of...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  16. Add the website name to the page title in Joomla!https://www.joellipman.com/articles/cms/joomla/add-the-website-name-to-the-page-title.html

    some instructions on changing the page title in Joomla! CMS to display both the actual page title and other stuff. As I like doing this for this particular website (my personal one) in every version of Joomla it's been upgraded to, I've noticed some...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  17. Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

    the RocketTheme instructions say that you should "Purge the cache" so click on the "Run Now" button which I found myself doing at lots of stages in this installation process. So note where it is and come back to it when things aren't responding...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  18. Migrate JComments from Joomla 1.5.x to Joomla 2.5.xhttps://www.joellipman.com/articles/cms/joomla/migrate-jcomments-from-joomla-15x-to-joomla-25x.html

    Joomla or JoomlaTune (Jcomments) This script is provided as is without warranty If you do not understand what this script is doing, let someone who does run it instead INSTALL INSTRUCTIONS Install JComments on your upgraded website (at time of print:...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  19. Setup a copy of your Joomla websitehttps://www.joellipman.com/articles/cms/joomla/setup-a-copy-of-your-joomla-website.html

    for myself, but this article is for those who do not have development/test environments of their Joomla website. I have been doing this for years and still come across clients who have the one version of their website. They experiment on their...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  20. JDatabase: using the Joomla database with exampleshttps://www.joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

    // retrieve the data $rows = $db->loadObjectList(); echo $my_count; -- If you try to retrieve the data before doing the count, you should get the following error: Warning: mysql_num_rows(): 80 is not a valid MySQL result resource in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
Results 21 - 40 of 67