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

  1. Quadcopter App with Flight Restrictions (JQA)https://joellipman.com/component/content/article/quadcopter-app.html?catid=53&Itemid=165

    (preferably "iso-3166-1 alpha-2") to the name if the location of the same name exists in multiple countries of the world. Zones (circles on map): Static Zones are created based on a listed airport, airfield, military, private or listed building. Dynamic...

    • Type: Article
    • Author: Joel Lipman
    • Category: Product Documentation
    • Language: *
  2. Zoho Creator: Set Up Custom Domain for Customer Portalhttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-set-up-custom-domain-for-customer-portal.html

    is complete. Find the DNS Manager in your control panel, it might be called something like "Advanced DNS Editor", "Advanced Zone Editor" or "DNS Zone Editor": If the subdomain has a CNAME record, modify it as per the below (not the "Name" just the...

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

    %X locale's time representation (%H:%M:%S) Date and Time %c locale's date and time Sat Nov 04 12:02:33 EST 1989 Time zone %z -zzzz RFC-822 style numeric timezone -0500 %Z time zone (e.g., EDT) nothing if no time zone is determinable EST

    • Type: Article
    • Author: Joel Lipman
    • Category: Linux
    • Language: *
  4. T-SQL Conversion failed when converting the varchar to data type inthttps://joellipman.com/articles/else/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

    results. That's a lot of reading so here's the simple fix for my issue: Returning an error: LTRIM(RTRIM(rm.Name + ', ' + rm.[Zone] + ', ' + rm.[Capacity] + ', ' + rm.[Type] + ', ' + rm.[DeptId])) AS RoomDetails // yields Conversion failed when...

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

    // yields 15-Apr-2020 17:00:00 Update 2025 A few more years and a few more systems later, we need to parse out the timezone so its reusable, and also need to account for when timezone is not included in the Xero date/time: // REMINDER: Zoho Deluge...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  6. Zoho Creator/Deluge: Calculating with Timezone Offsethttps://joellipman.com/articles/crm/zoho/zoho-creator/zoho-creator-deluge-calculating-with-timezone-offset.html

    This is an article to remind me how to calculate various times for an appointment booking system based on the timezones of each party. Why? The use-case scenario is that our Creator server uses the US datacenter but has it's server timezone set to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Creator
    • Language: *
  7. Zoho CRM/Deluge: Get TimeZone Based on GeoCoded Address (Lat/Lng)https://joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-deluge-get-timezone-based-on-geocoded-address-lat-lng.html

    address from a Lead record to geocode into latitude and longitude coordinates to feed a third-party API which returns a timezone. Why? Our use-case is that we have a field called "Customer's Time Zone" on the lead record in ZohoCRM. It should be...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  8. ZohoCRM & Xero: Function to pull most recent quoteshttps://joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-xero-function-to-pull-most-recent-quotes.html

    article I wrote earlier but with quotes from Xero, things panned out differently: Date/Time values don't include a timezone Issues with tax rates meant replicating a tax list copy from Xero to Zoho the Client doesn't use the Items module in Xero and...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  9. Could not instantiate mail functionhttps://joellipman.com/articles/cms/joomla/could-not-instantiate-mail-function.html

    *not* be in the /etc/virtual/domainowners file. 4) The hostname must resolve. If not, add the required A records to the dns zone such that it does. 5) The directory /etc/virtual/hostname must exist.. (eg: /etc/virtual/server.domain.com). It must not...

    • Type: Article
    • Author: Joel Lipman
    • Category: Joomla
    • Language: *
Results 1 - 9 of 9