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

  1. Functions to convert Hex 2 RGB and vice-versahttps://www.joellipman.com/component/content/article/functions-to-convert-hex-2-rgb-and-vice-versa.html?catid=48&Itemid=165

    are for autohotkey and in AHK code. Taken from Autohotkey forums topic 1878: From Hexadecimal to RGB From RGB to Hexadecimal Check for a valid hexadecimal value From Hexadecimal to RGB: HEX2RGB(HEXString,Delimiter="") { If Delimiter= Delimiter=,...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  2. Making a CD copy with only one drivehttps://www.joellipman.com/component/content/article/making-a-cd-copy-with-only-one-drive.html?catid=80&Itemid=165

    OK Select the SOURCE AND DESTINATION tab Verify that both COPY FROM and RECORD are the same drives Select the ADVANCED tab Check that COPY SOURCE CD TO HARD DRIVE FIRST is selected Click on COPY and wait for the CHECK MEDIA dialog box to appear Insert...

    • Type: Article
    • Author: Joel Lipman
    • Category: Windows OS
    • Language: *
  3. MySQL Transactions in PHPhttps://www.joellipman.com/articles/else/database/mysql/mysql-transactions-in-php.html

    expected result before committing any changes to the data. This where transactions are useful. We can run the queries, then check if some conditions are met before committing the changes in the data: $mysqli->begin_transaction(); $mysqli->query ("UPDATE...

    • Type: Article
    • Author: Ike Francis
    • Category: MySQL
    • Language: en-GB
  4. GDPR Privacy Policyhttps://www.joellipman.com/component/content/article/gdpr-privacy-policy.html?catid=50&Itemid=165

    • Type: Article
    • Category: Static Items
    • Language: *
  5. AutoHotkey - MS Windows 10 - Open Apps on Multiple Monitors and Desktopshttps://www.joellipman.com/component/content/article/autohotkey-ms-windows-10-open-apps-on-multiple-monitors-and-desktops.html?catid=48&Itemid=165

    basic code to: 1) get all monitors, 2) open an app on a specified monitor, 3) switch to another desktop. Count Monitors and Check it can see left-most, central, and right-most monitors: ; init DetectHiddenWindows, Off v_LeftMost := 0 v_Center := 0...

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

    name if a file with the same name exists. ; ; Date (v1.0): 8 July 2020 ; - Initial Release ; Date (v1.1): 10 August 2020 ; - Checks for duplicates done by searching its own column. ; - Also checks for duplicates if file exists. ; - Leaves original file...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: *
  7. Privacy Policyhttps://www.joellipman.com/component/content/article/privacy-policy.html?catid=50&Itemid=165

    with this privacy statement. Joel Lipman .Com may change this policy from time to time by updating this page. You should check this page from time to time to ensure that you are happy with any changes. This policy is effective from the 1st of January...

    • Type: Article
    • Author: Joel Lipman
    • Category: Static Items
    • Language: en-GB
  8. MS-DOS: Copy folders without overwriting fileshttps://www.joellipman.com/component/content/article/ms-dos-copy-folders-without-overwriting-files.html?catid=51&Itemid=165

    source; run again in m minutes Time, if changed. /RH:hhmm-hhmm :: Run Hours - times when new copies may be started. /PF :: check run hours on a Per File (not per pass) basis. /IPG:n :: Inter-Packet Gap (ms), to free bandwidth on slow lines. /SL :: copy...

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

    is Joe's Password Analyzer? Joe's Password Analyzer is an online tool that quickly checks any password you might want to try using and suggests variations on this. Simply type a word or phrase in the input field and let it do the rest. Background Joe's...

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

    other valid values are: categories contacts newsfeeds weblinks To determine yours, do a standard search on your website and check the search results page. There should be several additional options to your search that will be displayed under the "Search...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  11. Zoho Deluge - Generate 5 Letter Booking Retrieval Codehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-generate-5-letter-booking-retrieval-code.html

    { // init b_BadWordFound = false; // get attempt v_Output = thisapp.generateRetrievalCode(); // see if can use contains but check for word for each v_BadWord in l_BadWords { if(v_Output.indexOf( v_BadWord ) >= 0) { b_BadWordFound = true; } } // if not...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  12. Zoho Deluge: Convert Xero Date (Unix Timestamp) to Standard Date Stringhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-convert-xero-date-unix-timestamp-to-standard-date-string.html

    v_ZohoTime = v_ZohoEpoch.toLong().toTime("yyyy-MM-dd HH:mm:ss", v_ZohoTZ); info v_ZohoTime; // check if timezone was included or not v_RegexPattern = "/Date\((\d+)([+-]\d{4})?\)/"; v_ZohoEpoch = v_XeroTime.replaceAll(v_RegexPattern,"$1",false); info...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  13. Zoho Deluge: Setup an API Connection for InvokeURLhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-setup-an-api-connection-for-invokeurl.html

    the Connector How do I determine what datacenter to use? To find out which datacenter your client/customer is using in Zoho, check the domain and specifically the top-level-domain (TLD) part. For example, if it says zoho.com, then this means the US...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  14. Zoho Deluge: Search Records with Special Characters (COQL)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-search-records-with-special-characters-coql.html

    } Note that for the above, if there are no matching records, r_Coql will simply return an empty string. Hence the check for isNull on the keys info and data. And yes, the part that took me about 8 hours and the key point above is to replace the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  15. Zoho Creator: Download File from ZohoCRM field type "File Upload" (not attachments)https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-download-file-from-zohocrm-field-type-file-upload-not-attachments.html

    v_PublishKey = "abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKL"; // // check if already exists (double-security: Email and File Ref must match) r_CreatorFile = Download_File[Owner_Email ==...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  16. Zoho Creator: Two submit buttons on a non-stateless form with 2 different redirectshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-two-submit-buttons-on-a-non-stateless-form.html

    Choose Field "Save & Close" Name the workflow "OnSubmit_SaveClose" Add your deluge code that should: Validate the fields (checks mandatory fields have been entered) for example: // // check mandatory fields have been entered l_Errors = List();...

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

    = ""; // // eval v_BooksOrgID = 12345678901; r_SoDetails = zoho.crm.getRecordById("Sales_Orders",p_SoID); // // check if owner and get matching salesperson ID if(!isnull(r_SoDetails.get("Owner"))) { v_OwnerID = r_SoDetails.get("Owner").get("id");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  18. Zoho Deluge: Date from a String (dd/MM/yyyy to yyyy-MM-dd)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-date-from-a-string-dd-mm-yyyy-to-yyyy-mm-dd.html

    Tue, 7 Jan 1975 ********************* 1975-01-07 07-Jan-1975 Tue, 7 Jan 1975 Additional You would of course need to check that there is nothing wrong with the date that was submitted. Especially if it is coming from a data source, the Zoho deluge...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  19. Zoho CRM: Permission Denied for Quote Conversion Mappinghttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-permission-denied-for-quote-conversion-mapping.html

    on "Save" Re-click on "Organize Modules" and disable the "Invoices" module. Test converting a quote to a sales order and check the fields mapped correctly. Source(s): the amazing Zoho Support team

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  20. Zoho Creator: Prevent Endless Loops On User Input of a Fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-prevent-endless-loops-on-user-input-of-a-field.html

    of fields. if(zoho.currenttime > input.DateTime_form_was_loaded.addSeconds(10)) { // do my stuff here } Method #2: Boolean checkbox to switch on/off workflow Another method I tried was adding a checkbox/decision box (boolean) to the form called...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
Results 81 - 100 of 176