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

  1. Alternative method of displaying Unicode in Autohotkey GUIhttps://www.joellipman.com/component/content/article/alternative-method-of-displaying-unicode-in-autohotkey-gui.html?catid=48&Itemid=165

    │ box drawings light vertical 180 B4 U+2524 ┤ box drawings light vertical and left 181 B5 U+2561 ╡ box drawings vertical single and left double 182 B6 U+2562 ╢ box drawings vertical double and left single 183 B7 U+2556 ╖ box drawings down double and...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  2. Zoho Creator: Shopify API Integration Oauth 2.0 - Update 2022 (Search by SKU GraphQL)https://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-shopify-api-integration-oauth-2-0-update-2022.html

    store all the keys in a Zoho Creator form (I call mine "API Integration") ready with the following fields: Connection Name (Single Line) Dev ID (Single Line) Client ID (Single Line) Shop ID (Single Line) Client Secret (Single Line) Location ID (Single...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  3. JDatabase: using the Joomla database with exampleshttps://www.joellipman.com/articles/cms/joomla/jdatabase-using-the-joomla-database.html

    'user_name'))) ->from($db->quoteName('#__users')) ->where($db->quoteName('user_id') . '=42') ->order('date_modified ASC'); Single Value Result This type of query is for when you want just one value from one column and one particular row. $db =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: en-GB
  4. Zoho Deluge - Multi-line Variable Assignments and Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-multi-line-statements-using-semi-colon-termination.html

    useful to be aware of if you have not come across it before. Why? In many Deluge scripts, assignments are often more than a single value. At times, it can be useful to copy and paste or temporarily format logic across multiple lines to improve...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  5. T-SQL functions to convert Strings to Tableshttps://www.joellipman.com/articles/else/database/t-sql/t-sql-functions-to-convert-strings-to-tables.html

    the space separated string ** Assumptions : None ** Inputs : @StringInput = the space separated string values ** Outputs : Single table ** Output Rows : One row per space separated string value ** Return Values : None...

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

    identifiable patents in that country that you have reason to believe are valid. If, pursuant to or in connection with a single transaction or arrangement, you convey, or propagate by procuring conveyance of, a covered work, and grant a patent license to...

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

    mine in this example: Download File to hold the file and some other fields Owner Email (type: Email) FIle Name (type: Single Line) File Ref (type: Single Line) Expiry Date Time (type: Date-Time) File Download (type: File upload) Create a connection in...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  8. Zoho Deluge: Handle Commas between Quotes in a CSV (and New Lines)https://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-handle-commas-between-quotes-in-a-csv.html

    Replace all commas in between a pair of double-quotes: Well I couldn't find a single regex that can do this in one go but by applying the same regex to the same value (line 29), solved this for the sample data. If you are expecting a 3rd comma in the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  9. Zoho CRM & Creator: Download attachment and upload to Creator file fieldhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-creator-download-attachment-and-upload-to-creator-file-field.html

    "Attachments" (links to a form called "Documents") Here's the Creator form to hold the Attachments: Parent Record (a single line that will be a unique ref to prevent downloading the same record again and again) Document Name (a single line that will be...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. ZohoRecruit: Create Linking Table for Candidates and Associated Job Openingshttps://www.joellipman.com/articles/crm/zoho/zoho-recruit/zohorecruit-create-linking-table-for-candidates-and-associated-job-openings.html

    Candidates module Job Opening: Lookup to the Job Opening module (called "Vacancies" in client's system) Candidate Ref: A single line text field Vacancy Ref: Another single line text field Candidate x JobOpening Name: Mandatory name field that we will...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Recruit
    • Language: *
  11. Zoho Projects: Get All Eventshttps://www.joellipman.com/articles/crm/zoho/zoho-projects/zoho-projects-get-all-events.html

    ]; l_FutureEvents = ifnull(r_FutureEvents.get("events"),List()); Additional: Code to get a single event: The above is great on a test system where you don't have many events, but what if this the system has far more than 50 events, past or upcoming?...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Projects
    • Language: *
  12. Zoho Creator: Input Color Pickerhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-input-color-picker.html

    field, I've given it the field link name "Note_ColorPicker_Css" Add a radio field type, I've called it "Color Picker" Add a single line text field, I'm calling it "Hexadecimal" [Key field that will be used by the application later - so perhaps rename...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  13. Upload file to Google Drive with PHP/cURL and API REST v3 (without Client Library)https://www.joellipman.com/component/content/article/upload-file-to-google-drive-with-php-curl-and-api-rest-v3-without-library-install.html?catid=61&Itemid=165

    is a function sending two requests, the second is the appropriate multipart function which uploads and names the file in a single request, and the third is a 'nice-to-have' upload to the specified folder. Method #1: two requests 1. Send the media file...

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

    crontab file and cron job directory. Change these for your system. CRONTAB='/etc/crontab' CRONDIR='/etc/cron.d' # Single tab character. Annoyingly necessary. tab=$(echo -en "\t") # Given a stream of crontab lines, exclude non-cron job lines, replace #...

    • Type: Article
    • Author: Joel Lipman
    • Category: Linux
    • Language: *
  15. SSRS Stop Scrolling Behindhttps://www.joellipman.com/component/content/article/ssrs-stop-scrolling-behind.html?catid=75&Itemid=165

    Business Intelligence Development Studio What? I recently revamped our standard report with a new template comprising of a single Tablix which contained the images of the corners and sides of the report. It looked beautiful if simply displayed on a...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: en-GB
  16. Regular Expression Basic Usage Exampleshttps://www.joellipman.com/articles/cms/website-development/regular-expression-basic-usage-examples.html

    A quick reminder on basic regular expressions. Match Any Character — Dot The dot operator '.' matches any single character in the current character set. For example, to find the sequence--'a', followed by any character, followed by 'c'--use the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Web-Development
    • Language: *
  17. PC Build 2022: 5 Monitors connected to 1 PC using 1 GPUhttps://www.joellipman.com/component/content/article/pc-build-2022-5-monitors-connected-to-1-pc-using-1-gpu.html?catid=45&Itemid=165

    to one of the Acer monitors DisplayPort to DVI (had to purchase this cable - twice as 2nd was dual-link and worked, first single-link didn't) to the 2nd Acer monitor. DisplayPort to Mini-DisplayPort: from the Graphics Card DP port to the first Dell...

    • Type: Article
    • Author: Joel Lipman
    • Category: Articles
    • Language: *
  18. Zoho Deluge - Some Useful Regular Expressionshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-some-useful-regular-expressions.html

    // NB: "1mySep2mySep3mySep4mySep5".toList("mySep"); // yields list of [1,2,3,4,5] Replace any multiple spaces with a single space: v_MyString = "Hello World!"; v_FormattedString = v_MyString.replaceAll("[ ]+"," ",false); // yields Hello World! Remove...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  19. Zoho Creator: Button on Report for Merging Multiple Selected Recordshttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-button-on-report-for-merging-multiple-selected-records.html

    The example below documents a report of Quotes where we want to merge all the product line items of each quote into one single quote. Why? I've written this article because I keep forgetting on how to do this. I have a specific order of steps on how I...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  20. Zoho Deluge: Generate and Send a CSV via Emailhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-generate-and-send-a-csv-via-email.html

    to: zoho.adminuserid subject: v_Subject message: v_Message attachments:file:v_CSVFile ]; Issue(s): CSV being returned in a single line, consider different methods of inserting a new line: Joel Lipman: ZohoDeluge: Inserting a new line character in a CSV

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