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

  1. Zoho Creator: Radio group into Calendar Carouselhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-radio-group-into-calendar-carousel.html

    CSS (link name: Form_Css || type Add Notes) Selected Value for debugging (link name: Selected_Value || type Single line) Starting Date (link name: Starting_Date || type Date) Selected Date (link name: Selected_Date || type Date) The CSS So first of all...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  2. CharIndex Reverse - find occurrence starting from end of string in TSQLhttps://joellipman.com/articles/else/database/t-sql/charindex-reverse-find-occurrence-starting-from-end-of-string-in-tsql.html

    right, as we got the last occurrence counting from the beginning rather than the end, so we still need to work out the starting point: SELECT LEN(@Haystack) - CHARINDEX(@Delimiter, REVERSE(@Haystack)) -- yields "23" SELECT SUBSTRING(@Haystack,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  3. MySQL day of week ending on Fridayhttps://joellipman.com/articles/else/database/mysql/mysql-day-of-week-ending-on-friday.html

    this for when the week ends on Friday. Assuming it starts on the previous Saturday. Why? Problems with MySQL weeks always starting on Sunday means this isn't very useful. I have another system which starts on Monday and ends on the following Sunday. The...

    • Type: Article
    • Author: Joel Lipman
    • Category: MySQL
    • Language: en-GB
  4. Zoho Projects: Get All Eventshttps://joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-get-all-events.html

    is an integer and the number of records to return (default=100; max=200) // NB: index is an integer and is the offset or starting index (not the ID of the record) m_Params = Map(); m_Params.put("range",50); m_Params.put("status","closed");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Projects
    • Language: *
  5. Unix Date Format Specifiershttps://joellipman.com/component/content/article/unix-date-format-specifiers.html?catid=63&Itemid=165

    %d day of the month (dd), zero padded 04 %e day of the month (dd) 4 %j day of year, zero padded 001-366 %u day of week starting with Monday (1), i.e. mtwtfss 1 %w day of week starting with Sunday (0), i.e. smtwtfs 1 Week %U week number Sunday as first...

    • Type: Article
    • Author: Joel Lipman
    • Category: Linux
    • Language: *
  6. Add Image Mouseover effect in AutoHotkey GUIhttps://joellipman.com/component/content/article/add-image-mouseover-effect-in-autohotkey-gui.html?catid=48&Itemid=165

    := 32643 IDC_SIZEWE := 32644 IDC_SIZENS := 32645 IDC_SIZEALL := 32646 IDC_NO := 32648 IDC_HAND := 32649 IDC_APPSTARTING := 32650 IDC_HELP := 32651 */ WM_MOUSEMOVE() { static CurrControl, PrevControl, _TT ; _TT is kept blank for use by the ToolTip...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  7. AHK Countdown Tooltiphttps://joellipman.com/component/content/article/ahk-countdown-tooltip.html?catid=48&Itemid=165

    Recommended for new scripts due to its superior speed and reliability. SetWorkingDir %A_ScriptDir% ; Ensures a consistent starting directory. SetFormat, float, 0.2 ; Round any floats to two decimals ;...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  8. AutoHotkey: Check Windows Folder Sizeshttps://joellipman.com/component/content/article/autohotkey-check-windows-folder-sizes.html?catid=48&Itemid=165

    Recommended for new scripts due to its superior speed and reliability. SetWorkingDir %A_ScriptDir% ; Ensures a consistent starting directory. #SingleInstance force ; --------------------------------------------------------------------------------------...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  9. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://joellipman.com/component/content/article/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html?catid=48&Itemid=165

    you only have 2 monitors, then note that right-most will not exist and only left and centre should with the central screen starting at coordinates 0,0 (might be different on your setup)... Note that removing the width and height parameters should simply...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  10. AutoHotkey: App GUI Listview to Rename Fileshttps://joellipman.com/component/content/article/autohotkey-app-gui-listview-to-rename-files.html?catid=48&Itemid=165

    Recommended for new scripts due to its superior speed and reliability. SetWorkingDir %A_ScriptDir% ; Ensures a consistent starting directory. ; -------------------------------------------------------------------------------------- ; Set program Defaults...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  11. Zoho Deluge: Loop through 30 Minute Slotshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-loop-through-list.html

    of the day (working hours). How? The plan is to iterate through a 24-hour clock, enable adding to the picklist when the starting hour is found and stop adding when the closing hour is found. The picklist field is called "Time_Field". The following reads...

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

    How? So here's the function I came up with. It loops through a maximum of 2500 products sorted in order of ID ascending (starting with ID=0) retrieving 250 per call and using since_id to not list the same one twice. It then outputs a JSON list as a...

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

    text to the response map m_Response.put("text", v_Answer); // // output return m_Response; Even in test mode or simply starting a Cliq conversation will now yield something like the following: Additional For every chat message, the OpenAI ChatGPT...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Other
    • Language: *
  14. Zoho Deluge: Proper Case for Nameshttps://joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-proper-case-for-names.html

    " :|JOEL|: ", true).proper(); v_FirstName = v_FirstName.replaceAll(" :|joel|: ", "-", true); // // Names starting with Mc, O', D', I' l_ExceptionPrefixes = {"Mc", "O'", "D'", "I'"}; // // deal with double barrelled surnames l_FormattedLastName = List();...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  15. Zoho Analytics & Zoho People: Monitor DataSource Sync https://joellipman.com/articles/crm/zoho/zoho-analytics/zoho-analytics-zoho-people-monitor-datasource-sync.html

    Check_DataSources_Sync_to_ZohoAnalytics () Label: Check DataSources Sync to ZohoAnalytics Trigger: Scheduled daily at 1am starting from tomorrow (3-Jul-2024) Purpose: To warn system managers if a sync started failing. Inputs: None Outputs: Emails system...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  16. Migrating from Joomla 2.5.x to 3.4.xhttps://joellipman.com/articles/cms/joomla/migrating-from-joomla-2-5-x-to-3-4-x.html

    with the string you want to find -- Replace stringtoreplace with the string you want to replace with -- REPLACE FROM A STARTING POINT -- Read-Only (see changes to commit) SELECT a.`fieldtochange`, SUBSTRING(a.`fieldtochange`, INSTR(a.`fieldtochange`,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  17. Upgrading Joomla CMS version 3.x to Joomla CMS 5.xhttps://joellipman.com/articles/cms/joomla/upgrading-joomla-cms-version-3-x-to-joomla-cms-5-x.html

    > Tick to select all > Rebuild [does not work] Using the administrator panel, go into each category and hit save and close starting with the parent categories first Copying article heading images from SP Page Builder to normal Joomla Articles SELECT...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
  18. Android OS: Add GoogleMap as fragmenthttps://joellipman.com/articles/else/app-dev/android-os/android-os-add-googlemap-as-fragment.html

    item, it would need to launch a new intent... I wanted to change my previous example so that the homepage of the app (the starting page) will simply display a button to the map (in case of offline mode or incompatibility with the device). How? In this...

    • Type: Article
    • Author: Joel Lipman
    • Category: AndroidOS
    • Language: *
  19. SSIS: How to loop through multiple flat files as data sourceshttps://joellipman.com/component/content/article/ssis-how-to-loop-through-multiple-flat-files-as-data-sources.html?catid=74&Itemid=165

    through Specify the file name convention with wildcard to indicate which files (in this example "File*.txt", all files starting with "File" - eg. "File0001.txt", "File0002.txt") For "Retrieve File Name" I put "Fully Qualified" (hoping this means the...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  20. Windows 7: System Clock is constantly going out of synchttps://joellipman.com/component/content/article/windows-7-system-clock-is-constantly-going-out-of-sync.html?catid=80&Itemid=165

    button Check the box next to Synchronize with an Internet time server is ticked Select an option from the dropdown menu starting with the first Click on the Update now button Text will appear beneath the button If you get an error, then select a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
Results 1 - 20 of 29