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

  1. GDPR Privacy Policyhttps://www.joellipman.com/component/content/article/gdpr-privacy-policy.html?catid=50&Itemid=165

    • Type: Article
    • Category: Static Items
    • Language: *
  2. Privacy Policyhttps://www.joellipman.com/component/content/article/privacy-policy.html?catid=50&Itemid=165

    and services. We may periodically send promotional emails about new products, special offers or other information which we think you may find interesting using the email address which you have provided. From time to time, we may also use your...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: en-GB
  3. Before and After, Highs and Lowshttps://www.joellipman.com/component/content/article/before-and-after-highs-and-lows.html?catid=75&Itemid=165

    at the moment. There must be a way. Or is time always on that dimension? HAVING is pointless, WITH ROLLUP is interesting, think I'm looking in the wrong place. Using Aggregate Functions? What follows is the T-SQL Query I finally went with. Lots of...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  4. Joe's CSV Chart Generator (JCG)https://www.joellipman.com/component/content/article/joellipmans-csv-chart-generator.html?catid=53&Itemid=165

    provide a flash-based interactive chart which you can zoom in and out of, includes almost every type of chart you can think of (though this program only uses chart types: Area, Bar, Column, Line and Pie). Note that AMCharts.com is free as long as you...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  5. Joes FREE Website Thumbnailer (JWT)https://www.joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=53&Itemid=165

    can run off a floppy disk/USB but will need an installed version of MS Internet Explorer on the computer it's run. If you think you don't have MSIE but you have Windows XP, it's likely you have it anyway. Open Source: Open to view/modify the source code...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  6. Joes Quicklist Weblinks (JQW)https://www.joellipman.com/component/content/article/joes-quicklist-weblinks-jqw.html?catid=53&Itemid=165

    or TIF). The program I had made to take the screenshots made them all the same type which is probably why I made the module think all thumbnails were equal. The module specifies the size of the image. The module keeps generating website thumbnail...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  7. Joes Google Map for Joomla (JGM)https://www.joellipman.com/component/content/article/joes-google-map-for-joomla-jgm.html?catid=53&Itemid=165

    I made for the Joomla Content Management System versions 2.5 or later. Why? Could have probably used someone else's. I think there's loads out there but thought making my own to do exactly what I want was quicker. Script Function This displays a google...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  8. Zoho Creator: Retrieve record with case-insensitive queryhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-retrieve-record-with-case-insensitive.html

    } What Happens: In the example above, the count to see if "Myproduct1" exists counts as zero (0). It doesn't think the product exists because it is searching with case-sensitivity enabled. It tries to insert into the product table, but returns the error...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  9. Zoho People: Reject an Application for Leave in Deluge based on Criteriahttps://www.joellipman.com/articles/crm/zoho/zoho-people/zoho-people-reject-an-application-for-leave-in-deluge.html

    } } } Note: Play around with the Status, there are "Pending", "Cancelled" (UK spelling), "Approval Not Enabled" and I think "Approved", "Rejected". We're using the !="Cancelled" and probably !="Rejected" because we want pending ones to also be taken...

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

    task... because it is possible, the technique above is simply wrong. The trick and solution is a lot simpler than you might think... Doing the above, I would get a really messy response (I'm targeting an API made with ExpressionEngine) such as: Fatal...

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

    field link name "Account"; Then I have a workflow on user input of the field to save this directly to the record; You would think the following would work: r_Details = myForm[ID == 1234567890123456789]; r_Details.Account = input.Account; But it will...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  12. Zoho CRM & Zoho Books: Get SalesPersonshttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-crm-zoho-books-get-salespersons.html

    break; } } m_CreateSO.put("salesperson_id",v_SalesPersonID); } Additional Note(s): Scope(s) required: for the connection I think it was ZohoBooks.settings.READ for the sales persons and then ZohoCRM.modules.all for the CRM sales orders.

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  13. Zoho CRM: Standard Setup for Tax Rateshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-standard-tax-rate-setup.html

    learn as a quick point of reference. Why? Some clients systems will presume that they don't need their sales or CRM users to think about tax and probably manage it in Zoho Books leaving it to their finance team. This is a quick run-through for a...

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

    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 be enough: { "date": "2021-09-08", "zcrm_potential_id":...

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

    { "count": 200, "more_records": true } } Which isn't what I want because it has returned the same currency several times and thinks they're unique/distinct because the IDs of each quote record are different. Having spoken to Zoho and raised with the...

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

    > Leads Select "Validation Rules" and cick on "New Validation Rule" Choose the layout, this has to be the highest level (I think) as a custom lead layout didn't work Choose field to validate > Select "Lead Status" Choose validation type as "Validate...

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

    the listing in eBay's interface, it may get confused as to where the photo came from and will error when displaying it. I think it will be fine. Source(s) Joel's tired and inefficient brain The non-existent and plethora of forums not explaining how to...

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

    Encountered {"code": 4,"message": "Invalid value passed for salesorder_id"}: Not sure about what ended up fixing this one. I think I converted the sales order to an invoice and created a package slip for it. The invoice was then sent (payment=unpaid)....

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

    slip taken from Zoho Inventory. I'd prefer if it was included in the list view or a Zoho Creator report. How? We would think it similar to a picklist/dropdown where you simply add an option to the picklist and then specify which of the options are...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  20. ZohoCRM: Get All eBay Active Listingshttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-get-all-ebay-active-listings.html

    it asks you to set an estimated number of products that are in your listing, it will then generate the number of pages it thinks it has to loop, so try and give a number higher than the actual number of products you have in your shop, it will stop when...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
Results 1 - 20 of 49