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

  1. MySQL day of week ending on Fridayhttps://www.joellipman.com/articles/else/database/mysql/mysql-day-of-week-ending-on-friday.html

    Week Ending Date has been requested a lot more frequently now. It's an odd one but the example below shows how to do this for when the week ends on Friday. Assuming it starts on the previous Saturday. Why? Problems with MySQL weeks always starting on...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  2. Zoho Cliq: Integrate OpenAI ChatGPT with Conversation Threadshttps://www.joellipman.com/articles/crm/zoho/zoho-other/zoho-cliq-integrate-openai-chatgpt-with-conversation-threads.html

    necessary scope(s). Note that you have to do this as the super admin to get organization level messages. But in ths example below, we're going to query a message to the ChatGPT bot: // // initialize m_Response = Map(); v_Message = message.trim();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  3. Autohotkey Count Number of Files/Folders in a Directoryhttps://www.joellipman.com/component/content/article/autohotkey-count-number-of-files-folders-in-a-directory.html?catid=48&Itemid=165

    -- yields number of files in a directory recursively. Method #4: FileSystemObject ComObjCreate -- usage (see functions below) TotalFileCount := CountFilesRecursive( "C:\" ) MsgBox, TotalFiles %TotalFileCount% -- functions to put at bottom of script...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  4. AutoHotkey: Get Media Information and Displayhttps://www.joellipman.com/component/content/article/autohotkey-get-media-information-and-display.html?catid=48&Itemid=165

    for this particular app. For this reason, we are going to use a function by Skan called Filexpro() which is copied in the below: Filexpro( sFile := "", Kind := "", P* ) { ; v.90 By SKAN on D1CC @ goo.gl/jyXFo9 Local Static xDetails If ( sFile = "" ) { ;...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  5. Forum Ruleshttps://www.joellipman.com/component/content/article/forum-rules.html?catid=50&Itemid=165

    wrong. Please edit your post and tone it down before your timer runs out. To edit a post, click the "Edit" button right below it. Cheating the censor system is against the rules. If you break one of these rules, the following penalties will apply (first...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  6. Licence GNU/GPLhttps://www.joellipman.com/component/content/article/licence-gnugpl.html?catid=50&Itemid=165

    outside their relationship with you. Conveying under any other circumstances is permitted solely under the conditions stated below. Sublicensing is not allowed; section 10 makes it unnecessary. 3. Protecting Users' Legal Rights From Anti-Circumvention...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: *
  7. Joe's Unduplicater (JUD)https://www.joellipman.com/component/content/article/joes-unduplicater.html?catid=53&Itemid=165

    AS WELL AS COMMENTS/SUGGESTIONS: You can leave a comment or suggestion anonymously or as a registered member using the form below.

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

    each photo (~240/hour ?). Take an Immediate Picture Batch Process a text file of websites (-> see "TEXT file example" below) TEXT file example http://www.joellipman.com http://www.joellipman.com/index.php?option=com_content&view=article&id=509...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  9. Joes Revolver Map (JRM)https://www.joellipman.com/component/content/article/joes-revolver-map-jrm.html?catid=53&Itemid=165

    Configure the map to the settings you want. Copy the ID reference as per the "Important Note" below. Login to your Joomla website admin panel Install this module as per usual (will auto-install) Go to Extensions > Module Manager Paste the ID code you...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  10. AwStats Data Parser (ADP)https://www.joellipman.com/component/content/article/awstats-data-parser-adp.html?catid=53&Itemid=165

    1 Click on "Go". What data does it return? Any table/grid in the Awstats report uniquely identified by the labels mentioned below. What data does Joes Infographic for Joomla (JIJ) need? Summary Period Report (details on your awstats report) Monthly...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  11. Joes Password Analyzer (JPA)https://www.joellipman.com/component/content/article/joes-password-analyzer-jpa.html?catid=53&Itemid=165

    and check the "Rule Abiding" variation as a strong password to use. Comments/Suggestions Please use the comment section below to suggest changes, corrections, improvements or just to give an opinion. Use it! It's absolutely FREE! The password analyzer...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  12. Joes Search Module (JSM)https://www.joellipman.com/component/content/article/joes-search-module-jsm.html?catid=53&Itemid=165

    searches as I see from Google searches that this does not exist as yet. Comments/Questions Please use the comment box below to add any questions (you can even post anonymously) or suggestions you might have. Thank you for your time! « DOWNLOAD ݏ

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  13. Zoho Deluge - Determine Quarter from Date with Fiscal Yearhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-determine-quarter-from-date-with-fiscal-year.html

    showing this in Zoho Deluge but the logic can be adapted to other code. You will need this snippet of code for the examples below: l_Months = {1,2,3,4,5,6,7,8,9,10,11,12}; l_MonthNames =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  14. Zoho Creator: info/alert/modal/popup notification for any userhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-info-alert-modal-popup-notification-for-any-user.html

    because info can only be displayed to an admin and even in some cases only as an additional link in the form. The example below is for use in a customer portal on the click of a report button (report workflow). How? This will create a popup using the...

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

    causes errors further down the line. Just add these parameters as per my above instructions for a more robust solution. [See below for full code] Enter the code to determine total number of employees in this department/team: To determine the total...

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

    how to send a Zoho Deluge Map request to an API which is expecting nested/2d/multi-dimensonal arrays. In the example below, we are posting to a PHP script for testing but I have since sent something similar to an API expecting nested arrays (not sure if...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  17. Zoho CRM: Update a custom field in line items / product details using REST API v2.1https://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-update-a-custom-field-in-line-items-product-details.html

    ability to have custom fields in your line items, alongside the product name, list price, quantity, tax, etc. In the example below, we have added a column called "Group Name" in the CRM Quote module as per the following screenshot: How? Again at the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  18. Zoho Projects: Deluge to Submit Custom Fieldshttps://www.joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-deluge-to-submit-custom-fields.html

    have as identifiers UDF_CHAR8 (which is a Zoho ID) and UDF_CHAR7 (which is a text/string name field). Note that in the below snippet, I've put m_Params into separate lines for display purposes but actually it should be all on one line: m_Custom =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Projects
    • Language: *
  19. Zoho Creator: Add a subform while creating a recordhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-add-a-subform-while-creating-a-record.html

    need to adapt to your own but It should do enough (spacing has been added for demo purposes and to make it clearer). In the below example, my form is called "Quotes" and my subform is called "Line_Items": // initialize variables //... this is a demo so...

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

    field to update In your code, sort a list by "Modified_Time", loop through and update each iterated record. (see sample code below). Go to the list view in CRM and filter by "Processed" is "Selected", check after each run of the function that the number...

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