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

  1. Zoho Deluge: Generate List of TimeZoneshttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-generate-list-of-timezones.html

    Reykjavik (GMT+0:00) St Helena (GMT+0:00) GMT (no daylight saving) (GMT+1:00) Dublin (GMT+1:00) Lisbon (GMT+1:00) London (GMT+1:00) Algiers (GMT+1:00) Bangui (GMT+1:00) Brazzaville (GMT+2:00) Ceuta (GMT+1:00) Douala (GMT+1:00) Kinshasa (GMT+1:00) Lagos...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  2. Zoho Deluge - Compare time and currenttime with timezonehttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-compare-time-and-currenttime-with-timezone.html

    compare it to the current time combined with a timezone. In this particular case, we will switch the current time to Europe/London (You can use an abbreviation such as GMT but this doesn't seem to check if daylight savings is in effect): Example of...

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

    = false; // // Login to Xero > Accounting > Accounting Settings > Financial Settings > Time Zone v_XeroTimeZone = "Europe/London"; // // hard-code Zoho timezone v_ZohoTimeZone = "Europe/London"; // // Xero Quote Statuses vs your CRM Quote Statuses...

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

    // IST is ambiguous (RFC 3339 / RFC 5322 :: use IANA instead) v_IanaTZname = "Asia/Calcutta"; //v_IanaTZname = "Europe/London"; v_ZohoTime = v_ZohoEpoch.toLong().toTime("yyyy-MM-dd HH:mm:ss", v_IanaTZname); // The best method is per client: // Login to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  5. Zoho Survey: Zoho CRM Webhookhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-survey-zoho-crm-webhook.html

    m_UpdateContact.put("Scheduled_Report_Generation_Time",zoho.currenttime.addHour(1).toString("yyyy-MM-dd'T'HH:mm:ss","Europe/London")); r_UpdateContact = zoho.crm.updateRecord("Contacts",m_ContactResult.get("id"),m_UpdateContact); info "Updating CRM...

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

    = r_ZohoTaxRates.toMap(); if(b_Debug) { info m_ZohoTaxRates; } // // server timezones v_XeroTimeZone = "Europe/London"; v_ZohoTimeZone = "Europe/London"; // // enter the CRM record ID of your integrations record (Xero Integration API) v_TokenCrmID =...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  7. Zoho Deluge - Get User Timezone, Country and Locationhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-get-user-timezone-country-and-location.html

    "England", "city": "Birmingham", "district": "", "zip": "B15", "lat": 52.4666, "lon": -1.9205, "timezone": "Europe/London", "isp": "University of Birmingham", "org": "The University of Birmingham", "as": "AS786 Jisc Services Limited", "asname": "JANET",...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: en-GB
  8. Zoho CRM/Creator - Common Errors & Gotchashttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zoho-crm-creator-common-errors-gotchas.html

    + v_TimeZoneStr; // value is "2020-02-10T11:49:12+01:00" // OR in some cases v_TimeZone = "Europe/London"; v_InsertDateTime = zoho.currenttime.toString("yyyy-MM-dd HH:mm:ss",v_TimeZone); Problem: ERROR_Invalid_Redirect_URI Can happen when trying to...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  9. Zoho Deluge: Determine if Daylight Savings are in effecthttps://www.joellipman.com/articles/crm/zoho/zoho-deluge/zoho-deluge-determine-if-daylight-savings-are-in-effect.html

    "+01:00", "+00:00"); // // usage v_SendToCRM_DateTime = zoho.currenttime.toString("yyyy-MM-dd'T'HH:mm:ss","Europe/London") + v_TimeZoneOffset; Note(s): This was done in ZohoCreator which was showing a timezone of -0700 or PDT irrespective of the...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho Deluge
    • Language: *
  10. Zoho Webhooks & Shopify API: Keep Disappearinghttps://www.joellipman.com/articles/else/e-commerce/shopify/zoho-webhooks-shopify-api-automatically-restore.html

    = Map(); m_WebhookLog.put("Name","Shopify - Inventory Update - " + zoho.currenttime.toString("yyyy-MM-dd HH:mm","Europe/London")); m_WebhookLog.put("Body",m_Payload.get("body")); m_WebhookLog.put("Event_Type","Inventory Update");...

    • Type: Article
    • Author: Joel Lipman
    • Category: Shopify
    • Language: *
  11. ZohoCRM: Daily Follow Up and Remind Record Owner to Convert Leadhttps://www.joellipman.com/articles/crm/zoho/zoho-crm/zohocrm-follow-up-and-remind-record-owner-to-convert-lead.html

    // // set timezone of this user (this CRM is set to GMT-07:00 with daylight savings in effect) v_ThisTimeZone = "Europe/London"; // // get details from lead record r_LeadDetails = zoho.crm.getRecordById("Leads",p_LeadID); // // get created time (no need...

    • Type: Article
    • Author: Joel Lipman
    • Category: Zoho CRM
    • Language: *
  12. T-SQL DateTimestampshttps://www.joellipman.com/articles/else/database/t-sql/t-sql-datetimestamps.html

    setup Windows XP SP3 MS SQL Server Management Studio 2008 SQL Server 2008 R2 Regional Setting: London BST (British Summer Time) Tuesday the 11th of October 2011 at 06:00am: CONVERT(CHAR(19), CURRENT_TIMESTAMP, 0) Oct 11 2011 6:00AM CONVERT(CHAR(8),...

    • Type: Article
    • Author: Joel Lipman
    • Category: Transact-SQL
    • Language: en-GB
  13. The Mermaidhttps://www.joellipman.com/component/content/article/the-mermaid.html?catid=96&Itemid=165

    lying down below. Then up spoke the Captain Of our gallant ship, And a fine old man was he. "I have married a wife in fair London town, But tonight she a widow will be, Will be, will be. But tonight she a widow will be." While the raging seas do roar,...

    • Type: Article
    • Author: Joel Lipman
    • Category: Hobbies
    • Language: *
  14. Joel's Reference to MidJourney v4 Promptshttps://www.joellipman.com/component/content/article/joel-s-guide-to-midjourney-prompts.html?catid=115&Itemid=165

    (Wasp) Botanical Fernaceous (Fern) Lupine Rosaceous (Rose) Backdrops Beach Car Desert Factory Forest Horizon Lake Lawn London Mountains New York Paris Piscine (Swimming Pool) Rooftop Snow Theatre Tokyo Warehouse More Art Terms These are ones mentioned...

    • Type: Article
    • Author: Joel Lipman
    • Category: Graphic Design
    • Language: *
Results 1 - 14 of 14