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

  1. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

    } } product { id title handle } updatedAt } } } } I found this is the same as the inventoryQuantity so might as well reduce those costs (by almost a half!). Source(s): Shopify Partners - How to Generate a Shopify Access Token (legacy) Shopify Community...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  2. Zoho Analytics: Determine profits from invoices and purchase ordershttps://joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-determine-profits-from-invoices-and-purchase-orders.html

    ID" LEFT JOIN "Sales Persons" sp4 ON sp4."Sales Person ID" = i."Sales Person ID" And for true profits, we need to include those credit notes for refunds, etc. This tweak is if we want to calculate credit notes issued in a particular month rather than...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  3. Zoho Cliq: Integrate OpenAI and ChatGPT 3.5 Turbohttps://joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-and-chatgpt-3-5-turbo.html

    on the Zoho Community Forums to connect a ZohoCliq to the OpenAI API and ChatGPT... Note that I have another article for those who want to integrate ChatGPT with ZohoZIA. Why? Previously, I would edit the message handlers of a Cliq Bot I created but it...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  4. Zoho Creator: Sendmail a list of attachmentshttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-send-mail-a-list-of-attachments.html

    from a public domain, no user wall. The key here which the official documentation is missing is the .setParamName() but for those who have spent time to find this function, they'll already know this. void fn_Joel_Test() { /*** - tried with getUrl() but...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  5. ZohoCRM: Using Criteria with Module Record Counthttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-using-criteria-with-module-record-count.html

    for a field (mentioned in point #3 of the Note on this page), like Campaign_Name:equals:CRM, the response will contain only those records whose Campaign_Name is "CRM" and not records with "Best CRM" or "Latest CRM" in their Campaign_Name fields. When...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  6. ZohoCreator: Using .toFile and Uploading to a Creator fieldhttps://joellipman.com/articles/crm/zoho/zoho-creator/zohocreator-using-tofile-and-uploading-to-a-creator-field.html

    a JS widget that will download the CSV (in this case a Text *.txt) file for use by a dynamic auto-suggester dropdown; one of those fancy ones that includes photos and a bit of fuzzy logic. I thought I could simply update the field with the new file but...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  7. Zoho Webhooks & Shopify API: Keep Disappearinghttps://joellipman.com/articles/else/e-commerce/shopify/zoho-webhooks-shopify-api-automatically-restore.html

    webhook: expected String to be a Hash In this invokeURL, set the parameters to a JSON string using .toString(). For those puzzled as to how you setup a webhook function in ZohoCRM: Create a function with a string parameter called "crmAPIRequest". It has...

    • Type: Article
    • Author: Joel Lipman
    • Category: Shopify
    • Language: *
  8. Zoho Creator: Render to PDF with margins and page numbershttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-render-to-pdf-with-margins-and-page-numbers.html

    "can it say this instead?", "can it be in a bigger font?"... without pushing back too much, it can end up looking like those old websites with HTML tables. We're going to use a HTML table again but that's because I want to send it to the PDF renderer in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  9. Zoho Analytics: Create a Monitoring System with Imageshttps://joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-create-a-monitoring-system-with-images.html

    the image and select "Copy Image Address", and paste it into the cell alongside the status key in the data table: Done all those. Now again this is completely optional, but I want to have the URL of the image alongside this 2nd column so I'm going to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  10. ZohoCRM GetRelatedRecords INVALID_DATAhttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-getrelatedrecords-invalid_data.html

    { // // cancel all related quotes // (...) // // cancel all related sales orders (including those that have been approved or converted) l_RelatedSOs = zoho.crm.getRelatedRecords("SalesOrders", "Deals", m_Deal.get("id"), 1, 200, m_IgnoreRestrictions);...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  11. PHP Script: Make your own Thumbnail Generator via APIhttps://joellipman.com/articles/cms/website-development/php/php-script-make-your-own-thumbnail-generator-via-api.html

    subdirectories inside both _origs and _thmbs when you supply a client key in the request. You do not need to pre-create those. Secure Access via GET All calls must include: name — the output file name without the extension url — the source image URL...

    • Type: Article
    • Author: Joel Lipman
    • Category: Personal Home Page
    • Language: *
  12. ZohoCRM & Xero: Function to pull most recent quoteshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-quotes.html

    (Joel Lipman) - Initial release Date Modified: ??? - ??? More Information: Ensure that all possible tax rates in Xero match those in Zoho; the output of this function will give you a copy&paste list...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  13. Community Builder in Joomla Vulnerabilityhttps://joellipman.com/articles/cms/joomla/community-builder-in-joomla-vulnerability.html

    . In fact, there are quite a few vulnerabilities my scanners have picked up on and so I'll be posting solutions for those who need to keep Community Builder as their user manager. There are several things I have picked up which I will go into more...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  14. Change default order of weblinkshttps://joellipman.com/articles/cms/joomla/change-default-order-of-weblinks.html

    changes is a hard process to keep track of. Joomla 1.6.x Responding to a comment by J16 User (9 July 2011): As an update for those of us brave enough to use the upgraded CMS, I have looked into this and it would appear that Joomla! CMS have not changed...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  15. Anti-Spam override for all submitted datahttps://joellipman.com/articles/cms/joomla/anti-spam-override-for-all-submitted-data.html

    the captcha wouldn't even match what you typed and what it displayed!!! I have written this article to be another one of those programmer's tweaks. This is quite a simple fix and I will hopefully be able to keep it simple for non-programmers. The tweak...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  16. RokDownloads Manager does not list fileshttps://joellipman.com/articles/cms/joomla/rokdownloads-manager-does-not-list-files.html

    this isn't a problem for those that don't use RokDownloads. The other day, I logged in to upload some new files and manage some of my downloadable files... Only to find that the Rokdownloads manager would not list any of my files!?! I am in the middle...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  17. Creating a Profile Plugin for Joomla 1.6https://joellipman.com/articles/cms/joomla/creating-a-profile-plugin-for-joomla-16.html

    "profiles". So I should end up with the following file/directory structure: ./profile5 ./profile5/profiles Also copy one of those handy blank "index.html" files into each of these folders in case "directory listing" gets enabled on your server.I'm going...

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

    More for others than 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...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  19. Call to a member function mark() on a non-object in Joomla CMShttps://joellipman.com/articles/cms/joomla/call-to-a-member-function-mark-on-a-non-object.html

    the error was due to an update process gone wrong. Not really the fault of Akeeba, Joomla or anyone, it's just one of those things. Check the sizes of the PHP files on your site and hope that they're not at 0 bytes. Excluding the HOME folder - only...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  20. List all cron jobs for all usershttps://joellipman.com/component/content/article/list-all-cron-jobs-for-all-users.html?catid=63&Itemid=165

    "s/^ //" done; } # Given a stream of cleaned crontab lines, echo any that don't include the # run-parts command, and for those that do, show each job file in the run-parts # directory as if it were scheduled explicitly. function lookup_run_parts() {...

    • Type: Article
    • Author: Joel Lipman
    • Category: Linux
    • Language: *
Results 21 - 40 of 64