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

  1. AutoHotkey Format Date and Format Secondshttps://www.joellipman.com/component/content/article/autohotkey-format-date-and-format-seconds.html?catid=48&Itemid=165

    you can tell these are my messed up functions that convert dates into seconds and vice-versa. They're a little disorganised but they're the ones I copy and paste to my scripts then modify. In it's straightforward form FormatTime( TimeString, Format ) {...

    • Type: Article
    • Author: Joel Lipman
    • Category: AutoHotkey
    • Language: en-GB
  2. 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

    In addition, there are some developments on AutoHotkey forums where people are having difficulties opening an app on their second monitor. So I thought I'd jot down some notes here on how I've achieved this across multiple monitors... and now multiple...

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

    the censor system is against the rules. If you break one of these rules, the following penalties will apply (first time, second time, third time...) with the exception of breaking the rule "No Hacking" which immediately results in a permanent ban:...

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

    the following error after upgrading/installing this module: Warning: in_array() [function.in-array]: Wrong datatype for second argument in /public_html/modules/mod_quicklistweblinks/helper.php on line 214 This is because you have not selected a...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  5. Quadcopter App with Flight Restrictions (JQA)https://www.joellipman.com/component/content/article/quadcopter-app.html?catid=53&Itemid=165

    - Map: lock map orientation to device compass - Map: replace map compass - Map: tap once to start a waypoint - Map: tap a second time to end waypoint - Map: drag markers for precision - Map: horizontal sensor level - Map: display gallery of screenshots...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  6. Zoho CRM: APIv2 using PHP & cURLhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-apiv2-using-php-curl.html

    API v2 using PHP and cURL. The first few functions are to manage OAuth v2 and generate the refresh and access tokens. The second snippet of code below is using the functions to read data from Zoho CRM and to write data back to the system. Why? I've...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: en-GB
  7. Zoho Deluge - First Monday of Month or Last Tuesday of Monthhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-first-monday-of-month-or-last-tuesday-of-month.html

    occurrence if(v_InputSwitch.toString().indexOf("First") >= 0) { v_DayOccur = 1; } else if(v_InputSwitch.toString().indexOf("Second") >= 0) { v_DayOccur = 2; } else if(v_InputSwitch.toString().indexOf("Third") >= 0) { v_DayOccur = 3; } else...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  8. Zoho Creator: Expecting ZC_SUBFORM_250 expression found COLLECTIONhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-expecting-zc-subform-250-expression-found-collection.html

    subform when I need to use "INSERT" method twice and not the equals sign: once to add the row to the collection, and the second time to add the collection to the subform. Syntax for inserting a row into a subform: // declare a variable to hold the...

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

    same popup will appear if you click on the edit icon in the header "Tax" (applies to subtotal). Note: If you do not do the second section as per this article, even having customized the tax rates, when selecting a product that has no tax rates against...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  10. Zoho Creator: Receive eBay Order Notifications via Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-receive-ebay-order-notifications-via-webhook.html

    { // info "New Token Generated"; r_Api.Access_Token=r_eBayResponse.get("access_token"); v_AccessSeconds = r_eBayResponse.get("expires_in").toLong(); r_Api.Access_Token_Expiry=zoho.currenttime.addSeconds(v_AccessSeconds); v_Output = r_Api.Access_Token; }...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  11. Zoho Deluge: Generate a loop or list of any sizehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-generate-a-list-of-any-size.html

    for the upcoming week. How? As mentioned, using leftpad takes 2 parameters, the first is the string to start with, the second is the number of spaces to pad with. // // set number of times to iterate through loop (plus 1) v_CheckDaysAhead = 7; // //...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  12. Zoho Books: Generate Bank Text File for Downloadhttps://www.joellipman.com/articles/crm/zoho/zoho-books/zoho-books-generate-bank-text-file-for-download.html

    disassociating it from the attachments), will remove the file permanently. You only need to run either of these as the second one runs both (disassociate and delete): // disassociate as attachment (removes attachment from the Bill but keep in ZohoBooks...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Books
    • Language: *
  13. Zoho Deluge: Nested Catch Statementshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-nested-catch-statements.html

    we have added a bit of code for it to try one server first, if there is any kind of an error with that server, it tries a second server... We now want to add a third server to try if the first 2 fail for whatever reason. How? Admittedly, perhaps this...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  14. Zoho Deluge: Using Remove Key on a Map and Copying Record Tagshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-using-remove-key-on-a-map.html

    wasn't. There is an additional/repeat action to add tags; the first attempts to copy over the color on a new tag; the second is if this fails to copy over the color (because there is an existing tag with the same name), then it only copies over the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  15. Zoho Survey & Zoho Analytics: Query to generate individual responses and grouped pageshttps://www.joellipman.com/articles/crm/zoho/zoho-analytics/zoho-survey-zoho-analytics-query-to-generate-individual-responses-and-grouped-pages.html

    ) AS r3 ON r3."Respondent ID" = r."Respondent ID" WHERE p."Title" 'GENERAL' ZohoSurveys - Page Responses Query This is a second query which queries the first query... Well it's for the radar chart and what it does is group all the responses per page...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Analytics
    • Language: *
  16. Google Authentication - OAuth 2.0 using PHP/cURLhttps://www.joellipman.com/component/content/article/google-authentication-oauth-2-0-using-php-curl.html?catid=61&Itemid=165

    in a file, then the JWT is also in the file. A JWT is a three part value delimited by a period/dot. Base64 decode the second part and this will reveal the user's name and email (along with other profile settings) which you will have to be careful on...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  17. Google Drive API v3 - OAuth2 using Service Account in PHP/JWThttps://www.joellipman.com/component/content/article/google-drive-oauth-using-service-account-in-php.html?catid=61&Itemid=165

    check your base64 encoded strings at JWT.io then it's hard because the timestamps, included in the encoding, change every second. You can get it verifying the signature successfully if you go get your public key, paste both keys into jwt.io (these don't...

    • Type: Article
    • Author: Joel Lipman
    • Category: Google
    • Language: en-GB
  18. SSIS Skip Blank Rows in Flat File Sourcehttps://www.joellipman.com/component/content/article/ssis-skip-blank-rows-in-flat-file-source.html?catid=74&Itemid=165

    ones may return special chars rather than Null). My example here is that the first column is our employee number and the second column will be the remaining data on that row. So I setup my connection manager as follows (note the "Ragged Right" and...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Integration Services
    • Language: en-GB
  19. Alternate row background colour in Reporting Serviceshttps://www.joellipman.com/component/content/article/alternate-row-background-colour-in-reporting-services.html?catid=75&Itemid=165

    in the dataset and not for a particular drill-down item. It will alternate between the two for the rest of the report. [The second example is what I use most frequently]. Additional: Suppose you have lots of columns, you don't want to have to click on...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
  20. Room Availability Calendar in Business Intelligence Development Studiohttps://www.joellipman.com/component/content/article/room-availability-calendar-in-business-intelligence-development-studio.html?catid=75&Itemid=165

    will display the details). I've used a UNION clause which will hopefully make all rooms (even empty ones) display. Note the second select statement (to list all the rooms) has to have the same number of fields as the first statement. This is the final...

    • Type: Article
    • Author: Joel Lipman
    • Category: SQL Server Reporting Services
    • Language: *
Results 21 - 40 of 68